Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    Unanswered: Parameterized query to accept comma separated string

    Hi All,

    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.

    Thanks in advance.


  2. #2
    Join Date
    Jun 2009
    Lisboa, Portugal
    Hi Chittu,

    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...

    Hope it helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts