Error when adding a Product to Catalog or Updating Section Details in iStore 12.1.2 - ORA-06550
Last updated on FEBRUARY 01, 2016
Applies to:Oracle iStore - Version 12.1.2 and later
Information in this document applies to any platform.
On iStore 12.1.2 version, Administrator UI
When attempting to add product to a section,
the following error occurs.
Even after error, product was added to the section.
ORA-06550: line 1, column 503:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << continue close current delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge pipe purge The symbol "exit" was substituted for ";" to continue.
The issue can be reproduced at will with the following steps:
1. Login as iStore Administrator
2. iStore Merchant: Sites:Summary > Summary > select Catalog Tab
3. Add product(Click + ) > Select Add products to section
4. Apply to see the error
Note: The same error could occur when updating the Section Details.
iStore Merchant: Catalog: Hierarchy: Select a Section: Update
In Section Details, update any data and Apply the changes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms