Why am I getting the Data Explorer error "Multiple SQL statements are not allowed, please only use one SQL statement" in the Panther Console?
When running a query in the Data Explorer, I get an error saying:
268002: 02c58eb6-0502-a2a2-0034-12830691fa2c: server ErrorCode=000008, ErrorMessage=Multiple SQL statements are not allowed, please only use one SQL statement.
To resolve this issue:
Make sure your SQL query only contains 1 statement. For example the following is 2 statements and would not work:
set a = 1; select * from xyz where field = $a;
Whereas the below is only one statement and does work:
select * from xyz where field = 1;
This error occurs because Panther explicitly denies multiple statements in the Data Explorer. Each query should only contain 1 statement.