Hi,
I'm just starded using ecpg and I have some problem with cursors.
I wrote this lines
exec sql begin declare section;
char query[500];
int CodImpianto;
int Cod1;
int Cod2;
char Descr[100];
exec sql end declare section;
strcpy(query, "select ............");
exec sql connect db;
sub1()
{
exec sql prepare stmtunimpianto from :query;
exec sql declare CUR_UNIMPIANTO cursor for stmtunimpianto;
.
.
.
exec sql open CUR_UNIMPIANTO using :CodImpianto;
exec sql fetch CUR_UNIMPIANTO into :CodImpianto, :Descr;
.
.
exec sql close CUR_UNIMPIANTO;
exec sql execute StmtUpdImpianti using :Cod1, :Descr, :Cod2; exec sql commit;
}
I call this routine a lot of time.
If I rem the commit all works fine but if I execute the commit the cursor was deleted and I receive some errors.
At open cursor : sqlca.sqlcode = -230 Invalid statement namei in line ......
at fetch : NOTICE : PerformPortalFetch: portal "cur_unimpianto" not found
Please could anyone help me ?
thanks
regards
Maurizio Cauci
DREAMTECH di Cauci Maurizio
Via Ronchetti, 2 - 21013 Gallarate (VA)
www.dreamtech-it.com