Microsoft enterprise library and Oracle

  • Thread starter Thread starter ilyas
  • Start date Start date
I

ilyas

I have the following code

Database db=DatabaseFactory.CreateDatabase();
DBCommandWrapper dbCmd=db.GetStoredProcCommandWrapper("test1");
dbCmd.AddInParameter("modUsr", DbType.String, "QUINNJ");
dbCmd.AddOutParameter("CUR", DbType.Object, 2000);
DataSet result= db.ExecuteDataSet(dbCmd);
MessageBox.Show(result.GetXml());


However when this gets executed, the error " identifier 'TEST1' must be
declared" gets displayed?

What am I doing wrong here?

Tes1 is the name of a stored procedure....
 
My guess that your stored procedure has to be created inside an Oracle
package and you call it this way:
dbCmd=db.GetStoredProcCommandWrapper("package1.test1");
assuming your package name is package1

You can also have a stored procedure without a package but you have to grant
access to the user that is used in your DAAB configuration in order for this
user to be able to call the stored procedure.
 
Back
Top