Comments by Derek Elliott (Top 4 by date)

Did you get an answer to this? I have the same issue using 'Insert Parameters' to call a Stored procedure.

Oops.. the SQLDATASOURCE statement does have a closing and

Hi, I'm new to this... just need some help with calling a Stored procedure with parameters..

Here is my .net code:
<asp:sqldatasource id="dbAddEvent" runat="server" connectionstring="<%$ ConnectionStrings:PsychHistConnectionString %>"
="" providername="<%$ ConnectionStrings:PsychHistConnectionString.ProviderName %>" selectcommand="select nhi, surname from mhh_patient where 1 = 2" insertcommand="INSERT_EVENT" insertcommandtype="StoredProcedure">
<insertparameters>
<asp:controlparameter name="nhi" controlid="fvAddEvent$tbNHI" propertyname="Text" defaultvalue="" convertemptystringtonull="true" type="String">
<asp:controlparameter name="surname" controlid="fvAddEvent$tbSurname" propertyname="Text" defaultvalue="" convertemptystringtonull="true" type="String">



This is the start of my stored procedure:
create or replace procedure INSERT_EVENT
(nhi in mhh_patient.nhi%type,
surname in mhh_patient.surname%type)

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

Any ideas anyone?