top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+2 votes
397 views
What is difference b/w stored procedures and application procedures, stored function and application function?
posted Sep 17, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

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.

answer Sep 17, 2014 by Arun Gowda
...