Object Relational database select statement problem

[Patros]

Greetings,
Simply put my problem is this, I am attempting to get the values gameStock and gameSales [part of an object called Stockinfo)
The table format is
Name Null? Type
------- -------- ---------------
ISBN VARCHAR2(14)
NAME VARCHAR2(25)
GENRE VARCHAR2(15)
WARNING VARCHAR2(4)
RELEASEDATE DATE
PRICE NUMBER
STOCKINFO GAMEINFO

I can insert details and the likes, however I can only seem to access the data within stockinfo when I type select * and this just isn't suitable for my application. I have attempted to do select game.gamedetails.stockinfo.gameStock from game;
However this returns the
"GAME"."GAMEDETAILS"."STOCKINFO"."GAMESTOCK": invalid identifier
Thanks in advance for any help you can give.
Patros

 

[51m0n]

try table ( cast( multiset( ... )))