Thank you in advance. But after I visit the link. I found that command can't be run in form 6i front-end. Do you have solution to substitute that command by using another command that synchrone with exec immediate but it can runs in form6i front-end. Regards, Mave ----- Original Message ----- From: "Oded Maimon" <oded.maimon@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Subject: Re: exec_immediate Date: Thu, 07 Jul 2005 12:34:04 +0200 > > i believe this is "execute immediate" without the underscore (or > "exec immediate" for shortcut), > > you just run something like that " exec immediate 'update tab set col=2' " > > there is more options to use with bind variables and selecting into > parameters and so, but this is in the documentation. > > or (the first thing in google search for "oracle execute > immediate") > http://www.dbasupport.com/oracle/ora9i/execute_immediate.shtml > > > if i remember correctly you can use it forms. > > > Maverick Gaulet wrote: > > > Hi all, > > > > Pls anyone on this list, pls give me a simple explanation about > > what is 'exec_immediate' and how to use it. Can I use that syntax > > in oracle developer-form 6i? > > > > > > TIA > > > > sony > > > > > > > -- > //www.freelists.org/webpage/oracle-l -- _______________________________________________ NEW! Lycos Dating Search. The only place to search multiple dating sites at once. http://datingsearch.lycos.com -- //www.freelists.org/webpage/oracle-l