Home » SQL & PL/SQL » SQL & PL/SQL » how to see the result after sucessfully create the stored procedure
how to see the result after sucessfully create the stored procedure [message #429] Mon, 11 February 2002 23:10 Go to next message
ranjan kumar dash
Messages: 15
Registered: February 2002
Junior Member
suppose i create a stored procedure and after giving / in sql promt it will show that procedure created sucessfully.
then how can we see the result for that we create the stored procedure
I think the step is SQL>set serveroutput on
then sql>exec "procedure_name"
please explain me
Re: how to see the result after sucessfully create the stored procedure [message #430 is a reply to message #429] Mon, 11 February 2002 23:40 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi ranjan,

you are right.
SQL>set serveroutput on
SQL>exec "procedure_name"

it will show any tracing u have put in the console

cheers
pratap
Previous Topic: SELECT help
Next Topic: IMP-00019: row rejected due to ORACLE error 1
Goto Forum:
  


Current Time: Fri Aug 14 10:02:06 CDT 2020