I am having an intermittent problem with calling stored procedures using ProC on Oracle 9i. The return code from Oracle sometimes indicates that the data does not exist (i.e. err 100 or error 1403). To resolve this I can flush the Oracle shared pool and the correct data is returned.

When this problem occurs, I call the same stored procedure from pl/sql developer or sqlplus the correct data is returned.

This was not a problem on Oracle 8i. Anyone got any ideas?