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: Help with cursor

Re: Help with cursor

From: <rock_cogar_at_my-deja.com>
Date: Tue, 12 Oct 1999 14:34:22 GMT
Message-ID: <7tvgtd$qgt$1@nnrp1.deja.com>


My take on this problem is that you will not be able to use %ROWTYPE in your variable declaration. Instead, you will need to explicitly declare 2 variables of type NUMBER to use in your fetch. As others have said, make sure to open and close the cursor!

Rock Cogar.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 12 1999 - 09:34:22 CDT

Original text of this message

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