SQL Macro does not work - Error ORA-00911

Description

Hi

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

versions :-

Confluence 4.3.1
Bobswift 5.0

Sql file is also attached here. Thanks.

Environment

Production

Assignee

Bob Swift (Bob Swift Atlassian Apps)

Reporter

Kiran Panduga (Appfire)

Labels

None

Support Entitlement

None

Fix versions

Priority

Critical
Configure