ORA-00902: invalid datatype
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.
Thanks a bunch in advance
Possible solution to ORA-00902 Invalid Datatype
We have had the same problem with object types.
Our solution:
Make sure that the data types match the table you are using, especially if your data type is referencing other data types.
Make sure that the declaration of the data types are the same across the board i.e. Java as well as the Oracle datatypes, procedures and tables.
This solved our problem.
Hope this helps.