我的函数如下:
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';
解决方案 »
- mysql语句求助
- mysql很棘手的问题
- [急]在导入decimal时为什么会是负数(-8446744056209541515)
- Mysql起动后马上自动停止是什么原因?
- 关于字段的奇怪问题,如何才能查询mysql字段里面的不可见字符。。。
- 请问在postgres中,我如何创建索引?注意如果存在索引就得同事删除这个索引再建
- access2000导入MSSQL中,表间关系怎么导入,急,在线等待
- mysql 是否不支持中文名称表名?
- Mysql用LOAD DTA INFILE导入数据
- 请教各位大神两个表合并的sql
- CSDN所有的人都人看看,帮小弟一把吧::mysql数据库误清除的解救办法????要分多少都没问题
- 请教
我也是最近开始用PgSQL的。