Oracle PL-SQL Interview Question:

What is difference b/w stored procedures and application procedures, stored function and application function?

Submitted by: Administrator

Stored procedures are subprogrammes stored in the database and can be called &executee multiple times wherein an application procedure is the one being used for a particular application same is the way for function.

Both can be executed any number of times. Only difference is that stored procedures/ functions are stored in database in complied format while the application procedures/functions are not in precomplied format and at run time has to be compiled.
Submitted by: Administrator