Answer Detail: RE: Using data source as procedure.

GeekInterview.com > Interview Questions > Oracle > Oracle Forms 4.0

Print |

Question: Using data source as procedure.

Answer: Why do we use data source as procedure in Oracle forms? What is the use of taking procedure as Data Source?

November 11, 2008 02:18:44	#1
rvnambiar	Member Since: November 2008 Total Comments: 1
RE: Using data source as procedure.
To increase the control and security To specify a Query at runtime, Eg: in case of manager logs in he can see more info wherein if its employee he will be able to see less data If you wanna specify any complicated business rule to be executed before getting data, you can achieve through the server side procedure which will be much faster.

Back To Question