| PL/SQL table in forms [message #289938] |
Wed, 26 December 2007 15:26  |
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 #290191 is a reply to message #289938] |
Thu, 27 December 2007 22:50  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
