Ejemplos de ICodeWriterPlSql.EndScope en C# (CSharp)

Ejemplo n.º 1

        private void EndScripting()
        {
            updater.WriteLine("COMMIT;");
            updater.Indent--;
            updater.WriteLine("EXCEPTION");
            updater.Indent++;
            updater.WriteLine("WHEN OTHERS THEN");
            updater.Indent++;
            updater.WriteLine("DBMS_OUTPUT.PUT_LINE('SQLCODE: ' || SQLCODE); ");
            updater.WriteLine("DBMS_OUTPUT.PUT_LINE('SQL: ' || {0});", VarNameSql);
            updater.WriteLine("RAISE;");
            updater.Indent--;
            updater.EndScope();

            updater.Save(outFileNameDDLUpdate);
            creator.Save(outFileNameDDLCreate);
            cleaner.Save(outFileNameDDLDelete);

            genie.Config.NotifyAssistants("Finished", null, creator.ToString(true));
        }