executing stored procs

[myt]

[Mr. Arnold]

Re: executing stored procs


"myt" <mythili.mythil i@gmail.comwrot e in message
news:1180467989 .662525.223720@ o5g2000hsb.goog legroups.com...

I' m trying to call a stored proc in vb.net.I get this exception
Oracle.DataAcce ss.Client.Oracl eException ORA-06550:

>line 1, column 7:PLS-00306: wrong number or types of arguments
>in call to 'SPSETPERSONIDE NTIFIER1'ORA-06550: line 1,
>column 7:PL/SQL: Statement ignored
>at dhss.vitals.web .data.VitalsBir th.Component
>184 at VitalsBirth.Rec ord1.bSave_Clic k(Object sender, EventArgs e) in
>C:\sandbox\MOE VR\Source\Vital sBirth\App\Reco rd1.aspx.vb:lin e 217

>

<snipped>

And why you would post the code is a mystery. You need to debug it yourself.

Anyway, the message means exactly what it is saying. Either you're passing
too many, too few of a number of arguments or an argument being passed in
string when it should have been (int) to the stored (proc).

Sometimes you can set a brake point on the Catch and go to the InnerText
messages of the Exception and the messages might tell you exactly what is
wrong.

[diAb0Lo]

Re: executing stored procs

On 29 mayo, 21:47, "Mr. Arnold" <MR. Arn...@Arnold.c omwrote:

"myt" <mythili.myth.. .@gmail.comwrot e in message
>
news:1180467989 .662525.223720@ o5g2000hsb.goog legroups.com...
>

I' m trying to call a stored proc in vb.net.I get this exception
Oracle.DataAcce ss.Client.Oracl eException ORA-06550:

line 1, column 7:PLS-00306: wrong number or types of arguments
in call to 'SPSETPERSONIDE NTIFIER1'ORA-06550: line 1,
column 7:PL/SQL: Statement ignored
at dhss.vitals.web .data.VitalsBir th.Component
184 at VitalsBirth.Rec ord1.bSave_Clic k(Object sender, EventArgs e) in
C:\sandbox\MOEV R\Source\Vitals Birth\App\Recor d1.aspx.vb:line 217

>
<snipped>
>
And why you would post the code is a mystery. You need to debug it yourself.
>
Anyway, the message means exactly what it is saying. Either you're passing
too many, too few of a number of arguments or an argument being passed in
string when it should have been (int) to the stored (proc).
>
Sometimes you can set a brake point on the Catch and go to the InnerText
messages of the Exception and the messages might tell you exactly what is
wrong.

Hi there,

Seeing the error, it says that you are sending more o less parameters
than it needs. Also, you could be sending to SP exactly the parameters
that it needs, but in wrong data type.

Cheers,