Results 1 to 2 of 2

Thread: ora-01722 error

  1. #1
    Join Date
    Apr 2004
    Posts
    113

    Unanswered: ora-01722 error

    For some reason, I am getting an ora-01722 error when I am running this sql.
    I run this sql all the time and now getting invalid number errors.
    There error is on line 5

    The sql is as follows:

    insert into event_b
    select j.list_acct_no, j.market_code, sum(event_counter) event
    from jug_final j
    where event_code not in (222, 922, 1122)
    group by j.market_code, j.list_acct_no;

    Now if I change the sql and run this one, I get no error:

    insert into event_b
    (market_code, list_acct_no, event )
    select
    market_code,list_acct_no, sum(event_counter) event
    from jug_final
    where event_code not in (222, 922, 1122)
    group by market_code, list_acct_no;

    What is the difference?

  2. #2
    Join Date
    Apr 2004
    Posts
    113
    Never mind. I figured it out.

    Thanks for viewing though.

Posting Permissions

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