Microsoft KB Archive/190593

= BUG: ORACLE Procedures with Lower Case Names Are Not Executed =

Article ID: 190593

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q190593



SYMPTOMS
With an ORACLE data connection if you have a procedure whose name is in lowercase letters, on execution you will be told that the procedure "is not a procedure or is undefined."



CAUSE
Before the procedure is executed, there is a check made to see if the procedure exists. This check is done against uppercase names.



RESOLUTION
Change the name of the procedure to uppercase letters or add a dummy procedure whose name is the uppercase equivalent. This dummy procedure will get past the existence check and the correct procedure will be run.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to Reproduce Behavior

 * 1) Create and ORACLE data connection.
 * 2) Add a procedure named "a".
 * 3) Execute "a".

You'll see an error stating that "a" does not exist.

Keywords: kbbug kboracle kb3rdparty kbpending KB190593

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.