Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stupid C0000005 Error calling a stored procedure
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Stupid C0000005 Error calling a stored procedure
Miscellaneous
Thread ID:
00411029
Message ID:
00411029
Views:
41
This has been working fine until a couple of hours ago. I know there was a bit of a thread on this in the last week or so and went back to read it but never saw a real solution. If I missed it please just point me in the right direction. Otherwise, any help would be great because I am dead in the water right now.

I am basically calling an Oracle stored procedure to validate a login/password and return a validity code. The call looks like this:
ResultCode=SQLEXEC(oUserInfo.ConnHandle, ;
        "{CALL pCheckLogin (?lcLogin, ?lcPassword, ?@lcUserName, ?@lcSource, ?@lcAccessLevel, ;
               ?@liRetVal)}")
For some reason as soon as it hits this line I get the C...5 error. If I copy this code and put it into a temp file and run the same thing, everything works fine. All of the parameters being passed are correct and this is a valid connection handle.

I can't find much of anything in TechNet or any other MS resources. Any ideas?

Thanks,
George
Everything we see or seems
Is but a dream within a dream
- Edgar Allen Poe
Next
Reply
Map
View

Click here to load this message in the networking platform