Home » Developer & Programmer » Forms » PL/SQL table in forms
PL/SQL table in forms [message #289938] Wed, 26 December 2007 15:26 Go to next message
shivaram9
Messages: 35
Registered: August 2006
Member
Hi All,

I have a form, need to store item information in a PL/SQL table (pl/sql table defined in db package) in when new form instance, and need to use the data stored in this PL/SQL in another button.

Problem:
if i want to use this pl/sql table in the button, i need to declare this pl/sql table in that button and i will loose the data stored in this pl/sql table from when new form instance.

Is PL/SQL table a better option or .... can any one suggest me some other good method (other than db table).

Thanks,
Shiva
Re: PL/SQL table in forms [message #289941 is a reply to message #289938] Wed, 26 December 2007 15:47 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

I need to store item information in a PL/SQL table

Why?

Quote:

Can any one suggest me some other good method?

An ordinary table? Perhaps a global temporary table?
Re: PL/SQL table in forms [message #290191 is a reply to message #289938] Thu, 27 December 2007 22:50 Go to previous message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
hi,

i think you can create a package containing a pl/sql table in the program unit of the form.
In the when-new-form-instance, you can populate the pl/table and you can use the data in the when-button-pressed trigger.

Minto
Previous Topic: Hot key in developer 6i
Next Topic: Clearing those records of a multirecord if the checkbox associated with them is unchecked
Goto Forum:
  


Current Time: Sun Dec 04 06:21:56 CST 2016

Total time taken to generate the page: 0.04761 seconds