Hi,
I am trying to write sql for passing multiple arguments through a function and handle NULL conditions ?
here is the part of the query which throws error:
...
and a.itemnum in nvl((select * from table(fnc_split (:n))),a.itemnu m)
This throws error :ORA -01427 Single row sub query returns more than one row.
fnc_split is a function which passes multiple parameters eg : 1,2,3,4,5 split in to each value as csv pattern.
Is there a way to do this.I tried case and if-then-else but of no use.
Your help is appreciated.
Thanks
I am trying to write sql for passing multiple arguments through a function and handle NULL conditions ?
here is the part of the query which throws error:
...
and a.itemnum in nvl((select * from table(fnc_split (:n))),a.itemnu m)
This throws error :ORA -01427 Single row sub query returns more than one row.
fnc_split is a function which passes multiple parameters eg : 1,2,3,4,5 split in to each value as csv pattern.
Is there a way to do this.I tried case and if-then-else but of no use.
Your help is appreciated.
Thanks