oracle8.1.6
begin
:1 := acs_sc_contract.new(
:name,
:description
);
end;
acs_sc_contract.get_name(
:contract_id
) from dual
select acs_sc_contract.get_id(
:name
) from dual
select operation_id,
operation_inputtype_id,
operation_outputtype_id
from acs_sc_operations
where contract_id = :contract_id
begin
acs_sc_contract.del(
contract_name => :name
);
end;
begin
:1 := acs_sc_operation.new(
:contract_name,
:operation,
:description,
:is_cachable_p,
:nargs,
:input_type_name,
:output_type_name
);
end;
select contract_name,
operation_name
from acs_sc_operations
where operation_id = :operation_id
begin
acs_sc_operation.del(
contract_name => :contract_name,
operation_name => :operation_name
);
end;