Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Function return array define IN OUT parameter

709156May 28 2012 — edited May 28 2012
Hello,

I have a function which returns an array
CREATE OR REPLACE FUNCTION myfunc (
	p_id	 number,
	p_cid	 number,,
	p_no	 number,,
        datearray          IN OUT dates
)
	RETURN dates
Function I have 3 the in parameters and I would like to make return array as out parameter. However when I compile I am getting errors

How can I define the function to have in out as 4th paramater, something like datearray array?

Thanks

Edited by: ponic on May 28, 2012 6:10 PM
This post has been answered by Solomon Yakobson on May 28 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2012
Added on May 28 2012
5 comments
5,079 views