var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Collections and Functions
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-
And a function in which the above collection is passed as a parameter.
TYPE C_TYPE AS OBJECT
CREATE OR REPLACE
TYPE c_list As table of C_TYPE
I want to execute the above function but how do I pass the parameter for the collection? All I'm interested in is the clnt_c field in the collection c_list.
FUNCTION f_get_c (
cpc IN VARCHAR2,
cpc_tab IN c_list)
a VARCHAR2 (10) := cpc;
FROM TABLE (CAST (cpc_tab AS c_list))
WHERE clnt_c not in ('usa','can');
If it is just for a test, call the constructor of the table and then the constructor for each object of the collection, for example :
If you are using an API in another language, then it depends on the API
C_LIST(C_TYPE('foo', 1), C_TYPE('bar', 2))
ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready