Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> execute immediate
hi,
I built a dynamic query in PL/SQL
when I did
> spool test.sql
> ...
> stmt := select col1,col1.. from ...
> dbms_output.put_line(stmt);
> @test.sql
the result is OK
When I did
> execute immediate stmt ;
nothing on the screen
obviously I misuse execute immediate
can you help me please ?
Oracle 9.2.0.5
HP-UX 11.0
Received on Sun Jun 19 2005 - 04:22:38 CDT