Home » SQL & PL/SQL » SQL & PL/SQL » ERROR PLS-00306 (SQLPLUS)
ERROR PLS-00306 [message #569996] Sun, 04 November 2012 09:48 Go to next message
Arandhawa23
Messages: 10
Registered: August 2012
Location: United States
Junior Member
My application is running and am getting this error:

GMS database Error : COracle_OCI_base:ErrChk:
COracle_OCI_SerNum::GetIdentifiers:
COracle_OCI_Procedure::execProcedure:OCIStmtExecute() returned: 6550: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETIDENTIFIERS'
ORA-06550: line 1, col

I am using Oracle SQL Developer end here is the package I have created:

create or replace package RIMSOUTH.V2_SER_JAVELIN as
procedure GetIdentifiers(pi_unit_id out VARCHAR2, rec in VARCHAR2, po_err_code out VARCHAR2, po_err_msg out VARCHAR2);
end V2_SER_JAVELIN;
/

create or replace package body RIMSOUTH.V2_SER_JAVELIN as
procedure GetIdentifiers(pi_unit_id out VARCHAR2, rec in VARCHAR2, po_err_code out VARCHAR2, po_err_msg out VARCHAR2) is
begin
pi_unit_id:='0';
po_err_code:='0';
po_err_msg:='none';
end GetIdentifiers;
end V2_SER_JAVELIN;
/

I don't understand why I am recieving this error. If anyone can guide me, it will be great!
Re: ERROR PLS-00306 [message #569997 is a reply to message #569996] Sun, 04 November 2012 09:53 Go to previous messageGo to next message
BlackSwan
Messages: 23143
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

GETIDENTIFIERS is written to expect one IN argument & three OUT arguments all of VARCHAR2 datatype.
Oracle throws error when the number of arguments or datatype differ from above.

You need to post the code that actually calls or invokeS GETIDENTIFIERS procedure
Re: ERROR PLS-00306 [message #569998 is a reply to message #569997] Sun, 04 November 2012 10:00 Go to previous messageGo to next message
Arandhawa23
Messages: 10
Registered: August 2012
Location: United States
Junior Member
Here is the Code:

ASCII "COracle_OCI_SerNum::GetIdentifiers:"
ASCII "BEGIN RIMSOUTH.V2_SER_JAVELIN.GetIdentifiers(:pi_unit_id, :rec, :po_err_code, :po_err_msg); END;"
ASCII ":pi_unit_id"
ASCII ":rec"
ASCII ":po_err_code"
ASCII ":po_err_msg"
Re: ERROR PLS-00306 [message #569999 is a reply to message #569998] Sun, 04 November 2012 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 23143
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

results from GOOGLE are below:
Your search - COracle_OCI_SerNum - did not match any documents.
Why is this true?

please post code excerpt from example where different procedure is called successfully.
Re: ERROR PLS-00306 [message #570000 is a reply to message #569999] Sun, 04 November 2012 10:09 Go to previous messageGo to next message
Arandhawa23
Messages: 10
Registered: August 2012
Location: United States
Junior Member
THe program completely runs from Oracle and this is the callings it does to Oracle.
Re: ERROR PLS-00306 [message #570001 is a reply to message #570000] Sun, 04 November 2012 10:11 Go to previous messageGo to next message
BlackSwan
Messages: 23143
Registered: January 2009
Senior Member
I give up.
You're On Your Own (YOYO)!
Re: ERROR PLS-00306 [message #570002 is a reply to message #570001] Sun, 04 November 2012 10:12 Go to previous messageGo to next message
Arandhawa23
Messages: 10
Registered: August 2012
Location: United States
Junior Member
I gave the code and the callings it does. What else are you looking for ?
Re: ERROR PLS-00306 [message #570005 is a reply to message #569998] Sun, 04 November 2012 11:15 Go to previous message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
Arandhawa23 wrote on Sun, 04 November 2012 16:00
Here is the Code:

ASCII "COracle_OCI_SerNum::GetIdentifiers:"
ASCII "BEGIN RIMSOUTH.V2_SER_JAVELIN.GetIdentifiers(:pi_unit_id, :rec, :po_err_code, :po_err_msg); END;"
ASCII ":pi_unit_id"
ASCII ":rec"
ASCII ":po_err_code"
ASCII ":po_err_msg"



What is ascii in the above example?
Where are the variables declared?
What programming language/tool are you using to run that code?

Previous Topic: missing parenthesis error
Next Topic: Get all possible paths
Goto Forum:
  


Current Time: Thu Dec 18 14:42:33 CST 2014

Total time taken to generate the page: 0.08642 seconds