Re: sql*plus vs sql worksheet

Are you running these from the SQL*Plus buffer or are you starting them by name?

It's been my observation that SQL*Plus doesn't have a problem with ';' as long as you don't try to run the script from the SQL*Plus buffer.

To run the script directly, try typing from SQL*Plus '_at_yourscript.sql' (_at_ is a synonym for start)

I have many SQL scripts that contain semicolons -- and I run them this way.

Good Luck
-Ian

Jim Poe wrote:

> I have a number of scripts that work fine in sql worksheet. They fall
> over in sql*plus. The error is 'invalid character' and it indicates
> that the terminating ';' is invalid.
>
> Is there a way to write scripts that will work in both tools?
> --
> Jim Poe
> <jpoe_at_fulcrumit.com>
> Fulcrum InteTech, Inc.
Received on Fri Jan 29 1999 - 19:37:39 CET