How spatialware sp_spatial_query statements in pb?
I want to use in pb spatialware process of if statements to use
In SQL server can directly use the statement cannot be used in the pb, always said I couldn't find sp_spatial_query this variable, what should I do?

CodePudding user response:

Need to declare

String ls_parameter

Ls_parameter='select... '

DECLARE sp_spatial_query PROCEDURE FOR sp_spatial_query ls_parameter.

The EXECUTE sp_spatial_query;

CodePudding user response:

Note: the system stored procedure generally in the master database, please add database prefix,

CodePudding user response:

reasonable

CodePudding user response:

Also note that the identity of the owner, if the database is oracle, more carefully