RE: SP2-0103: Nothing in SQL buffer to run.

From: Behar, Rivaldi <Rivaldi.Behar_at_ilonafinancial.com>
Date: Thu, 07 Feb 2002 09:04:19 -0800
Message-ID: <F001.00409064.20020207090111@fatcity.com>

Try :

SQL> start c:\general\ksg\ProcDisp.sql

Rivaldi

-----Original Message-----
From: Krishan Gupta [mailto:k_s_gupta_at_yahoo.com] Sent: Thursday, February 07, 2002 10:32 AM To: Multiple recipients of list ORACLE-L Subject: SP2-0103: Nothing in SQL buffer to run.

Hi Oracle Gurus

This might be very silly problem for you gyus, but I am really geting headache. I suppose today my mind is not working in sync.

I am attatching the script which i wrote. When I try to execute on sql promp, I get the result like this :

SQL> @c:\general\ksg\ProcDisp.sql

SP2-0103: Nothing in SQL buffer to run.
SP2-0103: Nothing in SQL buffer to run.
SP2-0103: Nothing in SQL buffer to run.
SP2-0103: Nothing in SQL buffer to run.


|==============================================================================|

|Proc Name                     Proc Type              

                        |


|   Arguments Name                 Pos Data Type      

               IN-OUT   |
|==============================================================================|
|ADDCHARGETYPE                 PROCEDURE             

                        |


|                                                     

                        |


|   TVCCHARGETYPE                  1    VARCHAR2      

                IN      |


|   TVCGLNUMBER                    2    VARCHAR2      

                IN      |

I would appreciate If you help me getting rid of following messages :

SP2-0103: Nothing in SQL buffer to run.
SP2-0103: Nothing in SQL buffer to run.
SP2-0103: Nothing in SQL buffer to run.
SP2-0103: Nothing in SQL buffer to run.

I want comments to be /*   */ like only
TIA
Krishan Swarup Gupta

---

Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com Received on Thu Feb 07 2002 - 11:04:19 CST