Dynamic SQL

From: Yaoming Duan <yduan_at_usa.net>
Date: Fri, 25 Feb 2000 19:22:20 -0500
Message-ID: <38B71CBC.5D71BE77@usa.net>

Hi,

I have a stored procedure to do bulk insert using Dynamic SQL(open cursor, bind array, and execute). The SP works fine in Oracle8i, but has problem in ver 8.0.4. Sometimes it works, sometimes not. Usually when there are large number of records to insert, it fails. But this problem doesn't happen in Oracle8i.

The error message is

"ORA-01438:value larger than specified precision allows for this column"

and sometimes when there are huge number of records like more than 5000, the error is

"ORA-03113:end-of-file on communication channel"

Any suggestions? Thanks

Yaoming Duan Received on Fri Feb 25 2000 - 18:22:20 CST