Unanswered: Parameterized query to accept comma separated string
I have one query which runs successfully through dbaccess, when same being used in curser, it gives -1213 error. Here is example:
select network_id,NVL(total_calls, 0), fragment_date from cell_statistics
where network_id in ('4','5') and time_id in ( SELECT datetime_id from
datetimes WHERE extend(date_and_time,
year to day) = extend (today-7, year to day) )
ORDER BY network_id,fragment_date
when i was using network_id = 4 , it was working fine, but now I need multiple network_id to be passed so I modified the code inside IN, now it is not working.
Please help me out, and let me know, if you need any more info.
That error is "A character to numeric conversion process failed". It seems you have some field on your table is not corresponding with your sql script. Try to review your script and confirm that is corresponding with your type table fields...