Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle package coding standard advise seeked
I have written my first Oracle package. Older package in my company
make use of the PRAGMA directive. I've just read that this directive
have been replaced with function hints PARALLEL_ENABLE and
DETERMINISTIC. But my package rely on the fact that a global variable
contain a user+session unique list of permissions, so it is my
understanding that these hints cannot be used in my particular case.
So my question is, to make my package state of the coding art, do I need to do anything else than this:
(code modified for public posting)
CREATE OR REPLACE PACKAGE PI_MY_NEW_PACKAGE
IS
TYPE T_MyTableType IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
/* Public */
FUNCTION F_GET_USER_PERMISSIONS(...) RETURN BOOLEAN; FUNCTION F_PAT_HAS_..._IN_USER(... ) RETURN BOOLEAN; FUNCTION F_GET_USER_LIST RETURN VARCHAR2; FUNCTION F_GET_ALL_LIST RETURN VARCHAR2; FUNCTION F_USER_CAN_SEARCH_IN( ... ) RETURN BOOLEAN;
/* Private */
FUNCTION F_CREATE_USER_LIST RETURN VARCHAR2; FUNCTION F_CREATE_ALL_LIST RETURN VARCHAR2; FUNCTION F_USER_HAS_OTHERS RETURN BOOLEAN; PROCEDURE P_GET_USER_MAIN(... ); PROCEDURE P_GET_WKSTN_MAIN( ... ); PROCEDURE P_GET_USER_OTHERS(...); PROCEDURE P_GET_WKSTN_OTHERS( ... ); PROCEDURE P_ADD_IN_LIST( P_CODE NUMBER ); FUNCTION F_CODE_EXISTS_IN_LIST( P_CODE NUMBER ) RETURN BOOLEAN;
END PI_MY_NEW_PACKAGE;
/
Thanks Received on Wed Nov 14 2007 - 15:19:03 CST
![]() |
![]() |