Авто изменение даты запрета редактирования документов : Супермаг Плюс (Супермаг 2000)

declare
  I             Number(10);
  X            Number(10);
  MySQL    varchar(1000);
 
begin


  MySQL := 'begin update supermag.sssysinfo set paramvalue = TO_CHAR(SYSDATE-2,''dd.mm.yyyy'') where paramname= ''ClosedPeriod''; Commit; end;';

   select count(*) into i from supermag.sscontrolfunctions
     where ID  = 99;
  If i = 0 Then
    insert into supermag.sscontrolfunctions (FNTYPE, ID, TITLE)
    values ('SS', 99, 'Движение даты запрета');
  end if;

 select count(*) into x from supermag.saschedule
  where supermag.saschedule.ID = 99;

  if x = 0 Then
    insert into supermag.saschedule (ID, WHAT)
      values (99, MySQL);
   else
    update supermag.saschedule set WHAT=MySQL where ID=99;
  end if;

end;

@echo off
echo ------------------------------- >> db_date.log
set nls_lang=american_america.cl8mswin1251
SET ORACLE_SID=DBCO
sqlplus.exe supermag/qqq@dbco @db_date.sql
echo Base %oracle_sid% %date% %time% >> db_date.log

 
update sssysinfo set PARAMVALUE=TO_CHAR((sysdate-30),'dd.mm.yyyy') where PARAMNAME='ClosedPeriod';
commit;
exit;

using System;
using System.Data;
using System.Data.OracleClient;

namespace LC
{
    class Program
    {
        
        static void Main(string[] args)
        {
            if (args.GetLength(0) == 2)
            {
                string storeName = args[0];
                string packetName = args[1];
                string connString = string.Format("Data Source={0};User ID=supermag;Password = xxxxxx;Unicode=True", storeName);
                using (var conOra = new OracleConnection(connString))
                {
                    conOra.Open();
                    using (var cmd = new OracleCommand(packetName, conOra))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        try
                        {
                            cmd.ExecuteNonQuery();
                            Console.Write("Done \n");

                        }
                        catch (Exception ex)
                        {
                            Console.Write(ex.Message);
                        }
                        finally
                        {
                            conOra.Close();
                        }
                    }
                }
            }
            else
            {
                Console.Write("Wrong arguments\n");
                Console.Write("Use LC DBName OraclePacketName\n");
            }
        }
    }
}