Hi,
The client version is Oracle 10.2.0.4 and the database version is 10.2.0.3.
Both are 64 bit running on a Solaris version 9. Here are the SQL logs. I can
run these SQL statements via direct SQL and do not receive any errors.
SELECT
groupType,MAX(timestamp) FROM group_cache GROUP BY groupType
OK
*/SELECT
name,schemaId,schemaType,coreVersion,timestamp,numFields,defaultVui,numVuis,nextFieldId,upgrdVersion,version,smObjProp,safeGuard,nextId,objProp,viewName,
shViewName FROM arschema ORDER BY 2 ASC
OK
*/*** ERROR ***
ORA-03130: the buffer for the next piece to be fetched is required
*/COMMIT WORK RELEASE
Oracle has a known issue, but not sure if this is the issue.
OciStmtSetPieceInfo Return Code 1062 Ora-03130 when
dynamic fetch on BLOB
Oracle Server - Enterprise Edition - Version: 10.1.0.2.0 to
10.2.0.3
For a dynamic fetch of binary/raw data the piece size cannot be
greater than 16777180 when set via
OCIStmtSetPieceInfo().
Thanks!
________________________________
From: Axton <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, October 23, 2008 2:20:21 PM
Subject: Re: ARS 7.1 DB Error: ORA-03130: the buffer for the next piece to be
fetched is required
How about some sql logs so we can see what it is trying to do. What
oracle client are you using? Can you also post the contents of the
sqlnet.ora file?
Axton
On Thu, Oct 23, 2008 at 2:05 PM, Bala Patel <[EMAIL PROTECTED]> wrote:
> **
> All,
>
> I just upgraded my server from ARS 6.3 Patch 24 to ARS version 7.1 Patch 5.
> The upgrade went without errors. I restart the ARS processes after a couple
> of hours of the upgrade and now receive this oracle error:
>
>
> 390600 : Failure during SQL operation to the database (ARERR 552)
> ORA-03130: the buffer for the next piece to be fetched is required
>
> **********************************
>
> I looked up the error and found the following:
>
> ORA-03130: the buffer for the next piece to be fetched is required
> Cause: The application performed a piecewise define on the column.
> Action: Provide the next buffer for the next piece to be retrieved.
> *******************************
> Oracle 10g Remote server
> ARS version 7.1 Patch 5
> Solaris version 9
>
> ******************************
>
> Thanks,
>
> Bala Patel
> Independent Consultant
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
