Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 'Nothing in SQL buffer to run'
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
![]() |
![]() |