Home » SQL & PL/SQL » SQL & PL/SQL » One time Only procedures (Oracle10g)
One time Only procedures [message #303343] Thu, 28 February 2008 23:27 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
Can you please explain me whats the use of one time only procedure with any application example.
Re: One time Only procedures [message #303356 is a reply to message #303343] Fri, 29 February 2008 00:16 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
In the example below, it is referred to as the "initialization part" of the emp_admin package:


http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/packages.htm#i4362
Re: One time Only procedures [message #303357 is a reply to message #303343] Fri, 29 February 2008 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=%22one+time+only+procedure%22&meta=

In Oracle, it is called "initialization code".

Regards
Michel
Re: One time Only procedures [message #303758 is a reply to message #303343] Sun, 02 March 2008 12:20 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,


In general, in Apex while you create a page with respect to
form, report, or process, there is a process function can be written as before header. ie while you entering into any page,
based on earlier pages visited and the values stored used for
the current page process. This sort of the procedures they have
written as one time only procedures. Further definition is
after you gone into page the one time procedure will never fired unless you copy the contents to difference processes.

If i am wrong please correct me..


yours
dr.s.raghunathan
Previous Topic: Nested cursors in nested loops
Next Topic: how to update a table using data from a different table
Goto Forum:
  


Current Time: Sun Dec 04 00:45:29 CST 2016

Total time taken to generate the page: 0.17221 seconds