Cursors using SQL plus

From: Harry <h_tompson_at_hotmail.com>
Date: 16 Apr 2002 11:44:13 -0700
Message-ID: <d45236f4.0204161044.466437b6@posting.google.com>

Hi all,

I have really quick question.

I'm debuging a hugh cursor in a piece of badly written code and what I am finding is that I'm spending too much time compiling the program and running it.

What I want to do is to be able to run the cursor from the sql plus window, and see that data that comes out line by line.

Is this possible? How?

Also, since I have your attention:
In the same cursor I want to lock the selected data using a FOR UPDATE OF clause. My documentation tells me this isn't allowed with cursors (we're running oracle 8.0.5 on HP-UX) but is there any other way?

Thanking you all,

Harry Received on Tue Apr 16 2002 - 13:44:13 CDT