protected AbstractStoredProcedureCommand(int num, XElement inner) : base(num) { XElement description = inner.Element("procedure"); this.procedure = new StoredProcedureReference( description.Element("package").Value, description.Element("name").Value, from elem in description.Elements("parameter") select new StoredProcedureReference.ParameterDescription( elem.Element("name").Value, directions[elem.Element("direction").Value], elem.Element("type").Value ) ); }
public void CreateStoredProcedure(StoredProcedureReference procedure, StoredProcedureBody body) { this.traits.CreateStoredProcedure(this.CreateTextCommand, procedure, body); }
public void RemoveStoredProcedure(StoredProcedureReference procedure) { this.traits.RemoveStoredProcedure(this.CreateTextCommand, procedure); }
public void ReplaceStoredProcedureBody(StoredProcedureReference procedure, StoredProcedureBody newBody) { this.traits.ReplaceStoredProcedureBody(this.CreateTextCommand, procedure, newBody); }
//SELECT LINE, TEXT FROM ALL_SOURCE WHERE TYPE = 'PACKAGE BODY' AND NAME = '' AND OWNER = (SELECT USER FROM DUAL) for update public StoredProcedureBody GetStoredProcedureBody(StoredProcedureReference procedure) { return this.traits.GetStoredProcedureBody(this.CreateTextCommand, procedure); }