A newly created custom projection fails with ORA-06550 / PLS-00302 'component NEW must be declared' when called via REST, even though the underlying custom LU's package compiles cleanly and has a working New method — what's wrong?

Answer

Check whether the custom projection and the custom Logical Unit it's built on share the exact same name — there's a known limitation in the OData Provider where giving a projection and its underlying custom LU identical names breaks the generated database-statement lookup this way. Renaming one of them (so the projection and LU names differ) resolves the ORA-06550 error.

← Browse Developer Studio, deployment, and upgrades questions

A newly created custom projection fails with ORA-06550 / PLS-00302 'component NEW__ must be declared' when called via REST, even though the underlying custom LU's package compiles cleanly and has a working New__ method — what's wrong?

Answer

A newly created custom projection fails with ORA-06550 / PLS-00302 'component NEW must be declared' when called via REST, even though the underlying custom LU's package compiles cleanly and has a working New method — what's wrong?