Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    13

    Unanswered: Integers and Oracle

    Please forgive this possibly stupid question:

    I am trying to insert a ANSI SQL integer into an Oracle NUM(15) column. I found through google that the ANSI SQL int = Oracle NUM(10).

    Basically I am trying to insert values into an Remedy db, which is oracle. We keep getting the error that we are inserting the wrong datatype.

    Any hints?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I'm rubbing my crystal ball, but can't see a clear answer.
    It is too bad you did not share with us EXACTLY
    what you tried to do or even the EXACT error message;
    so we might have a clue regarding your specific problem.
    So I guess you'll need to wait for somebody whose crystal ball is working better than mine.

  3. #3
    Join Date
    Sep 2003
    Posts
    13
    I am trying to take data (specified as Int or Smallint in Sybase) and insert it into an Oracle database column which is specified as NUM(15). I am not doing this manually. There are processes running that are taking the data from a Sybase table mapping it into an Oracle table, thus taking alarm info from Sybase and creating a ticket through Remedy and stored in Oracle.

    The error we're getting in the our log is:

    Caught an Exception:
    Remedy Error #310
    Text: check result - Error - Value has wrong data type
    for the field, 536871338
    Value has wrong data type for the field, 536871037
    Value has wrong data type for the field, 536871052
    Value has wrong data type for the field, 536870912

    Not one of the Integers from Sybase is being inserted into Oracle.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Again I don't have a clue regarding what you are doing,
    but I will offer one observation. Oracle, AFAIK, does NOT
    have a datatype of "NUM".

  5. #5
    Join Date
    Sep 2003
    Posts
    13
    yeah, well i don't know oracle.

    nevermind, though, i figured it out.

    i like you.

Posting Permissions

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