oo database and deref
Date: 2000/05/18
Message-ID: <8g0ld0$r3v$1_at_nnrp1.deja.com>#1/1
I use the following statements to create object tables:
CREATE OR REPLACE TYPE Player_type AS OBJECT (
CREATE TABLE Player_table OF Player_type (
In player_table ID's are running from 1 to 1000.
When I tried to deref tuples, I get errors. Here
are the commands:
declare
ERROR at line 1:
ID INTEGER,
Title VARCHAR2(20),
FirstName VARCHAR2(30),
SurName VARCHAR2(30)
);
/
ID NOT NULL,
SurName NOT NULL,
PRIMARY KEY (ID)
);
myplayer REF player_type;
mp player_type;
begin
select ref(a) into myplayer from player_table a where id = 220;
select deref(myplayer) into mp from player_table;
end;
/
What am I doing wrong? Is there a mistake I don't see?
Any commends are appreciated!
Thx in advance,
Tom
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu May 18 2000 - 00:00:00 CEST