Re: PL/SQL -- huh?

From: Peter Moore <pt_at_chaff.demon.co.uk>
Date: 1995/09/12
Message-ID: <134547866wnr_at_chaff.demon.co.uk>#1/1


In article: <433sd3$2k0_at_zippy.cais.net> randyd_at_cais.com (Randy Dewoolfson) writes:
>
> Another - slightly older trick - is to
>
> SELECT "Output String" FROM DUAL;
>
> to get something to the screen...

Not in PL/SQL, Randy. All you'd get is "PL/SQL successfully completed."

You _would_ specifically need to do DBMS_OUTPUT.PUT_LINE('text'||var);

Regards,

Peter  

-- 

------------------------------------------------------------------------
|  Peter Moore - Database Administrator - MAT Transport Ltd.
|  pt_at_chaff.demon.co.uk : +44 (171) 410 6373
|  "With a little study you'll go a long ways & I wish you'd start now!"
Received on Tue Sep 12 1995 - 00:00:00 CEST

Original text of this message