GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  General
Go To First  |  Previous Question  |  Next Question 
 General  |  Question 196 of 211    Print  
What is the difference between Anonymous Block and subprogram?
Can we call a procedure from Anonymous PL/SQL block?

  
Total Answers and Comments: 3 Last Update: March 28, 2006     Asked by: chiranjeevi reddy 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 20, 2006 05:28:58   #1  
chinnalogica Member Since: January 2006   Contribution: 6    

RE: What is the difference between Anonymous Block and...

Anonymous block are created on client and subprograms are stored on server.

It is possible to call subprograms from anonymous block.


 
Is this answer useful? Yes | No
February 22, 2006 00:36:27   #2  
Rav        

RE: What is the difference between Anonymous Block and...

Hi

Ananymous is also PL/SQL block but it is not named. So that these are not stored server for further reference. We can name the anonymous but still we can use withing the sub-program. Subprogram is a named PL/SQL block and will be stored in server. This is avaialble for reference.

Procedure can be called from anonymous block and reverse is not possible.

Regards
Ravi


 
Is this answer useful? Yes | No
March 28, 2006 16:35:35   #3  
Culver_lake Member Since: March 2006   Contribution: 46    

RE: What is the difference between Anonymous Block and...

dont confuse subprogram with stored procedure.

both anonymous block and subprogram are executed on the server. ALL pl/sql and SQL are executed on the server (ie by ORACLE). The anonynmous block is unnamed while the subprogram is named and can be called from the anonymous block and passed arguments as well. both the anonymous block and the named pl/sql subprogram can call external programs (like a C) program as well.


 
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