Running pl/sql in Korn Shell(AIX)

Posted by learner135 on Stack Overflow See other posts from Stack Overflow or by learner135
Published on 2010-05-31T09:15:31Z Indexed on 2010/05/31 9:32 UTC
Read the original article Hit count: 313

Filed under:
|
|
|
|

I have a file to execute in Ksh written by someone. It has a set of commands to execute in sqlplus.

It starts with,

sqlplus -s $UP <<- END

followed by a set of ddl commands such as create,drop,etc.,

When I execute the file in the shell, I get the error in the starting line quoted above. I understand "-s" starts the sqlplus in silent mode and $UP is the connection string with username/password. But I couldn't make heads or tails of "<<- END" part(Many sites from google says input redirection is "<<" not "<<-"). So I presumed the error must be in that part and removed it from the file. Now it reads,

sqlplus -s $UP 

But once I execute the file, It waits for input from the shell, instead of reading the rest of the lines from the file. How would I make sqlplus to execute the ddl commands in the rest of the file?. Thanks in advance.

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about unix