Oracle 2112 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle 2112 error

  1. #1
    Join Date
    Oct 2000
    Posts
    1
    Hi,

    I am getting SQL 2112 error when executing the Pro*C++
    code. The problem is random, even when there is only one matching row for the query , this error is reported
    sometimes i find ORA 1306 occuring just before this error. we are using oracle 7.3.4.4 on HP UX 10.20.
    I would like to Know that this issue is OS Specific or Database specific. Any patches need to be installed. Could you guys can throw some light.

    Regards,
    Anand.G


  2. #2
    Join Date
    Oct 2000
    Posts
    123
    The error is because in SELECT ... INTO returns too many rows.
    Cause: A SELECT ... INTO statement returned more rows than can be stored in the host variable provided.

    Action: There are three possible solutions:

    Use the precompiler option SELECT_ERROR=NO.
    Declare a host variable with a larger array dimension.
    Declare a cursor or cursor variable for the select statement.

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