Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Passing arrays into user-defined functions in Oracle

surekha_4
Occasional Advisor

Passing arrays into user-defined functions in Oracle

How does one pass arrays into user-defined functions in Oracle?

This is the info that I have:
create or replace type NUM_ARRAY as table of number
And, then, I will have to pass NUM_ARRAY into my UDF.

Does this mean that a 'table' of type NUM_ARRAY is created and associated with my schema?
2 REPLIES
Indira Aramandla
Honored Contributor

Re: Passing arrays into user-defined functions in Oracle

Hi Surekha,

Attached is an example from metalink explaining "Passing Arrays as parameters in procedures". You can change to a User Defined Function (UDF).


Indira A
Never give up, Keep Trying
surekha_4
Occasional Advisor

Re: Passing arrays into user-defined functions in Oracle

Thanks Indira!