Ora-06550 - Pls-00306
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Ora-06550 - Pls-00306

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    72

    Unhappy 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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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 01:25 PM.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  4. #4
    Join Date
    Mar 2004
    Location
    India
    Posts
    72
    The same program runs well in another Pc.

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

    -Sathy

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Has nothing to do with client. You have type conversion issues.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width