Buat dan gunakan fungsi yg mengubah array menjadi string dengan delimiter koma.
Contoh: Input:: x(1) = 'ABC' x(2) = 'DEF' x(3) = 'HIJ' Output:: ABC,DEF,GHI create or replace function array_to_str(x in list_acc) is y VARCHAR2(1000); begin for i in x.first..x.last loop y := y || ',' || x(i); end loop; y := substr(y,2); return(y); end; / dbms_session. set_context( namespace => 'var_dr', attribute => 'account_id' , *value => array_to_str(account_id)*) ; CMIIW, bw --- In [email protected], zainal arifin <zainal.em...@...> wrote: > > ada yang bisa ngasih workaround nya gak ya. > goal nya saya buat parameterized view.. tetapi salah satu parameternya > sebenarnya adalah > where customer_id in (:parameter) dimana :parameter ini adalah array dari > varchar2 > > > wassalam > > On Thu, Apr 23, 2009 at 9:19 AM, Awaluddin Hamid <a...@...> wrote: > > > > > > > zainal arifin wrote: > > > > > > dbms_session. set_context( namespace => 'var_dr', attribute => > > > 'account_id' , *value => account_id*) ; > > > > > > > Sepertinya gak bisa pake tipe user define/collection type. Parameter > > value harus > > bertipe VARCHAR2. > > > > SQL> DESC SYS.DBMS_SESSION > > ... > > PROCEDURE SET_CONTEXT > > Argument Name Type In/Out Default? > > ------------------------------ ----------------------- ------ -------- > > NAMESPACE VARCHAR2 IN > > ATTRIBUTE VARCHAR2 IN > > VALUE VARCHAR2 IN > > USERNAME VARCHAR2 IN DEFAULT > > CLIENT_ID VARCHAR2 IN DEFAULT > > ... > > > > CMIIW, > > AH > > > > > > > > > [Non-text portions of this message have been removed] >
