OraFAQ Forum: Forms » ORA-06553: PLS-306 ,FRM-40505:

Home » Developer & Programmer » Forms » ORA-06553: PLS-306 ,FRM-40505: (Oracle Forms Forms [32 Bit] Version 10.1.2.0.2, RDBMS : 11.2.0.2.0, Oracle Applications : 12.1.3)

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

ORA-06553: PLS-306 ,FRM-40505: [message #608114]

Sun, 16 February 2014 06:02

ragunda
Messages: 2
Registered: February 2014
Location: Ghana

Junior Member

Hi Experts,

I have developed a new form and able to record data, but when I try to query the records, I am getting below error.
=====================================================================================
ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

--------------------------------------------------------------
FRM-40505: ORACLE error: unable to perform query.
=====================================================================================

Looked at all the available options and unable to resolve the issue, Can you please suggest me what could be the reason.

Thanks a lot for your help in advance !!!

Regards,
Ravi Gunda.

Attachment: XXGIFMIS_TRANSFER.fmb
(Size: 1.13MB, Downloaded 1339 times)

Report message to a moderator

Re: ORA-06553: PLS-306 ,FRM-40505: [message #608116 is a reply to message #608114]

Sun, 16 February 2014 08:39

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

Senior Member
Account Moderator

As the error appears when querying records, do you have any POST-QUERY triggers? If so, could you post its/their code here?

Report message to a moderator

Re: ORA-06553: PLS-306 ,FRM-40505: [message #608121 is a reply to message #608116]

Sun, 16 February 2014 09:24

ragunda
Messages: 2
Registered: February 2014
Location: Ghana

Junior Member

Hi,

I kept messages at start of each trigger and no message is shown, hence I think that it is not even going to POST_QUERY Triggers, I have attached the form in my initial request and I am not able to post the trigger details below as it is lengthy.

Please let me know if you can ping me on ravikumar.x.gunda@gmail.com or please share your email id.

Thank you very much for your support.

Regards,
Ravi Gunda.

Report message to a moderator

Re: ORA-06553: PLS-306 ,FRM-40505: [message #610841 is a reply to message #608121]

Tue, 25 March 2014 02:03

nhvduy
Messages: 4
Registered: October 2013
Location: HCM City

Junior Member

i think the problem is you wrote a wrong query. please post your query which you placed in datablock here.( i don't have form builder in my computer so i could not open your from you attached in your initial post).

[Updated on: Tue, 25 March 2014 02:05]

Report message to a moderator

Previous Topic:	Creating a UTF-8 text file from Oracle Forms 6i
Next Topic:	WEBUTIL_CLIENTINFO.GET_USER_NAME

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 21:56:16 CST 2025