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

Home -> Community -> Usenet -> c.d.o.server -> Re: Maximum fetch in a cursor

Re: Maximum fetch in a cursor

From: John Chiu <johnc_at_relsol.com>
Date: Wed, 29 Sep 1999 14:45:59 -0400
Message-ID: <7stmel$edh$1@newsmaster.pathcom.com>


The value error could be due to your fetch of a rowid (a binary value) into v_row (declared as varchar2(50)) or the fetch of web_date (i guess it is date datatype) into v_web_date (varchar2). Check web_date or try declaring v_row as rowid datatype or urowid datatype and execute.

Good luck

John Chiu Received on Wed Sep 29 1999 - 13:45:59 CDT

Original text of this message

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