Microsoft KB Archive/191043

= BUG: Oracle Code Might Appear Incorrectly =

Article ID: 191043

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q191043



SYMPTOMS
Oracle stored procedures, functions, and trigger source code might appear without line breaks or might appear incorrectly justified in the Source view editor. This is a visual problem only. This problem should not affect the functionality of the code object.



RESOLUTION
To avoid this problem, do one of the following:
 * Use different editing techniques.
 * Copy and paste from a different text editor.



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
 Add a database connection to an Oracle data source.  Create a new stored procedure, select all of the contents, and paste the following single line of source code: CREATE OR REPLACE PROCEDURE PROCEDURE2 (A DEC, B DEC, C DEC) AS BEGIN RETURN; END;   Hit the enter key to insert line breaks. Edit the stored procedure to look as follows: CREATE OR REPLACE PROCEDURE PROCEDURE2 (A DEC, B DEC, C DEC) AS BEGIN RETURN; END;  Save, close, and reopen the stored procedure.  Click to the left of the open parenthesis, and press enter so that the code appears as follows: CREATE OR REPLACE PROCEDURE PROCEDURE2 (A DEC, B DEC, C DEC) AS BEGIN RETURN; END;   Click to the left of A, and press enter. Repeat for B, C, and the closing parenthesis as follows: CREATE OR REPLACE PROCEDURE PROCEDURE2 (     A DEC,      B DEC,      C DEC      ) AS BEGIN RETURN; END; </li> Save, close, and reopen the stored procedure.</li></ol>

RESULT: Parameters appear back on the first line as follows: CREATE OR REPLACE PROCEDURE PROCEDURE2 ( A DEC,  B DEC,  C DEC ) AS BEGIN RETURN; END; EXPECTED RESULT: Source should be consistent with what was saved as follows: CREATE OR REPLACE PROCEDURE PROCEDURE2 (  A DEC,   B DEC,   C DEC   ) AS BEGIN RETURN; END;

Keywords: kbbug kboracle kb3rdparty kbpending KB191043

-

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

© Microsoft Corporation. All rights reserved.