Error Encountered: Specified cast is not valid.

[damann]

Hello Guys,

I'm getting this error whenever I try to call an oracle storeprocedure like this in a .NET (C#) app.

oracleConnection = (OracleConnection) ESDataAccessProvider.GetConnection("OracleDBConnString");
getDataOracleCommand = (OracleCommand) DAP.ConstructCommand("OracleDBConnString","Package.StoredProcedure");
getDataOracleCommand.Connection = oracleConnection;
OracleDataAdapter objDataAdapter = null;
objDataAdapter = new OracleDataAdapter();
objDataAdapter.SelectCommand = (OracleCommand) getDataOracleCommand;
objDataAdapter.Fill(MgrOrgDS);

Any idead why I get the "Error Encountered: Specified cast is not valid." error? Please let me know...


Thanks,
Damann

 

[Wholsea]

Which line do you get the cast error on?

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[damann]

The error happens at this line:

getDataOracleCommand = (OracleCommand) DAP.ConstructCommand



Here is the original code again:
oracleConnection = (OracleConnection) DAP.GetConnection("OracleDBConnString");
getDataOracleCommand = (OracleCommand) DAP.ConstructCommand("OracleDBConnString","Package.StoredProcedure");
getDataOracleCommand.Connection = oracleConnection;
OracleDataAdapter objDataAdapter = null;
objDataAdapter = new OracleDataAdapter();
objDataAdapter.SelectCommand = (OracleCommand) getDataOracleCommand;
objDataAdapter.Fill(MgrOrgDS);

 

[damann]

I've figured out the problem guys, this post can go away now! Thanks!


Damann