-
Ora-06550 - Pls-00306
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
-
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
-
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.
Last edited by kris109; 03-07-2004 at 02:25 PM.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
The same program runs well in another Pc.
Is there any seting in Oracle Client (Ver: 8.1.7) ?.
-Sathy
-
Has nothing to do with client. You have type conversion issues.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|