DDL execution problem
Posted: 30.03.2021, 15:46
Have fresh ZEOS, just updated from SVN R7413, but same problem appeared with my previous archive valid for several months.
Trying to execute DDL statement:
create or alter procedure VERIFY_ADMIN2 (
... some input declarations ...)
returns (
... some output declarations ...)
as
declare variable ... several variables here
begin
...
end
Got error message with TQuery.ExecSQL:
SQL Error: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 417; Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Query.Params reports all the variables declared in "as ... begin" !!!
Temporary solution found is setting ParamCheck to False
Trying to execute DDL statement:
create or alter procedure VERIFY_ADMIN2 (
... some input declarations ...)
returns (
... some output declarations ...)
as
declare variable ... several variables here
begin
...
end
Got error message with TQuery.ExecSQL:
SQL Error: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 417; Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Query.Params reports all the variables declared in "as ... begin" !!!
Temporary solution found is setting ParamCheck to False