Rewriting code for backward compatibility with version 8.1.6
396862Apr 21 2008 — edited Apr 21 2008Hi,
I am using ref cursors to ouput the data from diff tables to the Java front end.
IN 9i and 10g databases, i am easily using the
Inline select and cusrosr within cusror
select a, (select b from b1 where b1.id = a1.id),Cusror(select c from c1 where c.id = a1.id ) from a1 where a.id = 1;
But when run in the 8.1.6 database version, i am able to get these as simple select statements but not as PL/SQL Blocks.
AS the volume of joins in the secondary curors, and the inline selects is large, if i rewrite the query with the values in the FROM clause the queries are dying out.
Please suggest if there is any quick turnaround as i need to reuse the code in 9i with minimal rewriting.