Adding Package to Data Definition Program Errors SQLException Encounter While Executing Data Trigger Java.sql.SQLException: ORA-06550 (Doc ID 3075792.1)

Last updated on MARCH 10, 2025

Applies to:

Symptoms

Custom program fails with SQLException encounter while executing data trigger

ERROR
-----------------------
SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-06550: line 2, column 25:
PLS-00302: component 'PARAMETER1' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 25:
PLS-00302: component 'PARAMETER2' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Add the Package to the data set

2. Run the program

3. Error appears

Cause

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