Find Jobs
Hire Freelancers

Need Example for Postgres 11 - Procedures

$12-30 SGD

已关闭
已发布超过 5 年前

$12-30 SGD

货到付款
I need help with a simple script. Need advice and a working example of how to run a Procedure with Commit and returning a dummy result back from it. I have a example that you can reference but it is not working perfectly yet. i am not able to retrieve the result from the refcursor after i add the commit. e.g. script CREATE OR REPLACE PROCEDURE oureadata.pg_boweb_cms_category_update_v2(pid character, pcategoryname character varying, pwebcode character varying, porder numeric, pupdatedby character varying, pupdateddate timestamp without time zone, plang character varying, INOUT cresults refcursor) LANGUAGE plpgsql AS $procedure$ DECLARE cnt bigint; rtnCode char(1); BEGIN cresults := 'cur'; BEGIN update oureadata.CMS_CATEGORY set FCATEGORYNAME = pCategoryName, FWEBCODE = pWebCode, FORDER = pOrder, FUPDATEDBY = pUpdatedBy, FUPDATEDDATE = pUpdatedDate, FLANGCODE = pLang where lower(FID) = lower(pId); commit; end; OPEN cresults FOR VALUES ('stringresult'); end; $procedure$ AND to execute the above script.. i use : BEGIN; CALL oureadata.pg_boweb_cms_category_update_v2('e72fa40e-2447-4d59-b6cd-76625d180c32', '1', 'SG988', 3, 'testadmin', '2018-01-11 14:32:50', 'en-gb', ''); fetch all in cur; commit; PM me if you can help.
项目 ID: 17261116

关于此项目

4提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
4威客以平均价$29 SGD来参与此工作竞价
用户头像
Hello how are you, I hope you are well, I am interested in the example you need in postgreql, I have experience in these topics, I can help you in stored procedures and functions, complex and simple views, triggers, etc., do not hesitate to write me I always answer the messages.
$36 SGD 在1天之内
4.6 (3条评论)
3.0
3.0
用户头像
hey, I am from India. I am graduate from India. I have done many projects in a different language. like ionic, Oracle database, MySQL database, database administration, PHP, Java, javascript, desktop applications, web application, mobile application. I am ready to work with you. I will complete your project within given time period.
$26 SGD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have experence in plpgsql. I can explaine You why this procedure w doesn't work, and rewrite it to meet you requirements.
$18 SGD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

SINGAPORE的国旗
Tampines, Singapore
5.0
5
会员自10月 7, 2012起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。