Search Results

methyl,

I checked it now..Spool is working for the DB connection as well as for the sql statements.

Thanks!!

|& is to open the sqlplus thread asynchronously in the background, and we enter the sql statements in the pipe using print p.

removing -s is of no use as I am still not able to capture the errors...

Hi,

I am trying to write a generic script as a part of a framework which will establish Oracle DB connection once and loops in to check for some files which gives the SQL statements to execute.
...