shekhar.salunkhe Messages: 126 Registered: January 2008 Location: Nasik
Senior Member
Hello,
Whenever I execute procedure from sql prompt
it throws ORA-01427: single-row subquery returns more than one row
But when I execute same procedure it throws
ORA-12703: this character set conversion is not supported.
what do you want actually.i didnt get.
do want ORA-01427: single-row subquery returns more than one row
in the front end .
Then write on error trigger in the form and write the error code and error message
Check your sub-query if you have something like COL = (SELECT 1 FROM TABLE), check that SELECT 1 FROM TABLE returns only one row, Otherwise replace = by IN or change the where clause.
It will fix the first problem. And YOU CAN'T CATCH THIS TYPE OF ERRORS IN TOO_MANY_ROWS EXCEPTION.
] 
Members
Search
Help
Register
Login
Home
