Home » SQL & PL/SQL » SQL & PL/SQL » how to get ref of an object
how to get ref of an object [message #36535] Mon, 03 December 2001 07:10 Go to next message
dj
Messages: 8
Registered: December 2001
Junior Member
Hi,

Suppose I have an object foo of type footype
How can I get a ref of the obj without an object
view or table.
That is, in a pl/sql procedure:
I constructed the object foo,
is there a way to get a ref of foo?

Thanks.

----------------------------------------------------------------------
Re: how to get ref of an object [message #36572 is a reply to message #36535] Wed, 05 December 2001 03:55 Go to previous message
Deepu
Messages: 3
Registered: December 2001
Junior Member
In PL/SQL, a pointer has datatype REF X, where REF is short for REFERENCE and X stands for a class of objects. Eg: a cursor variable has datatype REF CURSOR
so it is declared as
TYPE refer_cur_type IS REF CURSOR

in ur case it will be
TYPE refer_foo IS REF foo

hope the info was useful

cya
Deepu

----------------------------------------------------------------------
Previous Topic: DBMS_SQL.EXECUTE
Next Topic: why make_ref cannot be referenced from a pl/sql procedure
Goto Forum:
  


Current Time: Thu Mar 28 10:21:50 CDT 2024