PL/SQL reference cursor problem - OO4O..

I have a procedure which returns a cursor reference to any one of a number of tables. The procedure is called a number of times, each time a different table is requested.

e.g.

if table_req = 'x' then

        open csr for select a,b from x
elsif table_req = 'y' then

        open csr for select a,b, from y
...
end if;

All values in the select statements are converted to the same form (using to_number, substr, etc) to make the returned values uniform.

This procedure is called from a C program via Oracle Objects for OLE
(oo4o). Once the cursor has been returned to the program, it controls the
fetching and closing within oo4o.

Depending on the ordering of the open cursor statements, the oo4o program will hang during execution of the procedure for one of the tables
(according to a SQLNet trace, during a packet read). It's possible to order
the statements so that all executions work correctly.

Any ideas as to what is going on?

Andy Received on Sat May 02 1998 - 00:00:00 CEST