Heb je vragen of opmerkingen? Aarzel niet om contact op te nemen. Dat kan via de algemene contactgegevens, rechtstreeks met de genoemde contactpersoon op een van de detailpagina’s, of via onderstaande knop.
OutSystems Advanced Queries
Use of comments (author: Marcel Lambrechts)
I was creating an advanced query (see post OutSystems – Getting Database Information) for the DBCleaner application to display table space usage. When I executed the query in OutSystems Service Studio using the “Test” button, it gave a (the expected) result, so publish the application and go! Publishing the application went fine, but when I went to the page with the result of my query, it showed me an “Internal Error”.
Looking in ServiceCenter at the error, it told me that the error was ORA-00907: missing right parenthesis. Very strange to get an error on the syntax of the query, while testing the query in Service Studio worked like a charm.
Invalid commenting
After some puzzling it turned out that this error was due to some lines in the query I removed by commenting them using “–“. When I removed them the error disappeared. I started testing this with some other queries (a lot simpler) and whenever I use the “–” to comment something, Service Studio will gladly accept and run the query, but the platform will return with an internal error.
It turns out that the only acceptable way to add a comment in a query, for the OutSystems platform at least, is to use /* …. */.
So for example, the next query (using the — comment syntax) will result in an internal error:
SELECT name, — espace_id, physical_table_name, is_active FROM ossys_entity;
And this query (using the /* */ comment syntax) will run fine:
SELECT name, /* espace_id, */ physical_table_name, is_active FROM ossys_entity;
Cause of the problem
The problem is caused by the fact that the OutSystems platform removes all Carriage Returns from the advanced querty, so the query with the “–” comment that I have listed above, will be translated by the runtime OutSystems platform to:
SELECT name, — espace_id, physical_table_name, is active FROM ossys_entity;
This way Oracle (and other database systems) will see everything after “–” as comment, thus including all other columns and the FROM clause.
Recente berichten
arrow_outward
APEX World 2026 – ’n impressie
arrow_outward
AI en het vak van software development
arrow_outward
Wanneer is Oracle APEX de juiste keuze voor softwareontwikkeling?
arrow_outward
AI en (Oracle) SQL: kan een AI echt goede queries schrijven?
arrow_outward
Java & AI-assisted software development
Contact
31 maart 2026
APEX World 2026 – ’n impressie
inSystems was op de “Sweet 16″ editie van APEX World als sponsor vertegenwoordigd middels verschillende banners en met 5 deelnemers. Tezamen hebben zij veel interessante keynote sessies en parallelsessies bijgewoond.
2 april 2026
30 jaar inSystems in vogelvlucht
inSystems viert haar 30-jarig bestaan. Wat ooit begon als Quobell B.V., opgericht in 1996 door vijf ervaren IT-professionals met Oracle als gemeenschappelijke factor, is uitgegroeid tot een stabiele en herkenbare speler in de Nederlandse IT-markt.
Opdrachten uitgevoerd voor
