(OCI, piecewise) oexec returns ORA-3129 after osetpi with OCI_LAST_PIECE

From: Shaya <sh_ya_at_yahoo.com>
Date: Thu, 30 Sep 1999 10:21:11 GMT
Message-ID: <37f335cf.12156149@88.0.3.103>

Hi All
I'm trying to create a test program to "play" with piecewise operations. I took the example from the OCI and implemented it with only minor changes , but after I issue a osetpi with a OCI_LAST_PIECE I still get ORA-03129 after the oexec. Any ideas?

Attached is my code (the piecewise loop only)

thanks in advance
Shaya

	Piece = OCI_FIRST_PIECE;
	while(cont)
	{
		oexec(&cda);
		switch(cda.rc)
		{
		case 0:
			cont = 0;/* end of insert */
			break;
		case OCI_MORE_INSERT_PIECES:
			count++;
			ogetpi(&cda, &Piece, &Context, &Iter,

&PlsqlTab);

			if (count > 20)


			{


				Piece = OCI_LAST_PIECE;
			}
			osetpi(&cda,Piece,pPieceBuf,&BufSize);
			if (Piece == OCI_FIRST_PIECE)


			{


				Piece = OCI_NEXT_PIECE;
			}
			break;
		default:
			exit_oci(cda);
		}/* end switch */
	}
	ocom(&lda); /* commit */

Received on Thu Sep 30 1999 - 05:21:11 CDT