OraFAQ Forum: Forms » Backend's sqlerrm

Home » Developer & Programmer » Forms » Backend's sqlerrm (Oracle 6i )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backend's sqlerrm [message #427770]

Sun, 25 October 2009 05:19

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

Report message to a moderator

Re: Backend's sqlerrm [message #427789 is a reply to message #427770]

Sun, 25 October 2009 09:26

Littlefoot
Messages: 21818
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?

Report message to a moderator

Re: Backend's sqlerrm [message #427839 is a reply to message #427789]

Mon, 26 October 2009 02:54

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.

Report message to a moderator

Re: Backend's sqlerrm [message #429264 is a reply to message #427839]

Mon, 02 November 2009 21:59

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Anybody got answer ?

Report message to a moderator

Re: Backend's sqlerrm [message #429323 is a reply to message #427839]

Tue, 03 November 2009 03:58

cookiemonster
Messages: 13938
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?

Report message to a moderator

Re: Backend's sqlerrm [message #429325 is a reply to message #427770]

Tue, 03 November 2009 04:01

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

Report message to a moderator

Re: Backend's sqlerrm [message #429962 is a reply to message #429325]

Fri, 06 November 2009 09:34

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.

Report message to a moderator

Re: Backend's sqlerrm [message #430565 is a reply to message #429962]

Wed, 11 November 2009 01:19

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Thanks.

Report message to a moderator

Previous Topic:	HOST command not working
Next Topic:	Calling PL/SQL function in a form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:42:27 CDT 2024