Hello,
I am using the Oracle Connector - P11 component in a Reactive application to call an oracle PL/SQL procedure from a server action, but I am getting the following error:
ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'my_procedure'ORA-06550: line 1, column 7:PL/SQL: Statement ignored
I have this procedure in oracle:
CREATE OR REPLACE PROCEDURE apps.my_procedure (
p_ERRBUF OUT VARCHAR2,
p_RETCODE OUT VARCHAR2,
p_API_VERSION IN NUMBER,
p_AOL_USER IN NUMBER
)
AS
BEGIN
APPS.some_package.Import(
p_ERRBUF,
p_RETCODE,
p_API_VERSION,
p_AOL_USER
);
END my_procedure ;
The following is my input structure. Note that I tried Integer and Decimal data types but for both of them i get the same error.
Input structure:
The input variable
Output structure:
The output variable
The method (the procedure is not within a package, i checked the c# extension it handles this case in the "createCommand" method so it is fine not to input a package name )
What is my problem? How can I fix the issue ?
I did a quick look and don't find any problem in your code, but all my use cases with this component was doing it with procedures inside a package, try to put the procedure inside a package just to test.
Fill like here:
it worked after putting the procedures inside a package. Thank you very much for this amazing component!