Hi Gurus!!
These days I am struggling with Oracle Reports 6i development.

I have another issue here.

I want to use Execute immediate statement in Reports Program unit.
I do have following code, it works fine in back end, SQl*plus but it
produces me an error when I do in Reports6i pprogram unit procedure.

create or replace procedure exectest is
var1 number(2);
var2 varchar2(2000);
Begin
var2 := 'insert into test values(99)';
execute immediate 'create table test (id number(10))';
execute immediate var2;
execute immediate 'select id from test' into var1;
dbms_output.put_line('Id is ' ||to_char(var1));
execute immediate 'drop table test';
end;

Please advise.

Thanks in advance.

Deepak
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Oracle LazyDBA home page