postgresql7.1
select acs_sc_binding__exists_p(:contract,:impl)
select impl_alias, impl_pl
from acs_sc_impl_aliases
where impl_contract_name = :contract
and impl_operation_name = :operation
and impl_name = :impl
select
operation_desc,
coalesce(operation_iscachable_p,'f') as operation_iscachable_p,
operation_nargs,
operation_inputtype_id,
operation_outputtype_id
from acs_sc_operations
where contract_name = :contract
and operation_name = :operation
select
element_name,
acs_sc_msg_type__get_name(element_msg_type_id) as element_msg_type_name,
element_msg_type_isset_p,
element_pos
from acs_sc_msg_type_elements
where msg_type_id = :operation_inputtype_id
order by element_pos asc
select
element_name,
acs_sc_msg_type__get_name(element_msg_type_id) as element_msg_type_name,
element_msg_type_isset_p,
element_pos
from acs_sc_msg_type_elements
where msg_type_id = :operation_outputtype_id
order by element_pos asc