When creating a custom checkpoint / query with the oracle probe its giving a connection error / failed even though the connection works properly when executed from the connection tab.
- the use of ; at the end of the query is causing the issue.
- without ; the query is working fine
Looks like the use of ; after the query was causing the issue. Without ; query is working fine
Example:
When Clicking "TEST" for:
select file_name,file_id from dba_data_files;
--> Query test connection failed
When Clicking "TEST" for:
select file_name,file_id from dba_data_files
--> Query connection succeeded