39
Views
2
Comments
Solved
[Oracle Connector - P11] "PLS-00306: wrong number or types of arguments in call to procedure"
oracle-connector-p11
Web icon
Forge asset by Eduardo Oliveira
Application Type
Traditional Web

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 ? 


2025-01-12 10-53-58
MatheusLima
Solution

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:


UserImage.jpg
Maitha Khanji

it worked after putting the procedures inside a package. Thank you very much for this amazing component!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.