|
-
It is giving that no fucntion setctutid exists in scope
PACKAGE global_package IS
g_CTUT_ID ORA_SYSTEM_USER.CTUT_ID%TYPE;
PROCEDURE SetCTUT_ID;
END;
PACKAGE BODY global_package
AS
PROCEDURE SetCTUT_ID
IS
BEGIN
SELECT
CTUT_ID
INTO
g_CTUT_ID
FROM
ORA_SYSTEM_USER
WHERE
CURRENT_USER_ID = user;
END;
END ;
CREATE OR REPLACE TRIGGER ORA_SYSTEM_USER_BIR_TR
BEFORE
INSERT
ON
ORA_SYSTEM_USER
FOR
EACH ROW
BEGIN
:NEW.CREATED_BY := GLOBAL_Package.CTUT_ID;
:NEW.CREATED_DATE := SYSDATE ;
END ORA_SYSTEM_USER_BIR_TR;
CREATE OR REPLACE TRIGGER ORA_SYSTEM_USER_BUR_TR
BEFORE
UPDATE
ON
ORA_SYSTEM_USER
FOR
EACH ROW
BEGIN
:NEW.UPDATED_BY := GLOBAL_Package.CTUT_ID;
:NEW.UPDATED_DATE := SYSDATE ;
END ORA_SYSTEM_USER_BIR_TR;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|