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: 8737
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: 65144
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: Oracles Alternative For SQLServers Cross Apply (merged)
Next Topic: Unable to Load the English months in Staging Table.
Goto Forum:
  


Current Time: Sat Aug 19 21:25:05 CDT 2017

Total time taken to generate the page: 0.09719 seconds