Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deploying c# procedure with user-defined type

915614Feb 6 2012 — edited Feb 7 2012
Hi
I've written a c# procedure which makes use of some Oracle user-defined types (c# classes generated using the wizard).

I will be calling the procedure from an Oracle package and one of the out parameters needs to be one of my user defined Oracle objects (basically a record object). My problem is when I come to deploy the package, it tells me "... does not contain any .NET stored procedures that can be deployed to Oracle"

If I change the user defined type (out param) to something like an Int32 or string, it works fine. AFAIK the latest version of ODT/ODAC supports user defined types. For Info I've 11g Client , .Net v4 & VS2010

quick example of procedure entry point.

works:
public static void GetOrderCost(int OrderNr, out Int32 orderCost )

Not work:
public static void GetOrderCost(int OrderNr, out ORDER_RECORD orderCost ) - Note: ORDER_RECORD is the class created using the class generation wizard.

I've spent 2 days now trying to get this to work, perhaps its not possible or perhaps my setup is not quite right but any help gratefully received.

Ian

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 6 2012
Added on Feb 6 2012
1 comment
2,020 views