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);
}