Hi all,

I'm working on collections and this is the first time and hence its very confusing. Can anyone please help me with the below.

I have a collection defined as below-
TYPE C_TYPE AS OBJECT
(clnt_c VARCHAR2(10),
clnt_did NUMBER)

CREATE OR REPLACE
TYPE c_list As table of C_TYPE
And a function in which the above collection is passed as a parameter.

FUNCTION f_get_c (
cpc IN VARCHAR2,
cpc_tab IN c_list)
RETURN VARCHAR2

IS

a VARCHAR2 (10) := cpc;
ret_key VARCHAR2(10);
begin
SELECT clnt_c
INTO ret_key
FROM TABLE (CAST (cpc_tab AS c_list))
WHERE clnt_c not in ('usa','can');
RETURN (ret_key);
END f_get_c;
I want to execute the above function but how do I pass the parameter for the collection? All I'm interested in the clnt_c