OraFAQ Forum: Forms » Data block based on Stored procedure

Home » Developer & Programmer » Forms » Data block based on Stored procedure

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

Data block based on Stored procedure [message #132384]

Fri, 12 August 2005 06:36

techno
Messages: 44
Registered: October 2003

Member

Hi,
While creating data blocks through wizard, there are two options one is through table or view, other is through stored procedure
Can you tell me when is the later is useful and how it is used to create data block?

Thanks in advance

Report message to a moderator

Re: Data block based on Stored procedure [message #132431 is a reply to message #132384]

Fri, 12 August 2005 13:05

Tafer
Messages: 64
Registered: July 2005
Location: Here!

Member

Browse around this place:

http://ourworld.compuserve.com/homepages/Peter_Koletzke/conf.htm

For an introduction, look for this document:
What Do You Base Your Block On? (A little bit fancy, but useful)

Report message to a moderator

Re: Data block based on Stored procedure [message #132561 is a reply to message #132384]

Sun, 14 August 2005 19:37

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Stored procedures are used by the Oracle Designer. These procedures are paired with APIs that control the various database functions - insert/update/delete - and permit the business logic which is placed in the Designer to be actioned by the Forms software. It moves much of the code from the form to the database thereby reducing your network traffic.

David

Report message to a moderator