Troubleshooting
Problem
ORA- 0933 Error Received: Cursor_Sharing and intbu108, Oracle 8i Portability Issue
Symptom
PART: Manifest 6.0 SP1 DCS
COMPONENT: None
OS: <None> -
<None>
DATABASE: Oracle - 8.1.6
WEB SERVER: <None> - <None>
WEB
BROWSER: <None> - <None>
Cause
Resolving The Problem
Trace results in this query.
"SELECT DISTINCT MANIFEST_NO,CARRIER_CODE FROM
DCS.CARTON_HDR WHERE WHSE='GVIEW' AND REFERENCE_FLAG1 <> 'Y' AND MANIFEST_NO <>
' ' AND CARRIER_CODE <> ' 'AND CARTON_STATUS = '71'"
there is no space
between CARRIER_CODE <> ' ' AND
No work around. Defect due to 8i
portability.
CR 13241; Fixed in DCS 6.0 SP2 - HF5.
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
PRI48126
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21523865