The error implies that the script is trying to execute sql that is in the
buffer, but there is nothing there. You can reproduce this error yourself
by typing "/" without the quotes in SQLPlus. Sorry I can't be any more
specific.
--
Dave A
<woodsyj_at_my-deja.com> wrote in message news:8u6umo$mi4$1_at_nnrp1.deja.com...
> I have been running a backup script for a few weeks now, and it ran
> fine. I am now having a problem running it because I am getting a 'SP2-
> 0103: Nothing in SQL buffer to run' error. my script dynamically
> creates another script, then runs it (at least that is what it is
> supposed to do.) When running, the script is created but when the new
> script attempts to run, I get the error. This is also in a cron job on
> Solaris 2.7. I tried to test by simulating the script without having
> to take down the database, and it worked fine. I am wondering if it is
> a permissions problem since the main script is being run by root.
>
> Any suggestions would be greatly appreciated.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 06 2000 - 21:11:46 CST
