Unable to Create Package Body
Date: 1996/07/08
Message-ID: <31E162B4.7284_at_water4.wcbe.edu.on.ca>#1/1
Hi there,
I'm having trouble compiling a package body.
PLS-00304: cannot compile body of 'SUSP_PACKAGE_BODY' without its
specification
The account has Create Procedure privilege.
Is there some hidden privilege that's required?
The SQL script contains the following...
rem SU_PACKAGE.SQL
CREATE OR REPLACE PACKAGE susp_package IS
--
--
PROCEDURE do_nothing;
GRANT EXECUTE ON susp_package TO ops$sudba;
CREATE OR REPLACE PACKAGE BODY susp_package_body IS
FUNCTION verify_user (username VARCHAR2) RETURN BOOLEAN;
END susp_package;
/
PROCEDURE do_nothing IS
BEGIN
NULL;
END do_nothing;
FUNCTION verify_user (username VARCHAR2) RETURN BOOLEAN IS
-- Verify the user has access to the Suspension System
t_count INTEGER;
b_result BOOLEAN;
t_username VARCHAR2 := username;
BEGIN
SELECT count(*)
INTO t_count
FROM hd_su_user_authorization ua
WHERE
ua.username = t_username;
b_result := (t_count > 0);
RETURN b_result;
END verify_user;
END susp_package_body;
/
Received on Mon Jul 08 1996 - 00:00:00 CEST