Strange behaviour calling stored procedure from Pro*C

[Quoted] I have a multi-threaded pro*c program and one of the thread is calling a stored procedure to insert a single record in a partitioned table. The stored procedure is called with in a loop to insert all the records from a file.

[Quoted] However, it seems that not all records are inserted when I query the partitioned table. As if it didn't execute the stored procedure. [Quoted] Strangely, this doesn't happen to a particular record but instead randomly when I reload the file. For example, record 20 (out of 5000) is not inserted and record 31 is inserted but after cleaning up the table and reloads the file, record 20 is inserted and record 31 is not.

The table is partitioned by date (day to day basis) and all records belong to the same day. I noticed that the temp tablespace is full but does it affect anything in my loading to partitioned table?

[Quoted] The weird thing is that there is no error returned from the stored procedure to indicated that the record failed to insert.

 Need help on this. Please..Please.. Thanks in advance.

By the way I'm using 10g in AIX 5.3 os Received on Sat Feb 11 2006 - 15:24:50 CET