CODEWITHSUNDEEP
c#oracle-databaseasp.net-corestored-procedures
Sohlae
Sohlae

Reputation: 786

Received PLS-00201 error when executing stored procedure from .NET app

I have tried to look for the solutions found regarding this error but I couldn't find anything that is similar to my situation. We built a .NET API which executes the stored procedure.

IDbConnection connection = new OracleConnection(_connString);
connection.Open();

var parameters = new OracleDynamicParameters();
parameters.Add("is_active", request.IsActive, OracleMappingType.Int16, direction: ParameterDirection.Input);
// Other parameters

await connection.QueryAsync("STORED_PROCEDURE_NAME", parameters, commandType: CommandType.StoredProcedure);

What is strange is that when I executed the API locally via Postman, everything works as expected, but when we deployed it to AKS and tested it, we get the error.

Please note that this stored procedure was created without a package name (I don't know the reason behind).

Error message:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'STORED_PROCEDURE_NAME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Code:

CREATE OR REPLACE PROCEDURE STORED_PROCEDURE_NAME
( is_active    IN number,
  ... other parameters
)

Can someone guide me on what the things we can do to investigate this issue further?

Upvotes: 0

Views: 57

Answers (0)

Related Questions