Dear Pakar,
Mohon clue saya punya type berupa table of varchar2(9) dan dari situ pengen
dijadikan variable untuk sys_context...
bisa nggak yah?
berikut script yang telah saya buat:
create or replace type* list_acc* as table of varchar2(9)
/
Create context var_dr using var_dr_pkg;
/
create or replace package var_dr_pkg is
procedure set_var(account_id in *list_acc*, period in varchar2, bill_code in
varchar2);
end var_dr_pkg;
/
create or replace package body var_dr_pkg is
procedure set_var(*account_id in list_acc*, period in varchar2, bill_code in
varchar2) is
begin
dbms_session.set_context(namespace => 'var_dr', attribute =>
'account_id', *value => account_id*);
dbms_session.set_context(namespace => 'var_dr', attribute => 'period',
value => period);
dbms_session.set_context(namespace => 'var_dr', attribute =>
'bill_code', value => bill_code);
end;
end var_dr_pkg;
/
[Non-text portions of this message have been removed]
