Troubleshooting
Problem
Oracle cursors maxing out and resulting in ORA-1000 error for database queries from application
Symptom
Oracle cursors maxing out and resulting in ORA-1000 error for database queries from application
Error Message <Error ErrorCode="ORA-1000" ErrorDescription="ORA-01000: maximum open cursors exceeded
" ErrorRelatedMoreInfo="">
<Attribute Name="ErrorCode" Value="ORA-1000"/>
<Attribute Name="ErrorDescription" Value="ORA-01000: maximum open cursors exceeded
"/>
<Attribute Name="SQLStatement" Value=" SELECT /*YANTRA*/ YFS_SHIPMENT.* FROM YFS_SHIPMENT YFS_SHIPMENT WHERE ( ( ( ( YFS_SHIPMENT.EXTN_REFERENCE_1 = '0650321465' ) ) )) ORDER BY SHIPMENT_NO ,SHIPNODE_KEY ,SELLER_ORGANIZATION_CODE "/>
<Attribute Name="SQLState" Value="72000"/>
<Attribute Name="DBErrorCode" Value="1000"/>
<Attribute Name="TransactionIsolationLevel" Value="2"/>
<Error ErrorCode="java.sql.SQLException" ErrorDescription="" ErrorRelatedMoreInfo="ORA-01000: maximum open cursors exceeded
">
<Stack>java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Resolving The Problem
Custom code level calls can result in such situations if the above is not taken care during coding.
Historical Number
NFX5809
Product Synonym
[<p><b>]Severity[</b><p>];Normal
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21553051