OraFAQ Forum: Forms » Undefined error

Home » Developer & Programmer » Forms » Undefined error (Oracle Form Builder 6i)

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

Undefined error [message #485804]

Fri, 10 December 2010 01:33

fadhzone
Messages: 61
Registered: April 2008

Member

Hi Experts,
I'm having a problem.A module connected into a new database has a problem.
The system will pop up the 'Undefined Error' when try to execute

:PARAMETER.AL_BTN := Msg.Show_Msg('CM-0071',msg.MCODE,msg.STOP,NULL,NULL,NULL,NULL,lc_disp_item);

when i try change MCODE to MTEXT, it work fine.
But when i connect to existing database,MCODE also perform well.
Is it any scheme i missed out?

Thanks

Report message to a moderator

Re: Undefined error [message #485808 is a reply to message #485804]

Fri, 10 December 2010 01:48

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

Senior Member
Account Moderator

I guess that MSG.SHOW_MSG is a procedure you wrote by yourself (or some of your co-workers), so - it is kind of difficult to guess what might be wrong. What are MCODE and MTEXT, anyway?

Is there EXCEPTION handler that contains WHEN OTHERS? If so, try to remove it and execute the procedure once again - you might see the exact reason that caused the error.

Report message to a moderator

Re: Undefined error [message #486005 is a reply to message #485808]

Sun, 12 December 2010 13:09

linlasj
Messages: 98
Registered: August 2005
Location: LinkÃ¶ping

Member

I would go to some favourite SQL tool and try getting

SELECT Msg.Show_Msg('CM-0071',msg.MCODE,msg.STOP,NULL,NULL,NULL,NULL,lc_disp_item) FROM DUAL;

to run.
Dig in the form what

msg.MTEXT (or msg.MCODE) and msg.STOP and lc_disp_item

are set to.
If you get it to run in SQL it will run in Forms.

Report message to a moderator

Re: Undefined error [message #519568 is a reply to message #486005]

Sun, 14 August 2011 22:23

fadhzone
Messages: 61
Registered: April 2008

Member

As littlefoot said, I miss the procedure. Once i insert the procedure, it work well..Thank you all for helping me out.

Report message to a moderator

Previous Topic:	Set_Item_Property
Next Topic:	Oracle Web

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 21 15:25:36 CDT 2024