Ravi

• Jul 21st, 2006

 

Use

1) exec <Procedure Name>    ---> To execute procedure

2) Desc < Procedure Name   ---> To describe a procedure

Naseem

• Aug 23rd, 2006

 

Executing a Procedure:

exec <procedure name>

To View a Procedure:

desc <procedure name > -- gives u only the in/out parameters used by procedure.

Select text from user_source where name = '<procedure name> -- gives u the whole procedure contents.

Shailu

• Oct 6th, 2006

 

When you try to execute procedure from procedure just  write procedure name. If you  are executing from SQL*Plus them write EXEC <procedureName>

Thanks, Shailu