Re: execute immediate

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Sun, 19 Jun 2005 13:11:52 +0000 (UTC)
Message-ID: <d93quo$kgt$1@klatschtante.init7.net>

On 2005-06-19, astalavista <spam_at_nowhere.com> wrote:
> 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

This is expected behaviour. If you want to display something on the screen, you'll have to use dbms_output.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Sun Jun 19 2005 - 08:11:52 CDT