OraFAQ Forum: Forms » FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION

Home » Developer & Programmer » Forms » FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION

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

FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229039]

Thu, 05 April 2007 02:54

sanjay_oracle@hotmail.com
Messages: 2
Registered: February 2007

Junior Member

Hi,
I am new to oracle programming, i am facing this problem but do not know how to get rid of it. Please help me out.

My problem is :
FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION ORA-00904

It throws at runtime of Form 6i.

Regards,

Sanjay

Report message to a moderator

Re: FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229044 is a reply to message #229039]

Thu, 05 April 2007 03:08

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

You have an "invalid identifier" in your post query trigger. Open Forms Developer, navigate to the trigger and fix the mistake.

Report message to a moderator

Re: FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229732 is a reply to message #229039]

Mon, 09 April 2007 21:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Your post-query trigger probably contains a 'select' statement that is either returning 'too many rows' or 'no row found'. Add an 'exception' handler to overcome this problem.

Alternatively, post your code and let us have a look.

David

Report message to a moderator

Re: FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229733 is a reply to message #229732]

Mon, 09 April 2007 21:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay - that was the wrong answer.

Have a look at this definition:

ORA-00904: string: invalid identifier
Cause: The column name entered is either missing or invalid.
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.

David

Report message to a moderator

Previous Topic:	Creating a new canvase using existing data blocks??
Next Topic:	Add vertical Scroll Bar

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:57:39 CST 2025