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

Home -> Community -> Usenet -> c.d.o.misc -> 'Nothing in SQL buffer to run'

'Nothing in SQL buffer to run'

From: Candy Robinson <candy_at_bcstec.ca.boeing.com>
Date: Mon, 8 Nov 1999 15:39:51 GMT
Message-ID: <ivaeopdmbc.fsf_-_@bcstec.ca.boeing.com>

Thanks for any help you can give:
 I get this 'Nothing in SQL buffer to run' message when I use sqlplus with  parameters as follows (if I allow it to prompt me for parameters, I don't  get this message):  

> sqlplus -s olti/<passwd>@gen1d @D182_OLTI 285W0029-1 PRELD
> Nothing in SQL buffer to run. <<<<<----------------This is the comment.
> <Rest of output is correct>
>
> The 285W0029-1 and PRELD are parameters &1 and &2, respectively. the
> D182_OLTI.sql code looks like this:
>
> set serveroutput off;
> set heading off;
> <etc, etc for settings>
> <variable definitions>
> execute rmote_olti ('&1','&2',:var1,:var2);
> <more sql statements>
>
> Thanks in advance! --Candy
> --
> Author: Robinson, Candy L

--
Sandra (Candy) Robinson candy.l.robinson_at_boeing.com 972-659-2558 Received on Mon Nov 08 1999 - 09:39:51 CST

Original text of this message

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