Request for improvement: create a to_html_table function

[sda]

It would be very useful to have a to_html_table function available in invantive’s language.
example below

declare
      l_table varchar2;
begin
    select to_html_table
           (
              select col1, col2, col3
              from table@container
              where col1 = 'this'
            ) into l_table;
-- sending email
  insert into smtp@mail
    ( toEmail
    , ccEmail
    , bccEmail
    , subject
    , body
    , attachmentContents
    , attachmentName
    , attachmentMimeType
    )
    select 'destination_email@domain.com' -- add here your recipients separed by a [,]
           toEmail
    ,      cast(null as varchar2)
           ccEmail
    ,      cast(null as varchar2)
           bccEmail
    ,      'Invantive replication script'
           subject
    ,     l_table
           body
    ,      null -- rfe.file_contents
           attachmentContents
    ,      null -- basename('{USER_MULTI_PARTIES_FILE_NAME}')
           attachmentName
    ,      null -- cast(null as varchar2)
           attachmentMimeType;
end;

[forums]

What should the output be of to_html_table in the example above?

[sda]

like this

Tables replication automation with stored procedure giving statistics & error handling by email

I wrote this small script to ease replications tasks. It provides error handling and script housekeeping statistics and reporting by email. I thought I my be useful for others. In my case this script runs everyday and replicates 3.2 million of records (with many rows) in about 15 minutes, from 45 tables from a PostgreSQL and Exact Online to SqlServer. -- -- First we create a simple temp table containing the table names that we want to retrieve. -- create or replace table table_list@inmemorysto…