-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|