Home » Developer & Programmer » Forms » FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION
FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229039] Thu, 05 April 2007 02:54 Go to next message
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
Re: FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229044 is a reply to message #229039] Thu, 05 April 2007 03:08 Go to previous messageGo to next message
Frank Naude
Messages: 4420
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.
Re: FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229732 is a reply to message #229039] Mon, 09 April 2007 21:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION [message #229733 is a reply to message #229732] Mon, 09 April 2007 21:24 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Creating a new canvase using existing data blocks??
Next Topic: Add vertical Scroll Bar
Goto Forum:
  


Current Time: Mon Nov 24 12:25:13 CST 2014

Total time taken to generate the page: 0.06948 seconds