Knowledge Base

BUG: Oracle Code Might Appear Incorrectly

Article ID: 191043

Article Last Modified on 3/2/2005


APPLIES TO


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.

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