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)
ORA-06553: PLS-306 ,FRM-40505: [message #608114] Sun, 16 February 2014 06:02 Go to next message
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.

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 Go to previous messageGo to next message
Littlefoot
Messages: 21809
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 00:30:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.