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: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Tue, 9 Jan 2001 08:05:18 -0800
Message-Id: <10736.126156@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07A55.F5EE2E10
Content-Type: text/plain;

        charset="iso-8859-1"

Actually, it is valid syntax but you cannot issue PL/SQL from SQL with out the execute command or putting it in an PL/SQL block with the begin and end.  

-----Original Message-----
From: Mark Leith [mailto:mark_at_cool-tools.co.uk] Sent: Tuesday, January 09, 2001 6:26 AM
To: Multiple recipients of list ORACLE-L Subject: RE: SP2-0734 errror URGENT

It is an ivalid command. I don't know the syntax - sorry - but it isn't that:)  

Regards  

Mark

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of bunyamin karadeniz
Sent: Tuesday, January 09, 2001 12:06
To: Multiple recipients of list ORACLE-L Subject: SP2-0734 errror URGENT

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_001_01C07A55.F5EE2E10
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#a6caf0>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=166580016-09012001>Actually, it is valid syntax but you cannot issue PL/SQL from SQL with out</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=166580016-09012001>the
execute command or putting it in an PL/SQL block with the begin and end.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=166580016-09012001></SPAN></FONT>&nbsp;</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

  <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Mark Leith   [mailto:mark_at_cool-tools.co.uk]<BR><B>Sent:</B> Tuesday, January 09, 2001 6:26   AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE:   SP2-0734 errror URGENT<BR><BR></DIV></FONT>   <DIV><FONT color=#0000ff face="Arial TUR" size=2><SPAN   class=515511714-09012001>It is an ivalid command. I don't know the syntax -   sorry - but it isn't that:)</SPAN></FONT></DIV>   <DIV><FONT color=#0000ff face="Arial TUR" size=2><SPAN   class=515511714-09012001></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT color=#0000ff face="Arial TUR" size=2><SPAN   class=515511714-09012001>Regards</SPAN></FONT></DIV>   <DIV><FONT color=#0000ff face="Arial TUR" size=2><SPAN   class=515511714-09012001></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT color=#0000ff face="Arial TUR" size=2><SPAN   class=515511714-09012001>Mark</SPAN></FONT></DIV>   <BLOCKQUOTE style="MARGIN-RIGHT: 0px">     <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma     size=2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com     [mailto:root_at_fatcity.com]<B>On Behalf Of </B>bunyamin     karadeniz<BR><B>Sent:</B> Tuesday, January 09, 2001 12:06<BR><B>To:</B>     Multiple recipients of list ORACLE-L<BR><B>Subject:</B> SP2-0734 errror     URGENT<BR><BR></DIV></FONT>
    <DIV><FONT face=Arial size=2>What is the cause of this error     ..??</FONT></DIV>
    <DIV>&nbsp;</DIV>

    <DIV><FONT face=Arial size=2><FONT face=Arial size=2>SQL&gt;</FONT>set 
    serveroutput on;</FONT></DIV>
    <DIV><FONT face=Arial size=2>SQL&gt; dbms_output.put_line('.');<BR>SP2-0734: 
    unknown command beginning "dbms_outpu..." - rest of line     ignored.</FONT></DIV>
    <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>     <DIV><FONT face=Arial
    size=2>**********************************************<BR>Bunyamin K. 
    Karadeniz<BR>Information Technologies Dept.<BR>Database Group Tel     :90-312-2873565/1681<BR>HAVELSAN Ankara /
    TURKEY<BR>**********************************************</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
Received on Tue Jan 09 2001 - 10:05:18 CST

Original text of this message

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