ORA-02035: illegal bundled operation combination

[Ciccio_3]

Hi,
I have a HP-9000 with HP-UX B.11.11 U 9000/800 and I've installed Oracle 8.1.7 (rel 3) on it.
During execution it gave me this error:
"ORA-02035: illegal bundled operation combination".
Client programs are developed in PRO-C using cursors.
Below main program:


/***********************************/
int main(int argc, char *argv[])
{
int NumRecord;

SetEnvVariables();

/* Connessione al DB */
printf("\n Connessione al DB \n");
fflush(stdout);

ConnettiDb();

if (TrapSql("Connessione DB"))
exit(-1);

EXEC SQL ALLOCATE :aor_cursor;
if (TrapSql("Allocate cursor aor_cursor"))
exit(-1);

cod_utr = 0;
EXEC SQL EXECUTE
BEGIN
:aor_cursor := FindAOR(:cod_utr);
END;
END-EXEC;
if (TrapSql("Esecuzione FindAOR"))
exit(-1);

for (NumRecord=0;;NumRecord++)
{
EXEC SQL FETCH :aor_cursor
INTO :RecFindAOR INDICATOR :IndRecFindAOR;
if (SQLCODE == NOT_FOUND)
break;

if (TrapSql("Fetch Select aor_cursor"))
exit(-1);

ChiudiStrAOR();

if(NumRecord== 0)
printf("\n Selezione AOR#");
printf("\n 0 Codice=|%d|#",RecFindAOR.cod_aor);
printf("\n 0 Valore=|%s|#\n",RecFindAOR.aor.arr);

}

if(NumRecord==0)
printf("\n---- NESSUNA AOR\n");
printf("\n---- Fine Selezione AOR\n");


EXEC SQL CLOSE :aor_cursor;
if (TrapSql("Close Cursor aor_cursor"))
exit(-1);

cod_utr = 0;
EXEC SQL EXECUTE
BEGIN
:aor_cursor := FindAOR(:cod_utr);
END;
END-EXEC;
if (TrapSql("Esecuzione FindAOR"))
exit(-1);

for (NumRecord=0;;NumRecord++)
{
EXEC SQL FETCH :aor_cursor
INTO :RecFindAOR INDICATOR :IndRecFindAOR;
if (SQLCODE == NOT_FOUND)
break;

if (TrapSql("Fetch Select aor_cursor"))
exit(-1);

ChiudiStrAOR();

if(NumRecord== 0)
printf("\n Selezione AOR#");
printf("\n 1 Codice=|%d|#",RecFindAOR.cod_aor);
printf("\n 1 Valore=|%s|#\n",RecFindAOR.aor.arr);

}

if(NumRecord==0)
printf("\n---- NESSUNA AOR\n");
printf("\n---- Fine Selezione AOR\n");

EXEC SQL CLOSE :aor_cursor;
if (TrapSql("Close Cursor aor_cursor"))
exit(-1);

EXEC SQL FREE :aor_cursor;
if (TrapSql("Close Cursor aor_cursor"))
exit(-1);

DisconnettiDb();
if (TrapSql("Disconnessaione DB"))
exit(-1);
}
/***********************************/

"FindAOR" is executed twice but at the second time it gave me the previous error.

Could you give me a solution.

Thanks a lot.

Bye.

[Steve Steel]

Hi

ORA-02035: illegal bundled operation combination
Cause: UPI bundled execution call was requested on an illegal combination of operations.

Action: Use a legal combination of operations and retry.


Looks like a coding fault.Suggest Oracle could help you better


Steve Steel