Several Issues with standard/compound triggers in 7.3

SQL Navigator
1

Hi!

I see following issues, when working with the trigger editor:

  • if trigger properties is pinned and trigger text is greater then the editor text, navigating down with the mouse navigates outside of the editor

  • formatting of compound trigger does not work

  • auto code completion for :new and :old values does not work

Kind regards

Torsten

2

Hi Torsten,

Thanks for your feedback issue.

  1. did you stll get text issue?

  2. for formatting of compound trigger issue, could you provide a piciure cut to us?

  3. we have create defect ID SQLNAV-2177 for this, and we didn’t support this code completion

Michael

3

Hi Michael!

  1. Can not reproduce or remember how to reproduce in 7.3 (long time ago from creating this post [:(]).

  2. Use example from https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9526879900346669506 you see following output:

20170118_092846.png
20170118_092846.png1679×887 70.8 KB

  1. thank for creating this.

Kind regards

Torsten