Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use last_query built in?

684380Jul 1 2009 — edited Jul 2 2009
Hi People

I would like to use last_query in order to obtain a query which is last executed.I used the following code to obtain the result.but i couldnt get it.i wrote this code in when-button-pressed trigger.
i.e,

declare
lst_q varchar(2000);
t varchar(2000);
begin
lst_q:=get_block_property('block3',last_query);
message(lst_q);
end;

Is this a right way to use the last_query variable?.pls suggest me.thanku

Regards
VIDS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2009
Added on Jul 1 2009
9 comments
7,799 views