I keep getting ORA-06550, PLS-00306 "wrong number or types of arguments in call to 'ISSUE_INSERT_SP' error when trying to use the FormView control (in VS 2008) to do an insert by calling an Oracle stored procedure. I'm using Oracle.DataAccess.Client as my connection provider.
Here are the relevant pieces of my SqlDataSource configuration:
<asp:SqlDataSource ID="OracleDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNET_ORACLE %>"
InsertCommand="SEE_UMTRA.Issue_Insert_SP"
InsertCommandType="StoredProcedure"
ProviderName="<%$ ConnectionStrings:ASPNET_ORACLE.ProviderName %>"
<InsertParameters>
<asp:Parameter Name="aReturn" Direction="ReturnValue" Type="Int32" />
<asp:Parameter Name="aESTIMATE_HOURS" Direction="Input" Type="Decimal" />
<asp:Parameter Name="aTITLE" Direction="Input" Type="Char"/>
</InsertParameters>
</asp:SqlDataSource>
Here's my stored proc:
FUNCTION ISSUE_INSERT_SP (aESTIMATE_HOURS IN DECIMAL, aTITLE IN CHAR) RETURN INTEGER
AS ....
Here's my frustration: I can call this stored proc successfully from my c# code behind page, using the same schema.StoredProc name, connection string, paramater order and types. But obviously not using the FormView control. My understanding is your only 2 options for doing an insert from the FormView control is by using either an insert SQL statement or sp call? Which is tricky, since there is not much flexibility in mapping to Oracle data types (when defining the insert parameters "type"). Any suggestions for that problem? Any ideas on my PLS-00306 error when calling the sp from asp?
I'd like to use the FormView control, but this is obviously a show stopper.
Thanks very much for your help!
Edited by: user8921973 on Mar 29, 2011 11:44 AM
Edited by: user8921973 on Mar 29, 2011 11:45 AM