I have tried to write a package that will call a remote database to
return multiple rows of data. It does not seem I can use a table type
for each variable ( then a reference). How do i do that? right now if
I use table type ( a reference), my local function will not recognize
the reference of the remote site; if I use just the datatype of each
colum and the Cursor i open to fetch data
ex
OPEN cursor for SQL
LOOP.
FETCH..
INTO
0_a := v_a;
LOOP END;
I got the implicit(-1) ORA-02005 error
Received on Wed Nov 07 2001 - 22:55:31 CST
