Hi,
I use the following select statement to populate a report.
<p>
SELECT cpnidd, ...
FROM pdrcpn, pdrcpnsts
WHERE pdrcpnsts.cpnref1=pdrcpn.cpnref
AND pdrcpn.bizidd1 IN (SELECT PKG_APEX.GetUserBizIds(:APP_USER) from dual)
<p>
In the <b>IN</b> clause I use a call to a function to return a list of comma seperated numbers. This only works if a single number is returned, if more than one number is returned (eg. 23,34) I get the following error:
<p>
report error:
ORA-01722: invalid number
<p>
Am stumped as to why this is happening or how I can fix it, any help would be greatly appreciated.
<p>
Cheers
<p>
Simon