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!

How to execute a function which has a table type as IN parameter

user5605610Jul 21 2010 — edited Jul 21 2010

I have a Type COL_TYPE with 6 fields in it. Created a Table Type TAB_TYPE on the COL_TYPE.

Now, I have a function which takes TAB_TYPE as input.

How can i execute the function?

is there anything wrong with this statement.
select MY_FUNCTION(TAB_TYPE(3826721,null,null,null,null,null)) from dual;

I tried in several ways but ending up with errors.

Also, please let me know how to pass multiple records as input to the function.

Thanks in advance for your help.

Edited by: user5605610 on Jul 21, 2010 2:28 AM

Edited by: user5605610 on Jul 21, 2010 2:30 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2010

Added on Jul 21 2010

#pl, #sql

9 comments

1,350 views