Question

How to call two procedures in a select query

e.g:

SELECT sp_get_input_xml (:in_request_oid,
                                    :in_contract_oid,
                                    :in_contract_type,
                                    :out_input_xml
                                   ),
       sp_get_output_xml (:in_request_oid,
                                     :in_contract_oid,
                                     :in_contract_type,
                                     :out_output_xml
                                    )
  FROM DUAL;

What s the correct way to call two procedures using select statement?

Answer 1

Look。你可以把程序从一个坐标点上说出来,你只能称之为“选举”。如果这些职能是完全可以接受的。如果是程序的话,你需要使用一个PL/SQL组来打他们。

友情链接