HPE Community
Operating System - HP-UX
1828275 Members
3835 Online
109975 Solutions
New Discussion

Re: Passing arrays into user-defined functions in Oracle

 
surekha_4
Occasional Advisor

‎02-20-2005 06:01 PM

‎02-20-2005 06:01 PM

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?
0 Kudos
Reply
2 REPLIES 2
Indira Aramandla
Honored Contributor

‎02-20-2005 07:42 PM

‎02-20-2005 07:42 PM

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
0 Kudos
Reply
surekha_4
Occasional Advisor

‎02-20-2005 07:45 PM

‎02-20-2005 07:45 PM

Re: Passing arrays into user-defined functions in Oracle

Thanks Indira!
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.