Oracle 8i / User-Defined Type Problem
Posted on 2003-11-18
I am trying to create a user-defined type within Oracle, for example:
Create Type User_Tmp as Object
I then created a function, for example:
Create or replace function GetUser as User_Tmp is
myObj User_Tmp := User_Tmp(null,null)
myObj.First_Name := 'John';
myObj.Last_Name := 'Doe';
When I call this from SQLPlus (or Toad) it works successfully. However, when calling it from a .NET app it throws an exception with the following message:
"Unsupported Oracle data type USERDEFINED encountered."
Any ideas how I can get around this?