Results 1 to 2 of 2

Thread: Pls-00378

  1. #1
    Join Date
    Dec 2002
    Location
    London, UK
    Posts
    14

    Unanswered: 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 help

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Pls-00378

    Originally 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •