Re PL/SQL problem

From: Prakash Gopinath <gopi_at_indetech.com>
Date: Thu, 13 Aug 1992 18:39:32 GMT
Message-ID: <1992Aug13.183932.3162_at_indetech.com>

Newsgroups: comp.databases.oracle,connect.audit

Subject: Re: PL/SQL problem
Summary: 
Expires: 

References: <BsvF6u.GoE_at_ibmpcug.co.uk> Sender:
Followup-To:
Distribution:
Organization: Independence Technologies, Inc. Fremont, CA Keywords:

In article <BsvF6u.GoE_at_ibmpcug.co.uk> boxfield_at_ibmpcug.co.uk (Paul J Snelling) writes:
>
>This is probably a stupid question but Ive been trying all kinds of ways
>to get information OUT of a PL/SQL block without writing it to a table.
>I'm hoping that someone out there has tried the same thing and can tell me
>(A) how to do it, or (B) it cant be done....
>
  Oracle PL/SQL does not allow you to display variables in a PL/SQL block.

>My latest attempt under sqlplus goes something like...
>
>SQL> define MYVAR=500
>SQL> declare
>2 i number ;
>3 begin
>4 for i in 1..10 loop
>5 MYVAR := &MYVAR + i ;
>6 end loop ;
>7 end ;
>
>A pathetic attempt, but you can see what Im trying to acheive (I hope).
>
>Any ideas?
>
 You can use PRO *C and include this block and display the values of variables.

>--
>Paul Snelling, BoxField Systems Ltd

-- 
____*_  Gopinath Prakash            gopi_at_indetech.com
\  / /  Independence Technologies   
 \/ /   42705 Lawrence Place        FAX: 510 438-2034
  \/    Fremont, CA 94538           Voice: 510 438-8777

Received on Thu Aug 13 1992 - 20:39:32 CEST