Ora-06550 - Pls-00306

[Sathy]

HAI,

CAN ANY ONE SOLVE MY PROBLEM??

Problem Is:

When I call a procedure through VB Code, It got an error like
------------------------------------------------
Run Time error: -2147217900(80040e14)

ORA-06550 Line 1, Coloumn 7
PLS-00306 Worng number or types of arguments in call to <>
ORA-06550 Line 1, Coloumn 7
PL/SQL : Statement Ignored.

------------------------------------------------

But When I call the same with another PC, It is activated...

Thanks in Advance.
Sathy

[davey23uk]

when you call the procedure, it is expecting a certain number of arguments to be passed to it, you are not passign either the correct arguments or you are supplying the wrong number of arguments.

The other procedure maybe doesnt need any.

To see what you need to supply connect to sql*plus and do
desc and look for the IN parameters

[kris109]

Sometimes it is useful to pass parameters by name using => notation.

Then you are sure of the value you are passing - irrespecive of whether you are calling the procedure from VB or from sql*plus session on another PC.

[Sathy]

The same program runs well in another Pc.

Is there any seting in Oracle Client (Ver: 8.1.7) ?.

-Sathy

[marist89]

Has nothing to do with client. You have type conversion issues.