This content has been marked as final. Show 1 reply
think I have found some small print which scuppers my plan. Good if some one could confirm and nicer if someone could suggest a workaround (without resorting to writing the UDT to a Oracle table)
Oracle User-Defined Type (UDT) Support
UDTs are not supported within a context connection but they are supported with a client connection. UDTs are not supported as parameters to .NET stored procedures.
So you can use UDT's within the body of the procedure (and can read them off the DB) but as yet its not possible to use them as parameters.