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.
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.