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

From: Akp <abhishek1999_at_gmail.com>
Date: 9 Jun 2005 23:38:56 -0700
Message-ID: <1118385536.656308.190140@g44g2000cwa.googlegroups.com>

You need to put the executable statements for the subprograms that you have declared in the package specifications .

CREATE OR REPLACE PACKAGE BODY if_dva_inbound AS BEGIN
        FUNCTION fetch_person_uid (vet_file_num in VARCHAR2) RETURN S_CONTACT.PERSON_UID%TYPE is

        v_dummy S_CONTACT.PERSON_UID%TYPE;
        begin
        return v_dummy;
        end;

END if_dva_inbound
/

might just solve your error. Received on Fri Jun 10 2005 - 01:38:56 CDT