OraFAQ Forum: SQL & PL/SQL » ORA-22905 Problem

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22905 Problem (Oracle 10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-22905 Problem [message #304603]

Wed, 05 March 2008 16:02

mouser13
Messages: 2
Registered: March 2008

Junior Member

I get this error ORA-22905: cannot access rows from a non-nested table item. When I run this statement select * from table(nwo_relational_data.getrivergagelevels('PIST'));

Which all this is a wraper for the sql statement select * from local_relational_data where CWMS_ID_UC = 'PIST' and KEY_WORD like 'riverdamagelevel%';
Which works fine.

Just wondering if anyone has any idea's what could be the problem?

CREATE OR REPLACE PACKAGE cwms.nwo_relational_data
IS
TYPE return_cur IS REF CURSOR;

FUNCTION getrivergagelevels (
cwms_id_uc_in VARCHAR2
) RETURN return_cur;

FUNCTION getrivergagelevels (
cwms_id_uc_in VARCHAR2
) RETURN return_cur
IS
tmp_date TIMESTAMP WITH TIME ZONE;
tmp_text VARCHAR2 (1000);
rc_out return_cur;
BEGIN
open rc_out FOR select * from local_relational_data where CWMS_ID_UC = cwms_id_uc_in and KEY_WORD like 'riverdamagelevel%';
return rc_out;

END getrivergagelevels;

Report message to a moderator

Re: ORA-22905 Problem [message #304605 is a reply to message #304603]

Wed, 05 March 2008 16:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

22905, 00000, "cannot access rows from a non-nested table item"
//  *Cause:  attempt to access rows of an item whose type is not known at
//           parse time or that is not of a nested table type
//  *Action: use CAST to cast the item to a nested table type

Report message to a moderator