|
Re: ORACLE error 6550 in FDPSTP [message #512617 is a reply to message #512611] |
Tue, 21 June 2011 03:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 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.
|
|
|
|
|
|
|
|
Re: ORACLE error 6550 in FDPSTP [message #512661 is a reply to message #512645] |
Tue, 21 June 2011 06:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 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.
|
|
|