strange ORA-01789: query block has incorrect number of result columns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: strange ORA-01789: query block has incorrect number of result columns

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    Cool strange ORA-01789: query block has incorrect number of result columns

    Hi friends ,

    i have simple sqlplus command which is giving some strange error message.

    can anyone please suggest if i am missing anything here .


    select grp_id
    from SCORE_HSB0243S_BKP where grp_id not in (-11512,-9850,-9845,-9816,-9815,-8388,-7493,-7492,-7265,-7264,-7263,-7262,-7261,-7260,2097970,2241910,2241911,2241912,2241913,2241914,2241915,2241916,2241917,2241918,2241919,2241920 ,2241921,2361998,2795234,2795235,3607596,3636481)
    minus
    select grp_id from SCORE_HSB0243S where grp_id not in (-11512,-9850,-9845,-9816,-9815,-8388,-7493,-7492,-7265,-7264,-7263,-7262,-7261,-7260,2097970,2241910,2241911,2241912,2241913,2241914,2241915,2241916,2241917,2241918,2241919,2241920 ,2241921,2361998,2795234,2795235,3607596,3636481)

    gives below error message

    ORA-01789: query block has incorrect number of result columns

    but if i replace column name with * it works ??
    siva prakash
    DBA

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Plase Ignore This Message .
    siva prakash
    DBA

Posting Permissions

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



Click Here to Expand Forum to Full Width