Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-02035: illegal bundled operation combination

Ciccio_3
Occasional Visitor

ORA-02035: illegal bundled operation combination

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.
1 REPLY
Steve Steel
Honored Contributor

Re: ORA-02035: illegal bundled operation combination

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
If you want truly to understand something, try to change it. (Kurt Lewin)