RE: ORA-01044 error

Stephane,

This error comes from a PL/SQL Stored Procedure that is called from an ASP page.

David
-----Original Message-----
Sent: Friday, June 08, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L

"Bartolo, David" wrote:
>
> Hi all,
>
> Can anyone tell me what this error means? I have had no luck finding info
> on this.
>
> ORA-01044: size 256000 of buffer bound to variable R001C005 exceeds
maximum
> 32512
>
> TIA
> David

You are trying to associate too big a variable (in a 3GL program probably) to a SQL statement (a parameter which you are trying to pass). Trying to guess : Musn't be an OCI program, I have already bound bigger variables. The 32512 limit makes me think of the maximum size of a VARCHAR2 in PL/SQL, but you couldn't declare a VARCHAR2(256000) without generating an exception, unless you have a %TYPE variable, and that a varchar column was dropped somewhere and recreated as a CLOB, thus forcing a runtime error? Or in a Pro*C program, perhaps? Do you know at least what type of program generates this error?

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bartolo, David
  INET: bartolo_at_USCOLO.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).