none
Run-time error '5': Invalid Procedure call or argument

    Question

  • I am new in VB and currently I am facing problem while trying to save data from vb frontend in oracle backend server.

    Actually we have a system for doctors in dispensary and when they try to access records for the patients from doctors module they able to do it but when they try to modify records and save it gives an error "Run-time error '5': Invalid Procedure call or argument" We are using oracle 8i as database and vb6 as fronend.

    Please help me to solve this issue........

    Wednesday, June 02, 2010 8:58 AM

Answers

All replies

  • You might have to provide more details (portion of the source code that is causing this error).

    Is it possible for you to debug and see where exactly this is failing?

    Wednesday, June 02, 2010 9:05 AM
  • Could you post the code where the error occurs (sounds like a VB 6.0 error message)?
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Wednesday, June 02, 2010 4:30 PM
  • I am just amazed at the number of Classic VB posts there are here!  Holy cow, Paul, you could've help me help divert these folks long ago.  Do they all get Cor's abuse for posting here?  This is kinda sad, how Microsoft has caused this much confusion in the community.  I mean, I knew it was over on "my side" but I didn't realize it had been "transitioned" over here too.  :-(
    .NET: It's About Trust!
    http://vfred.mvps.org

    Thursday, June 03, 2010 1:16 AM
  • I am new in VB and currently I am facing problem while trying to save data from vb frontend in oracle backend server.

    Actually we have a system for doctors in dispensary and when they try to access records for the patients from doctors module they able to do it but when they try to modify records and save it gives an error "Run-time error '5': Invalid Procedure call or argument" We are using oracle 8i as database and vb6 as fronend.

    Please help me to solve this issue........

    Hi Vijay Vadher,

     

    Please try this forum for VB6 questions.>>

    http://www.programmersheaven.com/mb/VBasic/Board.aspx

     

    See this support thread if you wish.>>

    http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b

    and.>>

    http://msdn.microsoft.com/en-us/vbasic/ms788229.aspx

     

    This forum is not for VB6 questions, it is for VB.Net questions, sorry, despite what other forum members may say.

     

    Regards,

    John

    Thursday, June 03, 2010 2:03 AM
  • I am just amazed at the number of Classic VB posts there are here!  Holy cow, Paul, you could've help me help divert these folks long ago.  Do they all get Cor's abuse for posting here?  This is kinda sad, how Microsoft has caused this much confusion in the community.  I mean, I knew it was over on "my side" but I didn't realize it had been "transitioned" over here too.  :-(
    .NET: It's About Trust!
    http://vfred.mvps.org

    Hi Karl,

    Is there any need for that comment?  Please keep any bad comments and thoughts to yourself.

     

    Regards,

    John

    Thursday, June 03, 2010 2:08 AM
  • Well, when the name of the group or forum is "Visual Basic" there's bound to be confusion. There are still Classic VB developers, who post here, that don't really know it's a .NET forum unless they read the "stickified" posts on the first page, and they're not that obvious.

    So we still get Classic VB, VBA and VBScript questions here. There is a dedicated forum for VBA:

    http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

    ...and now new Microsoft Office Developer forums:

    http://social.msdn.microsoft.com/Forums/en-US/category/officedev

    ...but no Classic VB. :-(


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, June 03, 2010 2:15 AM
  • ...but no Classic VB. :-(


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Hi Paul,

    While I will probably never have a 10th of the money Bill Gates, Steve Ballmer, Steve Jobs,

     Larry Page, Sergey Brin, Jerry Yang and David Filo have individually, if I was the webmaster

    at Microsoft, I would give your all a CLASSIC or VB6 forum here on MSDN.    ;-)    :-D

     

    That's never going to happen for me though, despite my fledgling university education. :-(

    I say "fledging" as the next level up from my HND is a degree level course.

     

    Regards,

    John

    P.S: It isn't often you see those names all together in one post either.

    Thursday, June 03, 2010 2:24 AM
  • Paul,

    You are informed that Arjun and me together with Microsoft are busy with the by you described problem.

    Please try to avoid that this forum becomes something like the VB discussion newsgroup.

    Visual Basic 6 is not a supported program language anymore.

    The VB 6 runtime is and for that has Microsoft done many efforts beside the stuppid mistake to place a wrong link in a newsgroup.

    You know very well that something in a newsgroup is not possible to undo anymore.

     http://msdn.microsoft.com/en-us/vbasic/ms788229.aspx

    For those who don't know what a runtime is, that was needed in the previous milenium to let a program language go.

    Now there is for Net one runtime, which is incorporated in the .Net Framework.

    In past you needed for every program language (beside if it was done in Intel Assembler) and even for every version a seperated runtime.

     

     


    Success
    Cor
    Thursday, June 03, 2010 7:07 AM
  •  

    Thanks Cor for the info, but you are not telling me anything I don't already know. As a fellow MVP I would appreciate it if you wouldn't do it again. ;-)


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, June 03, 2010 1:38 PM
  • Is there any need for that comment?  Please keep any bad comments and thoughts to yourself.

    I'd say Bite Me!, but you'd probably take that wrong, too.

    "Bad" is a highly subjective and therefore entirely meaningless characterization of an accurate description of reality.

    John, grow the heck up.  (Said with care and concern, I assure you.) 


    .NET: It's About Trust!
    http://vfred.mvps.org

    Thursday, June 03, 2010 5:39 PM
  • Well, when the name of the group or forum is "Visual Basic" there's bound to be confusion. There are still Classic VB developers, who post here, that don't really know it's a .NET forum unless they read the "stickified" posts on the first page, and they're not that obvious.

    So we still get Classic VB, VBA and VBScript questions here. There is a dedicated forum for VBA:

    http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

    ...and now new Microsoft Office Developer forums:

    http://social.msdn.microsoft.com/Forums/en-US/category/officedev

    ...but no Classic VB. :-(

    What a shame.  On all counts.  :-(

    And I see that the great majority of the Classic VB posts just linger unresponded too.  (Admittedly a random and rather small sample, due to the horridly inefficient web mechanism that stands in the way of information exchange.)


    .NET: It's About Trust!
    http://vfred.mvps.org

    Thursday, June 03, 2010 5:42 PM
  • John, are you using one of those flakey "nntp bridge" things?  I'm asking, because the formatting on your posts is just horrific, and I can't imagine a human garbling things up that bad.

    Just curious...


    .NET: It's About Trust!
    http://vfred.mvps.org

    Thursday, June 03, 2010 5:43 PM
  • Thanks Cor for the info, but you are not telling me anything I don't already know.
    Impressive! (But I guess that would be just as true if one were to interpret it to mean that he's not actually telling you anything, given that post was an entirely incoherent string of random brain droppings? <g>)
    As a fellow MVP I would appreciate it if you wouldn't do it again. ;-)

    Oh, I just love the little "code" games that go on here. <snicker>


    .NET: It's About Trust!
    http://vfred.mvps.org

    Thursday, June 03, 2010 5:46 PM
  • Is there any need for that comment?  Please keep any bad comments and thoughts to yourself.

    I'd say Bite Me!, but you'd probably take that wrong, too.

    "Bad" is a highly subjective and therefore entirely meaningless characterization of an accurate description of reality.

    John, grow the heck up.  (Said with care and concern, I assure you.) 

    Hi Karl,

    It looks like you and I are going to have to agree to disagree, if you wish to?

    I am not even going to reply to your comment in a nasty way either, as I do not wish to.

    I think your cause for a CLASSIC VB forum, here on MSDN will fall on deaf ears at Microsoft though.

     

    Regards,

    John

     

    Thursday, June 03, 2010 5:47 PM
  • It looks like you and I are going to have to agree to disagree, if you wish to?
    Happy to disagree with you, John!
    I am not even going to reply to your comment in a nasty way either, as I do not wish to.
    Oops, too late.
    I think your cause for a CLASSIC VB forum, here on MSDN will fall on deaf ears at Microsoft though.
    You think?  Do tell!
    .NET: It's About Trust!
    http://vfred.mvps.org

    Thursday, June 03, 2010 5:51 PM
  •  

    Thanks Cor for the info, but you are not telling me anything I don't already know. As a fellow MVP I would appreciate it if you wouldn't do it again. ;-)


    Paul ~~~~ Microsoft MVP (Visual Basic)


    Paul,

    Now you see what an important place you have in my brain.

    It is probably another Paul.

    When somebody writes Paul then it is you.

    My very true meant apologies.

    Cor

    Thursday, June 03, 2010 6:45 PM
  • Hi again Karl,

    I was just trying to keep a senses of calm in this forum, that was all.

    With the comment you made, it seems to me, that you have something against Cor Ligthert?

     

    Regards,

    John

    Thursday, June 03, 2010 10:26 PM
  • I was just trying to keep a senses of calm in this forum, that was all.

    With the comment you made, it seems to me, that you have something against Cor Ligthert?
    Aside from his incessent need to disrupt the ClassicVB newsgroups over the last three years or so, no, nothing personal at all.  Dude does owe a community or two some profound apologies, though.

    .NET: It's About Trust!
    http://vfred.mvps.org

    Friday, June 04, 2010 1:44 AM
  • John, are you using one of those flakey "nntp bridge" things?  I'm asking, because the formatting on your posts is just horrific, and I can't imagine a human garbling things up that bad.

    Just curious...

    Hi Karl,

    Well maybe I'm a mixed up kid. LOL!!

    You'll have to get used to my style of posts, sorry.

    You are the 2nd person in the years of my being on Microsoft forums to say anything about my posts.

    These forums have seen one or two url changes and at least two or three forum updates or changes while I've been a member. The earliest thread I could find where I've added a reply was this one though.>>

    http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/f0bf8c04-8412-4788-b44a-a86af1ec3b6b

    back on April 18th, 2007. I'm sure I was on the old forums from about 2005 though, before the forums were migrated.

     

    Regards,

    John

    Friday, June 04, 2010 2:53 AM
  • You'll have to get used to my style of posts, sorry. You are the 2nd person in the years of my being on Microsoft forums to say anything about my posts.
    Normally, I wouldn't care at all. (They just seem to have random line breaks in them.) But folks have been telling me I oughta try the new NNTP bridge gizmos, so I was wondering if those anomalies were caused that way or somehow else. I see that you are capable of posting without random line breaks, so now I do wonder what causes them with such frequency. Oh well, at least it's not the tool that others are recommending...

    .NET: It's About Trust!
    http://vfred.mvps.org

    Monday, June 07, 2010 7:47 PM