我的函数如下:
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';
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';
解决方案 »
- 急!求助mysql5.0中文插入问题
- 关于数据库设计的合适与否?
- mysql Communications link failure-各位大侠帮我看看这是什么问题啊,超级郁闷的
- 联接两个数据库中的两个表,要求先对一个表进行排序后分组
- 一句SQL文,请教!
- 有一张mysql表,我想经过sql处理后变成另外的表,请高手帮忙
- 有一个分类的文章,请问如何从每一个类别中随机抽取一条信息???
- mysql数据导出问题(在线)
- 安装mysql for win2000出错:可安装的虚拟设备驱动程序之dll起始失败。选择“关闭”终止程序
- mysql 多条件查询的问题
- CSDN所有的人都人看看,帮小弟一把吧::mysql数据库误清除的解救办法????要分多少都没问题
- 请教
我也是最近开始用PgSQL的。