Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MmPicker and Oracle sprocs
Message
De
08/02/2007 13:05:30
Alan Hoiland
Canadian Natural Resources Ltd.
Calgary, Alberta, Canada
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
MmPicker and Oracle sprocs
Divers
Thread ID:
01193734
Message ID:
01193734
Vues:
87
I am trying to use an Oracle sproc as the DataCommand for a mmPicker and this is the error I get:

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STAFF_MEMBERSSELECT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Here is the stack dump:

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at OakLeaf.MM.Main.Data.mmDataAccessOracle.FillDataSet(DataSet ds, IDbDataAdapter dbAdapter, String tableName, Boolean clearOnFill)
at OakLeaf.MM.Main.Data.mmDataAccessOracle.FillDataSet(DataSet ds, IDbCommand command, String tableName, Boolean clearOnFill)
at OakLeaf.MM.Main.Data.mmDataAccessOracle.FillDataSet(DataSet ds, String command, String tableName, CommandType cmdType, IDbDataParameter[] dataParms, Boolean clearOnFill)
at OakLeaf.MM.Main.Business.mmBusinessObject.FillDataSet(DataSet ds, String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, CommandType cmdType)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, CommandType cmdType)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, CommandType cmdType)
at OakLeaf.MM.Main.Business.mmPickListBusinessObject.GetPickList(String command, CommandType cmdType, IDbDataParameter[] parameters)
at OakLeaf.MM.Main.Windows.Forms.mmPickListSearch.HookGetPickListData(mmPickListParameters pickListParams)
at OakLeaf.MM.Main.Windows.Forms.mmPickListSearch.GetPickListData(mmPickListParameters pickListParams)
at OakLeaf.MM.Main.Windows.Forms.mmPickListSearch.PerformSearch(mmPickListParameters pickListParams)
at OakLeaf.MM.Main.Windows.Forms.mmPicker.PerformSearch()
at OakLeaf.MM.Main.Windows.Forms.mmPicker.btnPicker_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at TestPlanP.AppMainEntry.Main() in u:\data\Dev\TestPlanP112806\TestPlanP112806\Main.vb:line 37

Thanks!
Alan
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform