Automic Workload Automation

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

SQL Agent 24.4.0 and 24.4.1 terminates statement on @ when in quoted string

  • 1.  SQL Agent 24.4.0 and 24.4.1 terminates statement on @ when in quoted string

    Posted 10 hours ago

    Hello, 

    We've found that the SQL Oracle Agent 24.4.0 and above terminates the statement on the termination character when the character is quoted.  In versions 24.3 and earlier this worked.  I'm using Automic Engine V24.4.1.

    Here's an example for the Oracle code and I've attached two screenshots so you can see the difference between the two versions.  We have a few jobs that have email addresses passed into the statement.

    SQL_SET_STATEMENT_TERMINATOR TERM=@;
    BEGIN
       dbms_output.put_line('@');
    END;@

    I will a ticket with Tricise.  Thanks.



    -------------------------------------------