OraFAQ Forum: Forms » ORACLE error 6550 in FDPSTP

Home » Developer & Programmer » Forms » ORACLE error 6550 in FDPSTP (forms6i,apps 11.5.10)

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

ORACLE error 6550 in FDPSTP [message #512611]

Tue, 21 June 2011 03:06

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

Hi,

I am getting following error when we submit request through button in forms.but backend it is created.

ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXPL_PO_REQ_INTER_MAIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #512617 is a reply to message #512611]

Tue, 21 June 2011 03:30

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

Senior Member

The error message is clear.
You are either:
a) passing the wrong number of parameters to XXPL_PO_REQ_INTER_MAIN.
b) passing parameters of the wrong datatype to XXPL_PO_REQ_INTER_MAIN.

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #512632 is a reply to message #512617]

Tue, 21 June 2011 04:35

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

This is my procedure.i did not use any additional parameters.but i am getting same error.but backend it is created.

PROCEDURE XXPL_PO_REQ_INTER_MAIN(P_ERRBUF OUT NOCOPY VARCHAR2,
P_RETCODE OUT NOCOPY NUMBER) IS

[Updated on: Tue, 21 June 2011 04:36]

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #512634 is a reply to message #512632]

Tue, 21 June 2011 04:37

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

Senior Member

That does not change my answer.
You have some code that calls that procedure. It is supplying the wrong number or type of parameters.
So you get that error.

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #512638 is a reply to message #512634]

Tue, 21 June 2011 05:06

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

But back end it is executed successfully.

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #512639 is a reply to message #512638]

Tue, 21 June 2011 05:17

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

Senior Member

What does that mean?

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #512645 is a reply to message #512639]

Tue, 21 June 2011 05:40

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

I have created package and executed successfully and registered as concprogram after submition getting output(this is direct concprogram running).and same concprogram is calling from forms it is giving this error.

ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXPL_PO_REQ_INTER_MAIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #512661 is a reply to message #512645]

Tue, 21 June 2011 06:37

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

Senior Member

You realise there is a difference between creating a procedure (ie loading the source code of the procedure into the DB) and calling a procedure (ie doing:

BEGIN
  XXPL_PO_REQ_INTER_MAIN(<parameter1>, <parameter2>);
END;

and having oracle actually execute the code in the procedure (selects, inserts, whatever))
Don't you?

The answer remains the same.
When you call it you need to pass two parameters. 1 Varchar2 and 1 Number.
You aren't.

Report message to a moderator

Previous Topic:	ORA-03114 error when lauching web form
Next Topic:	forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 06:00:55 CDT 2024