How to execute a function which has a table type as IN parameter
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