BUG: Oracle Code Might Appear Incorrectly

ID: Q191043


The information in this article applies to:


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:


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; 

Additional query words:


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

Last Reviewed: May 25, 1999