Toad World® Forums

Problem with ROWID


#1

Hi,

I am trying to run test where I have procedure returning cursor t_cur

definition:
t_row table%ROWTYPE;

TYPE t_rec IS RECORD
(
name t_row.name_type,


the_rowid ROWID
);

TYPE t_cur IS REF CURSOR RETURN t_rec;

My specify column list with query:
select name, …, ROWID from table

Resolve:
Compilation of the test code package specification failed.

Thank all


#2

Sigh, yes, known issue (though we have not yet added it to the list). Our generated code creates an object type to use with a table function, and Oracle does not support ROWIDs as types in object types.

I will log this as a bug and look into what it will take to fix.

SF


#3

As a workaround, you should use ROWIDTOCHAR to convert to string and compare those.

SF


#4

Thanks for replays

I create new procedure where I’m calling my procedure and testing collection t_tab
(FETCH t_cur BULK COLLECT INTO t_tab).

I resolve the problem with object type and it’s work…


#5

So glad to hear it!