-
Oracle Stored Procedures
I use the MS .NET Oracle Data Provider (System.Data.OracleClient) for connecting to Oracle and selecting data from stored procedures just fine by setting the OracleCommand.CommandText to the procedure or package.procedure name and setting the OracleCommand.CommandType to be StoredProcedure.
Now I need to execute a procedure found in a package in another users schema, so when I set the OracleCommand.CommandText to be the owner.package.procedure name I get an Oracle error ORA-06550 package.procedure must be declared. I know I have access granted to execute the other shcema's procedure becasue I can use sqlplus to execute it (using the full owner.package.procedure naming). So it seems to me that maybe the MS OracleClient provider is stripping the owner from the given procedure name in the CommandText? Could this be? Is anyone else executing procedures in packages in other schemas and using the MS OracleClient in .NET? If so how are you doing it? Thanks.