我的函数如下:
CREATE OR REPLACE FUNCTION  tmp_passitity_fee_proc
                (VARCHAR,VARCHAR,INT2,INT2,VARCHAR,VARCHAR,VARCHAR,VARCHAR,VARCHAR,INT2) RETURNS BOOLEAN
AS'
DECLARE
--////////接受外部变量
v_recv_code       ALIAS FOR $1;   
v_send_code       ALIAS FOR $2; 
v_code_id         ALIAS FOR $3; 
v_serv_typeid     ALIAS FOR $4;  
v_system_code     ALIAS FOR $5;   
v_account_code    ALIAS FOR $6;   
v_apply_date      ALIAS FOR $7;   
v_bank_code       ALIAS FOR $8;   
v_trade_money     ALIAS FOR $9;   
v_response_codeid ALIAS FOR $10;  
--////////v_bus_count     INT2;
v_user_mesg     VARCHAR(160);   --用户提示信息
v_trade_code    VARCHAR(10);    --获取交易码
v_response_code VARCHAR(4);     --响应码BEGIN
   SELECT user_mesg INTO v_user_mesg FROM conf_user_prompt_t
   WHERE trade_codeid=v_code_id AND port_code=v_recv_code;
   
   --获取交易码
   SELECT trade_code INTO v_trade_code FROM conf_trade_code_define_t
   WHERE trade_codeid=v_code_id;
   
   --获取响应码
   SELECT code_name INTO v_response_code FROM conf_bank_response_code_t
   WHERE response_codeid=v_response_codeid;
  
   INSERT INTO tmp_passitity_fee_t(phone_code,
                                   trade_codeid,
                                   serv_typeid,
                                   system_code,
                                   bank_code,
                                   account_code,
                                   apply_date,
                                   status)
                            VALUES(v_send_code,
                                   v_code_id,
                                   v_serv_typeid,
                                   v_system_code,
                                   v_bank_code,
                                   v_account_code,
                                   v_apply_date,
                                   1);
   INSERT INTO tmp_to_user_t(merchant_code,term_code,date_time,account_code,bank_code,trade_money,
                             pay_date,response_code,send_private,return_private,mac_data,system_code,
                             balance_date,preserv1,preserv2,preserv3,preserv4,preserv5,trade_code)
                      VALUES('','',v_apply_date,v_account_code,v_bank_code,v_trade_money,
                             v_apply_date,v_cresponse_code,'','','',v_system_code,
                             '','','','','','',v_trade_code);
   RETURN TRUE;
END;
'LANGUAGE 'plpgsql';