GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 28 of 81    Print  
how to execute and view the procedures in oracle?

  
Total Answers and Comments: 3 Last Update: October 06, 2006     Asked by: vasant 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 21, 2006 01:05:40   #1  
Ravi        

RE: how to execute and view the procedures in oracle?

Use

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

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


 
Is this answer useful? Yes | No
August 23, 2006 01:04:55   #2  
Naseem        

RE: how to execute and view the procedures in oracle?

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.


 
Is this answer useful? Yes | No
October 06, 2006 06:12:13   #3  
Shailu        

RE: how to execute and view the procedures in oracle?

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


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape