SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[9.5.444 Pro] - Inserting procedures from popup in Oracle

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[9.5.444 Pro] - Inserting procedures from popup in Oracle
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [9.5.444 Pro] - Inserting procedures from popup in Oracle Reply with quote
Selecting a procedure from a popup after DROP PROCEDURE will not only insert the schema + procedure names but the procedure arguments as well, resulting in syntactically incorrect code, e.g.
Code:

DROP PROCEDURE "p_SaveVONAL"(
                   a_vonal_id => /*{ a_vonal_id }*/,
                   a_datum_tol => /*{ a_datum_tol }*/,
                   a_varos_id => /*{ a_varos_id }*/,
                   a_vonal_nev => /*{ a_vonal_nev }*/,
                   a_aktiv_e => /*{ a_aktiv_e }*/,
                   a_datum_ig => /*{ a_datum_ig }*/)


Also, the codes inserted when selecting objects from the popup do not conform to (modified) default code formatting style, like commas/operators not being stacked leading, spacing, wrapping, etc. Though I'm not sure if it is anywhere mentioned they should, it would be a nice touch.
Tue Dec 19, 2017 5:30 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Thank you very much for reporting this issue. I will log it to our internal bug tracking system.

As a workaround, please use Shift+Enter when selecting the procedure name. That will insert the procedure name only.
Tue Dec 19, 2017 10:26 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
I've tried Shift+Enter but it behaves no different from using Enter alone.
Tue Dec 19, 2017 10:42 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Both have been confirmed as bugs. A fix for this issue might be released before the end of the year along with some other minor fixes for 9.5 release.
Tue Dec 19, 2017 11:36 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.