Re: Ado and Oracle 9i connection

hai dieg0!
i was also faced the same problem..
the problem was solved by explicity declaring the variables which will handle the procedure or function call..
just try this way..

dpafumi_at_yahoo.com (Diego) wrote in message news:<5b2b7013.0110240831.b6f9e51_at_posting.google.com>...
> HI
>
> I'm having the following problem.
> We use Oracle8i over NT, Visual Basic and the developers connect to
> Oracle using ADO.
> I installed Oracle 9i and for and unknown reason now they receive
> error messages when they try to run a stored procedure, function, etc.
> It fails when doing a Command.Parameters.Refresh() when the Command
> object is pointed to a stored procedure.
>
> The message is:
>
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to
> 'P_IU_INAPPROPRIATEWORD'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> But we are calling the procedure in the correct way!!
>
> You can see a similar problem in
> http://groups.google.com/groups?selm=erIo7.685%24g13.704883%40typhoon.snet.net&output=gplain
>
> Any clue? This is REALLY CRITICAL.
>
> Thanks
>
> Diego
Received on Thu Nov 01 2001 - 09:26:40 CET