This content has been marked as final. Show 6 replies
For now, odp.net supports PL/SQL Associate Array only (you can also look into array bind)
Any changes about this question?
I'am realy want to pass subtype from my package like below to stored procedure incoming parameter
PACKAGE "FIRST_PACK" IS
SubType tFIRST_TABLE is FIRST_TABLE%rowtype;
) return Number;
I need to call from c# this stored procedure "FIRST_PACK.fSet_First"
How can I pass to this stored procedure parameter like "FIRST_PACK.tFIRST_TABLE" ?
Or may be FIRST_TABLE%rowtype
Please help me!
Thanks a lot
No TABLE or RECORD support available in ODP.NET, but you can create your own user-defined types, which mimic your table/record type you want to use.
It's very very pity..
I have already got a lot of stored procedures with passing arguments(parameters) like this
Is that means I mast to change all of them to pass UDT parameters into it ?
Or any other way exists?
How can I mimic record/table type by UDT ?
Be grateful for any suggestion
Thinking about this a bit more, it would be easier to map these RECORD and TABLE types into REF CURSORs or temporary DB tables if you need to scrollability and updatability. With UDTs, you would need to convert these RECORDs and TABLEs to UDTs, then map the UDTs to .NET types.
If you would like to look further into UDTs, there's a great tutorial here that shows how to automate the mapping easily from Oracle UDTs to .NET custom types using Visual Studio to do most of the mapping work.
Thanks for your replay, Alex!
I think using UDT's in my case are more closer in realization (using record/table types very similar).
I should create some number of wrapping functions for my existing functions and accessing from c# through them
I'm very grateful for participation and help