Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
DotNet
acad.assignment.mngr
academic
adonet
aspnet
aspnet.announcements
aspnet.build.controls
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
clr
compactframework
component_services
datatools
distributed_apps
drawing
faqs
framework
framework.wmi
general
internationalization
interop
languages.csharp
languages.jscript
languages.vb
languages.vb.controls
languages.vb.data
languages.vb.upgrade
languages.vc
languages.vc.libraries
myservices
odbcnet
performance
remoting
scripting
sdk
security
setup
vjsharp
vsa
webservi.enhancements
webservices
windowsforms
windowsforms.controls
winforms.databinding
winforms.designtime
xml
  
 
date: Mon, 16 Jan 2006 15:08:15 -0500,    group: microsoft.public.dotnet.datatools        back       


Enterprise Data Acces Block with Oracle and Stored Procedures   
Hi all,

Does anybody have an example or know where I can find one that shows the use 
of .NET Enterprise Data Acces Block with Oracle and Stored Procedures.  I am 
trying to  fill a dataset, but I cannot do it.

The SP is:

PROCEDURE GetCustomerList(cursor OUT endaab.refcur) IS
  BEGIN
    OPEN cursor FOR
    SELECT *
    FROM
           "CUSTOMERS";
  END GetCustomerList;

And the function call is:
                        //Create database instance
                        Database db = 
DatabaseFactory.CreateDatabase(instanceName);
                        //Initialize the stored procedure
                        DBCommandWrapper dbCommandWrapper = 
db.GetStoredProcCommandWrapper("endaab.GetCustomerList");
                        //Generate DataSet object
                        DataSet ds = null;
                        ds = db.ExecuteDataSet(dbCommandWrapper);
                        //Fill datagrid
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                              //Supposing we have a datagrid whose id is 
DataGrid1
                              DataGrid1.DataSource = 
ds.Tables[0].DefaultView;
                              DataGrid1.DataBind();
                        }
                        else
                              Response.Write("No rows were selected");

But....the following error is arising:

System.Data.OracleClient.OracleException: ORA-06550: line 1, column 7: 
PLS-00306: wrong number or types of arguments in call to 'GETCUSTOMERLIST' 
ORA-06550: line 1, column 7: PL/SQL: Statement ignored at 
System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle 
errorHandle, Int32 rc) at System.Data.OracleClient

Could you please help me with this issue?

Thank you very much in advance,

Marco
date: Mon, 16 Jan 2006 15:08:15 -0500   author:   Marco

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us