My Oracle Support Banner

Clicking On Price Details After Order Placement, java.sql.SQLException: ORA-06550: line1, column 300: PLS-00103: (Doc ID 2770561.1)

Last updated on MAY 10, 2021

Applies to:

Oracle iStore - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

 

The following error is seen when clicking on price after order placement:

Note: This issue is specific to clicking on details where MDL item is ordered, and then on order confirmation page, "Details" link is clicked.
         For a standard items order, the issue is not reproducible. 



ERROR
-----------------------
 java.sql.SQLException: ORA-06550: line1, column 300: PLS-00103: Encountered the symbol ";" when expecting one of the following:.
  (), * %& =-+ < / > at in is mod remainder not rem = > < an exponent (**)> <> or != or ~= >=<=<> and or like2 like4 likec between || multiset member submultiset The symbol " ) " was substituted for ";" to continue.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create shopping cart with MDL item
2. Click on price link and view pricing details (this is successful)
3. Submit cart to order
4. From the order confirmation page, click the price link
5. Error is seen
6. Click on price
7. See error in the ibeCScdPridingDetails.jsp

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.