CODEWITHSUNDEEP
sqlstored-procedures
user1059151
user1059151

Reputation: 1

call two procedures in select query?

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?

Upvotes: 0

Views: 78

Answers (1)

Matthew Watson
Matthew Watson

Reputation: 14233

Looks like oracle. You can't call PROCEDURES from a SQL query, you can only call FUNCTIONS. If these are functions, that is perfectly acceptable. If you are procedures you'll need to use a PL/SQL block to call them.

Upvotes: 2

Related Questions