We see the error "ORA-00902: invalid datatype" in our Java applications calling a stored procedure with a user defined datatype. The Oracle version is 9.2 This error is very hard to reproduce, during this time, the stored procedure is still valid on the db, reloading it doesnt help. Restarting the application (recreating connections to the database fixes the problem) Also, the stored procedure only does DMLs (and one truncate table operation), other than that, there are no create tables etc in the stored procedure.
Have any of you experienced this before? Any suggesstion for a possible cause is great.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.