gouthami kodangal

• Aug 13th, 2006

 

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

Maria Antony Samy

• Aug 29th, 2006

 

Hi Rajan,

I do not know what do you mean by application funciton/procedure. In Oracle terms, a PL/SQL block which is stored ( meaning, you define once; and you can call that procedure or function from other part of application; if you grant permission to others, they will also be able to acces that procedure or function ) in the database. Here youn can ask the question "What are the other type of procedure or functions available in Oracle?"...... The answer is, you can have a procedure or function defined within a pl/sfql block. This enables you to call that pro/function from that pl/sql block only. Moreover, you can define pro/function in packages aswell.

Are you clear now....? if not, do not hesitae to ask me...

Regards,

maria_antony2000@yahoo.com

srinivas

• Nov 29th, 2006

 

hi friend,

i think that there is no difference between stored procedure and applicaton procedure.both r stoed in the data base only they can call any where required what do say plz give me replaye by seeing this

Nishant Patel

• Jun 13th, 2007

 

The difference between the two can be categorised via: Stored subprograms ans Application subprograms
1) Stored subprograms: These are coded and compiled from within the Oracle database via SQL Plus etc.
2) Application subprograms: These are coded and compiled from within the Oracle development tools such as Oracle Developer.

g_sidhu

 Profile 

• Feb 4th, 2008

 

Application procedures or functions: Named PL/SQL blocks stored in an Oracle Forms Developer application or shared library; can accept parameters and can be invoked repeatedly by name and are available in Oracle Developer tools components, for example, Oracle Forms Developer, Oracle Reports.

Stored procedures or functions: Named PL/SQL blocks stored in the Oracle server; can accept parameters and can be invoked repeatedly by name and are available in Oracle server.