Returned

 Dear Oraclites

        Here is a problem encountered by one of my friends while using
        Pro *C

        The ORACLE version being used is V7.0.13.1.0

        Pro*C version 1.5.7.0.1

        PL/SQL version 2.0.15.1.0

 PROBLEM:
'X' rows to be retrieved from table1. 'X' rows to be retrieved from table2.
'X' rows to be retrieved from table3 ( Master-Detail Query ).

1. Which of the following options will give better performance in terms of execution time,error handling and dynamic SQL methods.In addition to these, any other option exist for better performance?.

 Note 'X' is greater 5000.

 Option 1

        Declaring three cursors and using FOR loops 'X' times.

 Option 2

        Using host arrays of dimension 'X' for each column and  fetching in a batch.

 Option 3

        Using a PL/SQL block inside Pro*C program. This option  can be split in two ways:

1. Declaring a PL/SQL table for each column and equating with host array.
2. Declaring three cursors and using FOR loops for 'X' times.

 Option 4

        Calling a PL/SQL stored procedure from Pro*C and retrieving all the
        column values using PL/SQL tables as parameters of the stored procedure.

 B. Is there any limitation in the dimension of the host array while  passing it to a PL/SQL stored procedure?

 Awaiting your early response eagerly.

                                             \|||/
   Cheers,                                  ( O-O )
 *----------------*-----------*--------.ooo0--(_)-0ooo.--------*
   PANATULA SRIDHAR              Phone : 91-80-5284681/5284682/5284683
   M/S Tata Unisys Ltd.          E-Mail: sridharp_at_tulblr.unisys.com
   George Thangiah Complex
   80 feet road, Indira Nagar             .oooO
   Bangalore, INDIA.  560038              (   )   Oooo.
 *----------------*-----------*------------\ (----(   )---------*
                                            \_)    ) /
                                                  (_/