SEO

#1 (**permalink**) 02-24-2008, 01:10 PM

hello there!

I have to insert some procedures, tables and sequences from command
shell. So I try to do so using sqlplus command line coupled to a SQL
file containing all my code..
But after parsing the file, SQLplus stays up and do not give hand back
to the OS, displaying a number which seems to be a line number..and I
must ctrl+c the app to then type 'exit'...

Any idea??

thanks a lot
Vince

#2 (**permalink**) 02-24-2008, 01:10 PM

Użytkownik Vince <vincent@ napisał:

> hello there!
>
> I have to insert some procedures, tables and sequences from command
> shell. So I try to do so using sqlplus command line coupled to a SQL
> file containing all my code..
> But after parsing the file, SQLplus stays up and do not give hand back
> to the OS, displaying a number which seems to be a line number..and I
> must ctrl+c the app to then type 'exit'...
>
Crystall Ball says:
- your script is buggy.

Eighter you got a blank lines, or a definition not properly ended.
Remember:

- blank lines fools sqlplus.

CREATE TABLE X
(
a number,

b number
);

- a ' ' before '/', which ends command, fools sqlplus eighter.

CREATE TABLE X
(
a number,
b number
)
/

If you want us to debug your script, kindly send a code.

--
Noel

#3 (**permalink**) 02-24-2008, 01:10 PM

Vince <vincent@ apparently said,on my timestamp of 4/05/2005 7:40 PM:

> But after parsing the file, SQLplus stays up and do not give hand back
> to the OS, displaying a number which seems to be a line number..and I
> must ctrl+c the app to then type 'exit'...

You forgot either a "/" or ";" to terminate and execute
the last SQL in the script.

--
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k@yahoo.com.au.nospam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

sqlplus command line using