Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Output of Cursor

Re: Output of Cursor

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 15 Apr 2005 14:00:26 +0200
Message-ID: <d3oa63$3e8$2@news4.zwoll1.ov.home.nl>


Ina Schmitz wrote:
> Hi all,
>
>

>>PUB_at_TESTING>VAR C REFCURSOR;
>>PUB_at_TESTING>EXEC TEST_PROC(:C);

>
> Thanks already for this idea!
>
> Unfortunately, this also doesn't show the result, I'ld like to see: I just
> see "PL/SQL procedure successfully completed", but NOT all the tuples from
> DUAL. Could you please tell me, how to get them displayed in SQL*Plus with a
> procedure call?
>
> Would really be a great help! Thanks in advance.
>
> Cheers,
> Ina
>
>

print c, as per rtfm
-- 
Regards,
Frank van Bortel
Received on Fri Apr 15 2005 - 07:00:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US