Start a new topic

Delimiter choice for @delimiter command

 Hej

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>)'

image


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

Login or Signup to post a comment