mgoricki / apex-plugin-code-editor Goto Github PK

Fullscreen mode in modal dialog resizes modal window.

It would be awesome adding a button for validating SQL queries, you could do it like this:

declare
l_i_cursor_id INTEGER;
begin
l_i_cursor_id:=dbms_sql.open_cursor;
dbms_sql.parse(l_i_cursor_id, REGEXP_REPLACE(:P25_SQL_QUERY, ':\w+', 'null'), dbms_sql.native);
dbms_sql.close_cursor(l_i_cursor_id);
:P25_ERROR_MESSAGE := 'OK';
return true;
exception
when others then
:P25_ERROR_MESSAGE := DBMS_UTILITY.FORMAT_ERROR_STACK || '
';
return false;
end;

Similar to the image, adding a validate button into the toolbar

There is a standard APEX problem with 32K limit... if You try to load >32K of text into item an error occurs.
But this can be overridden using additional plug-in for loading CLOBs into any item, for example

https://apex.world/ords/f?p=100:710:6351170637182::::P710_PLG_ID:APEX.CLOB.LOAD.2

Hi, firstly, congratulations and many thanks for releasing this great plugin.
Installed the last version (21.2) but for the life of me can't figure out how to create a list of command for the autocomplete functionality.
It looks perfect for what I ma trying to do. Wouldn't it be easier to have something like the FOS snippet plugin ? (it does not work unfortunately with Code Editor)