we have an Oracle database with stored procedures that have UDT's as IN/OUT-parameter.
The environment ist VS2010 (Telerik OpenAccess Class Library Project) , C#, Oracle11gR2, ODP.net 1120320, OA Q3_2012-SP1
Currently I don't get it done.
After the model creation wizard (populate from DB) has run Visual Studio shows errors:
The specified clr type 'Object' is not valid for the parameter PAR_RESULT of the procedure 'VFADMIN2_SCHEMA'.'VE_PA_ASSC'.'PR_CHANGE_A_RDJC_RESTRICT'.
The SP in the database is defined as follows:
(PAR_SESSION in ve_ty_session ,
PAR_RESULT out ve_ty_result ,
PAR_EOID_JUNCTION in number ,
PAR_EOID_RDEL_OLD in number ,
PAR_EOID_RDEL_NEW in number );
The type in the database is defined as follows:
create or replace type VE_TY_RESULT
RES_TYPE number (0001) ,
RES_CODE number (0010) ,
RES_MESS varchar2 (0240) ,
RES_TIME date ,
From all that I've read so far, I think that OA is capable of what is needed.
Maybe you could direct me to the right part of the documentation.