Home » Developer & Programmer » Forms » Backend's sqlerrm (Oracle 6i )
Backend's sqlerrm [message #427770] Sun, 25 October 2009 05:19 Go to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
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.

Why this is so?
Help me
Re: Backend's sqlerrm [message #427789 is a reply to message #427770] Sun, 25 October 2009 09:26 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wouldn't know.

Anyway, why wouldn't you fix that TOO-MANY-ROWS error?
Re: Backend's sqlerrm [message #427839 is a reply to message #427789] Mon, 26 October 2009 02:54 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Actually I want to show error message at frontend which is return from backend.
Re: Backend's sqlerrm [message #429264 is a reply to message #427839] Mon, 02 November 2009 21:59 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Anybody got answer ?
Re: Backend's sqlerrm [message #429323 is a reply to message #427839] Tue, 03 November 2009 03:58 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
shekhar.salunkhe wrote on Mon, 26 October 2009 07:54
Actually I want to show error message at frontend which is return from backend.


Isn't that happening right now?
Re: Backend's sqlerrm [message #429325 is a reply to message #427770] Tue, 03 November 2009 04:01 Go to previous messageGo to next message
paddu_42
Messages: 12
Registered: October 2009
Junior Member
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
Re: Backend's sqlerrm [message #429962 is a reply to message #429325] Fri, 06 November 2009 09:34 Go to previous messageGo to next message
TonyJaa
Messages: 50
Registered: May 2009
Member
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.
Re: Backend's sqlerrm [message #430565 is a reply to message #429962] Wed, 11 November 2009 01:19 Go to previous message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Thanks.
Previous Topic: HOST command not working
Next Topic: Calling PL/SQL function in a form
Goto Forum:
  


Current Time: Sun Dec 04 22:46:55 CST 2016

Total time taken to generate the page: 0.11718 seconds