Re: Dynamic SQL - using cursors

Hello,
I can't solve your problem, but do you go to  http://alliance.oracle.com/public/3convkit.htm they have documentation, white papers and toolkit to migrate other db (as Ingres) to Oracle.
Perhaps you will find informations to your problem

Hope your help

Regards. Olivier

pkuditip_at_itds.com wrote:

> I am porting some code from Ingres to Oracle
> ----------------------------------------------
> .......
> .......
> 1. Can I open cursor in one procedure, leave it go back to Pro C program and
> then later come back and do a fetch in another procedure using the previously
> opened cursor in the first procedure.
> 2. Can I do EXEC SQL DESCRIBE SELECT LIST FOR sqlstmt INTO select_dp;
>
> My code won't know until run-time what tables and what columns in those
> tables I will need to access and as to how many such table(s) I will be
> accessing - So I don't know how many cursors ahead of time either.
> Please help.
> Padma
> e-mail: pkuditip_at_itds.com
Received on Thu Sep 03 1998 - 00:00:00 CDT