SQL & PL/SQL

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!

String representations of ADT:s?

79922Sep 16 2002

Hey there,

I am wondering if there exists a way to retrieve a string representation of an abstract data type?

I have written a database management and query analyzer program for Oracle databases using the .NET platform. But since ADO.NET (not even the Oracle data provider) does not support ADTs, I get a problem with tables containing them.

How I hope to circumvent the problem is to convert any USERDEFINED data types to string (VARCHAR2 or such) representations that can be understood by ADO. (In the same way you can convert dates using the to_char function.)

If anyone has any ideas, please contact me or leave an answer here in the forum.

Thanks in advance,

Johan Behrenfeldt

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2002

Added on Sep 16 2002

4 comments

260 views