I just tried to use my existing code templates with the new editor for the first time and found that instead of getting single quotes, I am getting ‘#39’, which obviously isn’t correct. I am also getting line breaks in the middle of the code incorrectly. In looking at the options, the incorrect characters are there as well.
In looking at other templates, it appears that any that use quotes are in there incorrectly. The assertloc template, which I am pretty sure is one packaged with TOAD is an example of the quote problem.
My template now looks like this (note the is broken up as is the getCreateIndexParams line – also note that on lines 1, 5, 6, and 7, the second ‘#3 is missing the 9’ ):
ddl.createIndex(in_owner => ‘#39’siebel’#3
, in_index_name => getNextIndexName(’#39’<pas’
te>’#39’, ‘#39’siebel’#39’, ‘#39’C’#39’)
, in_table_name => ‘#39’’#3
, in_unique => ‘#39’N’#3
, in_columns => '#39#3
, in_params => miscExpImpProcs.getCre’
ateIndexParams( ‘#39’siebel.’#39’, TRUE)
, in_make_bitmap => ‘#39’N’#39’);
when it should look like this:
ddl.createIndex(in_owner => ‘siebel’
, in_index_name => getNextIndexName(’’, ‘siebel’, ‘C’)
, in_table_name => ‘’
, in_unique => ‘N’
, in_columns => ‘’
, in_params => miscExpImpProcs.getCreateIndexParams( ‘siebel.’, TRUE)
, in_make_bitmap => ‘N’);
–
Phyllis Helton
Data Magician
Digital Strategies, Cru | Data Sciences & Analytics
Office 407-515-4452