Inconsistent results-calling stored procedures in CallableStatement

I had given the parameter "{call test_procedure(?,?,?)}' for the CallableStatement. The 3rd '?' gives the OUT parameter.

The stored procedure is supposed to insert some data to a particular table.

Executing the program and freshly calling the procedure, no exception is thrown, the records get successfully inserted.

But, on firther calling the same procedure again continuing with the execution, SQLException is thrown, the error shown being -

"ODBC error - ORA-0911-invalid character..."

The same exception occurs when the inserted records are deleted at SQL prompt, and calling the same procedure continuing with the execution..

But sometimes, the execution happens successfully.

JDBC used - sun.jdbc.odbc.JdbcOdbcDriver

ODBC driver - Oracle ODBC ver7.3

Database - Oracle8i

Front end SQL Net - SQL Net for Oracle 7.x

Please help ...

RanjithP

[936 byte] By [ranjithpaliyath] at [2007-9-26 1:15:31]