Re: sqlplus command line using

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