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.
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.
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.