The embedded SQL functions in confluence page works correctly. However, when we try to access the SQL-query Macro from attachment on the same page, it throws up error.
Below is the SQL function :-
SELECT 'HELLO' AS fld_text, 1 AS fld_num FROM dual
It works when SQL embedded in the page.
SQL-query macros that access identical SQL from attachments also calls for the same function.. The embedded SQL functions works correctly. The SQL-query marco from the attachments fails.
Below is the error message :-
Error rendering macro 'sql-query' : java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
Sql file is also attached here. Thanks.