Function contained in an Oracle Package

[louder3]

Hi

Please can someone tell me why the below does not compile without an error.

Thanks

 
CREATE OR REPLACE PACKAGE pkg_secure_valid IS
 
  FUNCTION f_chk_logon (v_logon VARCHAR2) RETURN NUMBER;
 
END pkg_secure_valid;
/
 
CREATE OR REPLACE PACKAGE BODY pkg_secure_valid 
AS
 
  FUNCTION f_chk_logon (login_in VARCHAR2) RETURN NUMBER
  IS
   v_sid NUMBER;
  BEGIN
   v_sid := 12;
   RETURN v_sid; 
  END f_chk_logon;
 
END pkg_secure_valid;
 
 

[gnanda]

Hi,

Use the same parameter_name v_logon in f_chk_logon inside the package body

 
CREATE OR REPLACE PACKAGE BODY pkg_secure_valid 
AS
 
  FUNCTION f_chk_logon (v_logon VARCHAR2) RETURN NUMBER
  IS
   v_sid NUMBER;
  BEGIN
   v_sid := 12;
   RETURN v_sid; 
  END f_chk_logon;
 
END pkg_secure_valid
 
 

Regards
Nanda

[amitpatel66]

Hi All,

Welcome to TSDN!!

Please make sure you follow POSTING GUIDELINES every time you POST in this forum.

Thanks
MODERATOR