OO4O - CreatePlSQLDynaset

From: <rob_raymond_at_hotmail.com>
Date: Wed, 27 May 1998 15:57:52 GMT
Message-ID: <6khd60$gnb$1@nnrp1.dejanews.com>

Please help...

I am using a REF CURSOR to return a result set to an OO4O dynaset. However when I run as a user other than the package/schema owner I get no rows returned.

I have tested the REF CURSOR (below) in SQL Worksheet and it returns the expected result set running as a "normal" user. The REF CURSOR is from ALL_INDEXES, ALL_IND_COLUMNS and ALL_CONSTRAINTS.

I have also tested it with a PowerBuilder DW, this retrieved no rows, the same as the dynaset in OO4O.

Any ideas what is wrong?

TIA Rob

SQLWKS> declare
     2>     cur rtf_access_import.index_defn_cur;
     3>     rec rtf_access_import.index_defn_rec;
     4>
     5> begin
     6>     rtf_access_import.p_index_defn('RTF_VAR_REPORTS', cur);
     7>
     8>     fetch cur into rec;
     9>     while cur%found loop
    10>         dbms_output.put_line(rec.index_name ¦¦ ' ' ¦¦

rec.constraint_type);

    11>
    12>         fetch cur into rec;
    13>     end loop;
    14>
    15>     close cur;
    16>
    17>     dbms_output.put_line('finished - ' ¦¦ user);
    18> end;
    19>

Statement processed.

RTF_VAR_REPORTS_OBJ_IX
RTF_VAR_REPORTS_OBJ_IX
RTF_VAR_REPORTS_PK P
RTF_VAR_REPORTS_UK1 U
RTF_VAR_REPORTS_UK2 U

finished - CDEANS

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 27 1998 - 10:57:52 CDT