Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: String to long conversion

    Hi all

    From the front end ( jsp) i am passing a string parameter which has comma seperated primarykeys and i am using this string in writing a query and ia m saying there IN (string) but this is giving me

    ORA-01722: invalid number error.

    For example from jsp i am passing a string called ebcnIds=2222,2223
    and in my backend ia m executing query which is having

    EBCN_ID IN (ebcnIds) where EBCN_ID is my primarykey in the table of type NUMBER ..

    Can any one help me in this regard???


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >i am passing a string called ebcnIds=2222,2223
    It likely does not like the comma after the equal sign.

Posting Permissions

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