OraFAQ Forum: SQL & PL/SQL » Difference between application procedures and stored procedures

Home » SQL & PL/SQL » SQL & PL/SQL » Difference between application procedures and stored procedures

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between application procedures and stored procedures [message #39056]

Mon, 10 June 2002 21:01

Phan Kok Khuen
Messages: 3
Registered: June 2002

Junior Member

Can anyone explain to me what is the difference between application procedures and stored procedures? Where can I find related articles?

Report message to a moderator

Re: Difference between application procedures and stored procedures [message #39065 is a reply to message #39056]

Tue, 11 June 2002 10:56

andrew again
Messages: 2577
Registered: March 2000

Senior Member

"stored prodecures", "packages", "procedures", "functions" all have specific meaning in Oracle. They generally refer to compiled pl/sql in the database. "Java stored procedures" also exist.

application procedures have no specific meaning in Oracle. It could be a loose term someone is using - get them to give you a definition.

Report message to a moderator

Andrew right [message #39069 is a reply to message #39056]

Tue, 11 June 2002 13:47

ron
Messages: 50
Registered: July 1999

Member

Andrew right, even I am not familiar with that word.
stored procedure are procedures, that can be used or called when ever you want.

Report message to a moderator

Re: Difference between application procedures and stored procedures [message #39070 is a reply to message #39056]

Tue, 11 June 2002 17:46

Phan Kok Khuen
Messages: 3
Registered: June 2002

Junior Member

Me neither. I have looked through many references and I couldn't find any words referring to application procedure. It's my course assignment requirement that I need to cover application procedure. But I do have one hint. When I look at the study guide, it mentions that application procedure is used in Oracle Developer Forms. Are they related in some way?

Report message to a moderator

Re: Difference between application procedures and stored procedures [message #39074 is a reply to message #39056]

Wed, 12 June 2002 09:56

Frank Zhao
Messages: 5
Registered: June 2002

Junior Member

Application procedures are created in client side (for example, you use Forms Developer 6/6i) whereas the stored procedures are in Oracle Server Side.

Report message to a moderator

Previous Topic:	SQL Plus Configuration File
Next Topic:	Pre Sorted Table on column other than Primary Key(Very-very urgent)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 17:01:38 CDT 2024