Re: which client tool ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 6 Apr 2000 15:04:34 +0200
Message-ID: <955039516.4286.2.pluto.d4ee154e@news.demon.nl>

In sql*plus define the ref cursor as VARIABLE outside the Pl/SQL block reference it in the pl/sql block, and PRINT the variable afterwards. Works like a breeze.

Hth,

Sybrand Bakker, Oracle DBA

Peter Morris <morrispj_at_lineone.net> wrote in message news:8chsl7$pq8$1_at_taliesin2.netcom.net.uk...
> I need to write some SPs which select multiple
> rows and return them in a ref cursor. I would
> like to be able to run the SPs from an SQL
> editor and look at the results returned. Can
> anyone recommend a suitable tool for this?
>
> I have tried running such an SP in TOAD,
> but the program crashes.
>
>
Received on Thu Apr 06 2000 - 08:04:34 CDT