OraFAQ Forum: SQL & PL/SQL » how to see the result after sucessfully create the stored procedure

Home » SQL & PL/SQL » SQL & PL/SQL » how to see the result after sucessfully create the stored procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to see the result after sucessfully create the stored procedure [message #429]

Mon, 11 February 2002 23:10

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:19:40 CDT 2024