Is not a procedure or is undefined

[Angel2994]

Hello everyone! I have tried to fix this error but nothing it´s okay. I need help please. This ins't working. The error is this: Is not a procedure or is undefined\nORA-06550

I need to extract to values and insert into a package with a solution, two values are static (p_CIA and p_Event) and one value (p_Result) is a boolean who has to return OK if the everything was succeeded. But I can not insert any value in the Oracle DataBase.

This is my Package with the function.


create or replace PACKAGE BODY "MR_PCK_APX_PROC_SOL" AS

FUNCTION F_Registrar_Evento_Externo(p_CIA IN VARCHAR2 ,
p_OD IN VARCHAR2,
p_Event IN VARCHAR2 ,
p_Catal IN VARCHAR2 ,
p_Result OUT VARCHAR2)
RETURN BOOLEAN IS

==============================================================================

This is my project

if (item1.Contains("Gest"))
{

CDZ030Event = "CDZ030";
//Console.WriteLine("SUBJECT:" + " " + "OD:" + match1.Value + " " + "Status:" + saveitem1 + " " + "Cod Event:" + CDZ030EvenT);
Console.WriteLine("ASUNTO:" + " " + "ODT:" + ODT00.Trim() + "Cod Event:" + " " + CDZ030Evento);

try
{
OracleConnection con = c.GetConnection();

//using (OracleCommand Cmmd = new OracleCommand(conectoOra))
using (OracleCommand Cmmd = new OracleCommand("ADR.MR_PCK_APX_PROC_SOLV.F_Reg_Event_Ext", con))
{


Cmmd.CommandType = CommandType.StoredProcedure;
Cmmd.BindByName = true;
//Cmmd.Parameters.Add("Return_Value", OracleDbType.Int16, ParameterDirection.ReturnValue);
Cmmd.Parameters.Add("p_CIA", OracleDbType.Varchar2, ParameterDirection.Input).Value = "71";
Cmmd.Parameters.Add("p_ODT", OracleDbType.Varchar2, ParameterDirection.Input).Value = ODT00.Trim();
Cmmd.Parameters.Add("p_Evento", OracleDbType.Varchar2, ParameterDirection.Input).Value = CDZ030Evento;
Cmmd.Parameters.Add("p_Catalogo", OracleDbType.Varchar2, ParameterDirection.Input).Value = "VISDOW";
Cmmd.Parameters.Add("p_Resultado", OracleDbType.Char).Value = "1";

Cmmd.ExecuteNonQuery();
Console.Write("Datos ingresados");
}

}
catch (Exception ex)
{
Console.Write("Error al ingresar");
Console.WriteLine("");
}

}

This is my string connection

<add name="connectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=191.192.1.1)(PORT=1111)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ABC))); User Id=TEST; Password=TES123"/>

Continue reading...