i have a win c# application and i would to call a oracle package function having a type as input
in oracle my type is defined in this way:
CREATE OR REPLACE
TYPE "CLIENTE" AS OBJECT
(ID_CLIENTE NUMBER,
ID_COMUNE NUMBER,
ID_CONSORZIO NUMBER,
COD_LINEA_ATTIVITA VARCHAR2(4),
COD_SETTORE_ATTIVITA VARCHAR2(4));
in oracle my function is defined in this way:
FUNCTION CREA_CLIENTE (pDatiGenerali IN CLIENTE, pMessage IN OUT VARCHAR2) RETURN
NUMBER;
i would to call function CREA_CLIENTE in my c# code but i don't know how to call it,
how to define my input type pDatiGenerali and which kind of oracle client use to be able to call type in input.
can you post an example call for my case?
thanks in advance