BUG: Oracle Code Might Appear Incorrectly

• Microsoft Visual InterDev, version 6.0

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.

MORE INFORMATION

Steps to Reproduce Behavior

1. Add a database connection to an Oracle data source.



2. 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; 




3. 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; 




4. Save, close, and reopen the stored procedure.



5. 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; 




6. 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; 




7. Save, close, and reopen the stored procedure.

   CREATE OR REPLACE PROCEDURE PROCEDURE2  ( A DEC,  B DEC,  C DEC )
   AS BEGIN RETURN; END; 

   CREATE OR REPLACE PROCEDURE PROCEDURE2
   (
   A DEC,
   B DEC,
   C DEC
   )
   AS BEGIN RETURN; END; 

Additional query words:

Keywords : kb3rdparty kbOracle kbVisID600 kbVisID600bug kbGrpASP
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbbug