Skip to main content
Panther Knowledge Base

Why am I getting the Data Explorer error "Multiple SQL statements are not allowed, please only use one SQL statement" in the Panther Console?

  1. Last updated
  2. Save as PDF

Issue

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.

Resolution

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;

Cause

This error occurs because Panther explicitly denies multiple statements in the Data Explorer. Each query should only contain 1 statement.