I was puzzled to find that the delimiter command only supports a select choice of characters.
I run
-- change delimiter to Group Separator (ASCII 29)
-- It seems that it cannot be seen in this block, DbVis however displays a symbol for it
@delimiter ;
begin
DBMS_UTILITY.COMPILE_SCHEMA(schema => 'YBD', compile_all => FALSE, reuse_settings => TRUE);
end;
@delimiter ;
And it gives me the error 'Missing parameters (Syntax: @delimiter <new_delimiter>)'
I can work marking it as a SQL block with --/
Maybe you could add the choice available for delimiters in the documentation, though I am not sure where one needs to use the delimiter command instead of the block marker.
Thiemo Kellner
Hej
I was puzzled to find that the delimiter command only supports a select choice of characters.
I run
And it gives me the error 'Missing parameters (Syntax: @delimiter <new_delimiter>)'
I can work marking it as a SQL block with --/
Maybe you could add the choice available for delimiters in the documentation, though I am not sure where one needs to use the delimiter command instead of the block marker.
Ha det bra
Thiemo