Click here to Skip to main content
15,890,845 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:

SQL
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:

SQL
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
Posted
Updated 27-Mar-15 0:12am
v2
Comments
[no name] 27-Mar-15 7:57am    
check may be this link helps you

http://www.codeproject.com/Articles/141728/Interaction-between-C-Application-and-Oracle-throu

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900