Thread: Please Help on MS SQL7.0 Procedure to PostgreSQL

Please Help on MS SQL7.0 Procedure to PostgreSQL

From
"annachau"
Date:
I have some problems on MS SQL procedure convert to PostgreSQL function. Please give me some advice.

I have many procedure in MS SQL which return more than one value.
Example:
CREATE procedure usp_BBox_chk_policy_rule
    @appln_ref_no       varchar(12),
    @version            integer,
    @offer_seq          numeric(18,0),
    @policyID           char(3),
    @pass_ind           integer  out,
    @ret_cnt_off_desc   varchar(500) out,
    @ret_cnt_off_desc_l varchar(500) out

How can I return more than one value?

Thanks a lot.