Re: SQL*Plus GET command?? (newbie)

I suspect your script has some set statements in it eg 'set head off'

If you append ';' (semi colon) to the end of the set statements it should work fine.

Not quite sure why it works like this, it's something to do with the fact that all statements in the file are read as one when you do a get, putting a ';' after each individual command ensures that each statement is correctly terminated when you issue the run.  

jayvee_at_mayon.cats.edu.ph wrote in article <795jee$tds$1_at_nnrp1.dejanews.com>...
>
>
> The GET command reads a SQL file into its buffer.
> But then, when you issue the RUN command to execute what's
> in the buffer, it returns an error...when there isn't suppose
> to have any error, because if you just paste the SQL statement
> directly to SQL*Plus followed by a return. It works fine. Why?
>
> Thank you.
>
> (please reply by e-mail)
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Tue Feb 02 1999 - 02:53:28 CST