Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SP2-0734 errror URGENT

Re: SP2-0734 errror URGENT

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 9 Jan 2001 09:12:34 -0500
Message-Id: <10736.126122@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0009_01C07A1C.4DF26CA0 Content-Type: text/plain;

        charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

Should be :

SQL>execute dbms_out.put_line('.');

because it's not inside PL/SQL block.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com
 =20

  What is the cause of this error ..??

  SQL>set serveroutput on;
  SQL> dbms_output.put_line('.');
  SP2-0734: unknown command beginning "dbms_outpu..." - rest of line = ignored.



  Bunyamin K. Karadeniz
  Information Technologies Dept.
  Database Group Tel :90-312-2873565/1681   HAVELSAN Ankara / TURKEY

------=_NextPart_000_0009_01C07A1C.4DF26CA0 Content-Type: text/html;

        charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-9">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#a6caf0>
<DIV><FONT face=3DArial size=3D2>Should be :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>SQL&gt;execute =
dbms_out.put_line('.');</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>because it's not inside PL/SQL =
block.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>Igor Neyman, OCP DBA<BR>Perceptron, Inc.<BR>(734)414-4627<BR><A=20
href=3D"mailto:ineyman_at_perceptron.com">ineyman_at_perceptron.com</A><BR>&nbs= p;=20
<BR></DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3Dbunyamink_at_havelsan.com.tr=20   href=3D"mailto:bunyamink_at_havelsan.com.tr">bunyamin karadeniz</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, January 09, 2001 = 7:05=20
  AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> SP2-0734 errror = URGENT</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>What is the cause of this error = ..??</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><FONT face=3DArial = size=3D2>SQL&gt;</FONT>set=20
  serveroutput on;</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>SQL&gt; = dbms_output.put_line('.');<BR>SP2-0734:=20   unknown command beginning "dbms_outpu..." - rest of line = ignored.</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>   <DIV><FONT face=3DArial=20

  size=3D2>**********************************************<BR>Bunyamin K. =

  Karadeniz<BR>Information Technologies Dept.<BR>Database Group Tel=20   :90-312-2873565/1681<BR>HAVELSAN Ankara /=20   =

TURKEY<BR>**********************************************</FONT></DIV></BL=
Received on Tue Jan 09 2001 - 08:12:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US