OE_Holds_PUB Invalid And Cannot Be Compiled (Doc ID 2422311.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

Package oe_holds_pub is invalid.
When attempting to manually compile, the following error occurs.

ERROR

SQL> alter package oe_holds_pub compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY OE_HOLDS_PUB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3199/7 PL/SQL: SQL Statement ignored
3200/7 PL/SQL: ORA-00913: too many values
4673/7 PL/SQL: SQL Statement ignored
4674/7 PL/SQL: ORA-00913: too many values



NOTES
Within the package body of oe_holds_pub , go to the problem line , ie 3199.
Here are the coding lines.

  SELECT * INTO l_line_rec
  FROM oe_order_lines
  WHERE line_id = l_line_id;

  From the program , l_line_rec is :-
  l_line_rec OE_ORDER_LINES_ALL%rowtype;

Comparing the returned fields for oe_order_lines and OE_ORDER_LINES_ALL
shows that OE_ORDER_LINES_ALL returned additional 2 field , ie "IB_INSTALLED_AT_LOCATION#1" and "IB_CURRENT_LOCATION#1".

Changes

Cause

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