Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> execute immediate

execute immediate

From: astalavista <spam_at_nowhere.com>
Date: Sun, 19 Jun 2005 11:22:38 +0200
Message-ID: <42b5386b$0$14666$636a15ce@news.free.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US