Home » Developer & Programmer » Forms » dynamic sql
dynamic sql [message #80633] Thu, 24 October 2002 00:19 Go to next message
harish agarwal
Messages: 38
Registered: September 2002
Member
hi all
can we create table dynamically from forms 6i.
I tried with 'when-button-pressed' trigger
Execute immediate 'create.....');
it's showing error;
please help
thank u
harish
Re: dynamic sql [message #80636 is a reply to message #80633] Thu, 24 October 2002 05:41 Go to previous messageGo to next message
Thakur Baldev Singh
Messages: 9
Registered: October 2002
Junior Member
It has to work.

Can u give the code
and the error

I will solve it
Re: dynamic sql [message #80638 is a reply to message #80633] Thu, 24 October 2002 06:06 Go to previous messageGo to next message
harish agarwal
Messages: 38
Registered: September 2002
Member
Hi baldev

i am writing this code under 'when button pressed 'trigger'
begin
execute immediate 'create table test3(c1 number,c2 varchar2(20))';
end;

error

encountered the symbol "immediate" when expecting one of the followin
:= . @ [[ ; %
the symbol was inserted before immediate
thank u
harish
Re: dynamic sql [message #80648 is a reply to message #80638] Fri, 25 October 2002 02:52 Go to previous message
Thakur Baldev Singh
Messages: 9
Registered: October 2002
Junior Member
OK
I assume u r not using Forms 6i
Ur Froms version is only compatible with Oracle 7.3

execute immediate is a feature of Oracle 8i

Try this...
Write the execute immediate script as a Oracle Stored Procedure or Function (Provided u have Oracle 8i DB)and then u call it from your
Button Trigger.
It will work.
Previous Topic: forms6i-urgent
Next Topic: Forms 4.5 / Reports 2.5 Compatibilty with Oracle 9i
Goto Forum:
  


Current Time: Tue Oct 19 20:10:50 CDT 2021