我這樣做了,可是現在問題變成這樣了:
SQL>create or replace package secusr.customer_security is
2 function customer_sec
3 return varchar2;
4 end;
5/
包裹程式已被建立
SQL>create or replace package body secusr.customer_security
2 is
3function customer_sec(d1 varchar2,d2 varchar2)
4return varchar2
5 is
6 begin
7if SYS_CONTEXT('USERENV','SESSION_USER') IN('SYS','SYSTEM','SECUSR') THEN
8RETURN NULL;
9ELSE
10return 'CUSTOMER_ID='''||SYS_CONTEXT('CUSTOMER_CONTEXT','CUSTOMER_ID') || '''';
11end if;
12end;
13end;
14/
警告: 所建立的包裹程式主體含有編譯錯誤
SQL> show err
PACKAGE BODY SECUSR.CUSTOMER_SECURITY 發生錯誤:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/11 PLS-00323: 子程式或游標 CUSTOMER_SEC'
已在套裝規格中被宣告而且必須在套裝主體中定義
|