OracleCommandBuilder.DeriveParameters doesn’t return Stored Procedure definition

We were in a situation to migrate the Oracle database from one data center to another data center. The migration activities are completed and felt it is succeeded.

We observed the existing functionality which uses OracleCommandBuilder.DeriveParameters method is not return any parameter information of the Stored Procedure we are looking for. Hence tried with multiple functionality. No luck and spend a day on this as well.

Felt like some privileges issue and contacted the DBA teams as well. Later found that the Oracle packages were in INVALID state due to migration. So, Compiled the packages and the status becomes VALID.

There you go, the functionality started working.

In this case, the packages were not in a compiled (valid) state. Once we execute the Oracle package, everything went fine.

This is one possible solution if you are facing the similar issue.

Good luck..!!

Gangadhar Kotu

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: