This content has been marked as final. Show 1 reply
Not sure if my answers are going to help. Anyway here they are -
1. Is it possible to call this "CLR c#" stored procedure in a different way than I call a standard pl/sql stored procedure from a C# client, maybe by something like referring to the same c# classname which I chose to wrap the stored procedure/function in?
2. Is it possible to eg. return c# classes or c# arrays / own datatypes created within the CLR stored procedure to a C# client (without using a self-written service layer)?
3. Can I build up a c# array within my oracle c# stored procedure and return it to a C# client directly, or do I still have to do all the marshalling based on the standard pre-defined data types (number, varchar2 etc) myself and copy them to c# class members?
Answer: You can return only the .NET types supported by .NET stored procedures. These are listed in the user doc. I can not think of an easy solution for returning complex object types using .NET stored procedures.