dynamic sql [message #80633] |
Thu, 24 October 2002 00:19 |
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 #80638 is a reply to message #80633] |
Thu, 24 October 2002 06:06 |
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 |
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.
|
|
|