Home » Developer & Programmer » Forms » Dynamic SQL
Dynamic SQL [message #270257] Wed, 26 September 2007 06:06 Go to next message
Messages: 83
Registered: September 2007
Location: India
I have a simple dynamic SQL like the below which is changing everytime in my oracle forms,,
eg... 'Select ''B'' from dual';
How can i return that value into a variable in form..
i used name_in('Select ''B'' from dual')..but it is returning the string inside it..wt to do if i need to get 'B' instead...?

Re: Dynamic SQL [message #270434 is a reply to message #270257] Wed, 26 September 2007 21:39 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Try 'Select ''B'' into :my_blk.my_itm from dual'

Previous Topic: Change title of a separate window
Next Topic: Sound when opening the form
Goto Forum:

Current Time: Sun Aug 20 10:37:54 CDT 2017

Total time taken to generate the page: 0.04550 seconds