Pls-00378

Hello PL/SQL gurus,

I am facing a seemingly simple problem compiling a function.

When I try to compile the folllowing code...

CREATE OR REPLACE FUNCTION WDF_UNITS_SHIPPED_FN ( p_trf_number IN PLS_INTEGER ) RETURN NUMBER ;

I am getting.....

PLS-00378: invalid compilation unit for this release of PL/SQL

Any ideas?

Please helpOriginally posted by pusht
Hello PL/SQL gurus,

I am facing a seemingly simple problem compiling a function.

When I try to compile the folllowing code...

CREATE OR REPLACE FUNCTION WDF_UNITS_SHIPPED_FN ( p_trf_number IN PLS_INTEGER ) RETURN NUMBER ;

I am getting.....

PLS-00378: invalid compilation unit for this release of PL/SQL

Any ideas?

Please help
Your function definition is incomplete - it is just a specification, there is no body. This is correct in a package specification, but not for a stand alone function.