| Forms_DDL [message #166206] |
Wed, 05 April 2006 02:55  |
s4sam
Messages: 18
Registered: October 2005
Location: pakistan
|
Junior Member |
|
|
hi,
I have used the following in when-button-pressed trigger.
Forms_DDL('
declare v_n number;
begin SELECT MAX(CUST_ID)
into v_n from cust;
end;
');
How can i display the value of v_n in :block.disp_item field of form.
|
|
|
|
| Re: Forms_DDL [message #166210 is a reply to message #166206] |
Wed, 05 April 2006 03:09  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Is there any particular reason why you are using Forms_DDL to execute this 'select' statement?
Store the value into a package variable (in the database) and then get it back when you return to the form. You can write a 'put' procedure in the package to store it and a 'get' function in the package to return the value.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
