Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Encountered The Symbol 'Create' - Attemping to write a PL/SQL Package

Re: Encountered The Symbol 'Create' - Attemping to write a PL/SQL Package

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 10 Jun 2005 06:32:26 +0200
Message-ID: <is5ia1lut7ebsic21nqen391r30pvm9g3n@4ax.com>


On 9 Jun 2005 17:27:05 -0700, "absinth" <absinth_at_gmail.com> wrote:

>I had some code in the package body but when taking it out I still
>encounter the error:
>
>Compilation errors for PACKAGE SIEBEL.IF_DVA_INBOUND
>
>Error: PLS-00103: Encountered the symbol "CREATE"
>
>I have the following code:
>
>CREATE OR REPLACE PACKAGE if_dva_inbound AS
>
> FUNCTION fetch_person_uid (vet_file_num in VARCHAR2)
> RETURN S_CONTACT.PERSON_UID%TYPE;
> interface_name CONSTANT VARCHAR2(30) := 'dva_inbound';
>
>END if_dva_inbound;
>
>CREATE OR REPLACE PACKAGE BODY if_dva_inbound AS
>END if_dva_inbound;
>
>Anyone give some tips?

end if_dva_inbound;
/

In both cases.
Also package bodies can't be empty.

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Jun 09 2005 - 23:32:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US