SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

After executing sql from batch, its disconnecting

Madhu.149Oct 10 2013 — edited Oct 10 2013

Hello All,

I have written a batch program to execute a pl/sql procedure. But after execution, it disconnects.

But i want to continue in the same session

echo exec tracer.trace_pck.start_('alter session set sql_trace=true') | sqlplus hr/hr

Output:

Press any key to Enable Tracing

SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 10 15:59:56 2013

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL>

PL/SQL procedure successfully completed.

SQL> Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 -

Production

Trace Enabled Successfully. Press any key to input you sql

This post has been answered by Keith Jamieson on Oct 10 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2013

Added on Oct 10 2013

5 comments

1,114 views