OraFAQ Forum: Forms » ORA-00904: "EMP

Home » Developer & Programmer » Forms » ORA-00904: "EMP_ID": invalid identifier. (Oracle Form Builder 6i)

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

ORA-00904: "EMP_ID": invalid identifier. [message #484072]

Fri, 26 November 2010 23:21

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Hi Experts,

When I call a form using menu.
On executing query it displays error ORA-00904: "EMP_ID": invalid identifier.

But when the same form is executed using Oracle Form Builder it works.

What to do?

Report message to a moderator

Re: ORA-00904: "EMP_ID": invalid identifier. [message #484096 is a reply to message #484072]

Sat, 27 November 2010 02:38

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Did you try to recompile your menu ? (Ctrl + T).

Regards,

Irfan

Report message to a moderator

Re: ORA-00904: "EMP_ID": invalid identifier. [message #484098 is a reply to message #484096]

Sat, 27 November 2010 03:55

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Maybe forms that you [call from a menu] and [run from Forms Builder] aren't the same.

Report message to a moderator

Re: ORA-00904: "EMP_ID": invalid identifier. [message #484099 is a reply to message #484098]

Sat, 27 November 2010 03:58

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Or when you run it from the menu you're running it against a different schema and/or database to when you run it directly from form builder.

Report message to a moderator

Previous Topic:	query not in databae field
Next Topic:	:system.record_status

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 10:08:54 CST 2025