Hello. We have a client/server setup to run our application. Our Application runs on an HPUX Itanium server dedicated soley to run the application. And, we have a database specific only server where the we have our database running. The Application makes connections to the database server thru sqlnet tnsnamse.ora listener.ora configuration.
As of last Friday Oracle release 10.2.0.2 software running on the aforementioned Application and Database servers. Then I upgraded software on both servers to Oracle 10.2.0.3 on both the Application server and the Database server. The noted Oracle Database was upgraded to Oracle release 10.2.0.3 as well.
When performing a task such as taking an order with our Application we received the following error message:
ORA-24813: cannot send or receive an unsupported LOB
Then, when the user tried again they are able to complete the task without getting the aforementioned message. We've seen this pattern happen twice now. Error occurs and the user tried again the the error seems to stop occuring. It seems the error stop occurring for the individual user once it occurs the first time.
Looking up information and the description on the ORA-24813 message indicates that an Oracle version mismatch between the Application and Database server may be the reason for this message occurring. But, we're sure that we're running Oracle 10.2.0.3 on the Application Unix server and Oracle 10.2.0.3 on the database as I upgraded the software on both of these servers to Oracle 10.2.0.3 software plus the database to Oracle 10.2.0.3.
I'm trying to determine if this error message indicates an issue is present or if the current pattern that we're seeing whereby the message occurs once for a user and not again indicates some sort of caching memory issue whereby the User's App is still pointing to Oracle 10.2.0.2 software etc then it gets cleared and the error message no longer occurs. Thanks for your help. Any questions please let us know.