Objects 1

[jbm417]

I am trying to learn about objects, but progess is stopped.

I attempted to create an object with the following:

CREATE type my_obj
AS object (
val1 VARCHAR2(10),
val2 VARCHAR2(10),
val3 date
)

I think the creation was successful, but have been unable to verify.

Is there a way I can prove that my_obj exists; e.g.
select * from sys_objects (psuecocode)

TIA, Joe

 

[Dagon]

You can check that the object exists and is valid using:

select * from user_objects where OBJECT_name = 'MY_OBJ'

To look at the definition, you could use:

SELECT text FROM user_source where name = 'MY_OBJ' 
order by line