Q
Problem solve Get help with specific problems with your technologies, process and projects.

Failed stored procedure through db link in Oracle

An Oracle user asks why a stored procedure through db link from Oracle 10g to 8i is failing.

We have upgraded one of our Oracle servers from version 8.1.7.4 to 10.2.0.3, but the other one is still 8.1.7.4. When I make a call to stored proc. through db link from 10g to 8i, it is failing, as it is not able to identify array types which is defined on 8i and are being passed as a parameter to procedure call. It is not recognizing array types defined on 8i.
This is one of the known problems with db links from Oracle 10g to Oracle 8i. Oracle Corp will probably not fix this issue since 8i is desupported for new issues. They will tell you to upgrade your 8i db to 10g and then things will work fine.

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close