Re PL/SQL problem

From: Prakash Gopinath <>
Date: Thu, 13 Aug 1992 18:39:32 GMT
Message-ID: <>


Subject: Re: PL/SQL problem

References: <> Sender:
Organization: Independence Technologies, Inc. Fremont, CA Keywords:

In article <> (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  
\  / /  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

Original text of this message