Re: PL/SQL QUESTIONS
From: John Dennis <jdennis_at_netcom.com>
Date: Sat, 4 Jun 1994 02:20:37 GMT
Message-ID: <jdennisCqup6E.1K4_at_netcom.com>
Date: Sat, 4 Jun 1994 02:20:37 GMT
Message-ID: <jdennisCqup6E.1K4_at_netcom.com>
Pindiprolu (kamu_pindiprolu_at_jhuapl.edu) wrote:
: Hi
: I have two questions on PL/SQL. Your help is greatly appreciated.
: 1. How can I print variables that I have declared in the declaration section
: without using PRO*C ?
Hmmm. Well in sqlplus you can do something like:
VARIABLE X NUMBER;
BEGIN
DECLARE
Y NUMBER;
. . .
Y = 5;
. . .
:X := Y;
END;
END;
/
PRINT X; or
use dbms_output.PUTLINE('Value of Y is ' || Y);
(see "debugging" in application developers guide.
: 2. Can a HOST command be invoked from a PL/SQL script ?
Refer to the package which supports "pipes". Never used them but this may be a lead.
: Thanks
: KP
John Dennis Received on Sat Jun 04 1994 - 04:20:37 CEST