how to store opaque package-types in tables ? (ora 7.3)

From: <Torsten.Reichert_at_gmx.net>
Date: Wed, 10 Nov 1999 21:00:13 +0100
Message-ID: <3829CECD.BCC5CE5F@gmx.net>

Hello,

oracle recommends:
<
TYPE file_type IS RECORD (id BINARY_INTEGER); The contents of FILE_TYPE are private to the UTL_FILE package. Users of the package should not reference or change components of this record.
>

A naive first trial to stick to that recommendation renders: SQLWKS> create table PROT_C_HANDLE

2> (
3>     fd		UTL_FILE.FILE_TYPE
4> )
5> 
6> 
fd	UTL_FILE.FILE_TYPE
	*

ORA-00902: invalid datatype

Is there any way to store an opaque type in a table ? ( Maybe functions for casting to long or raw )

Thank you

Received on Wed Nov 10 1999 - 14:00:13 CST