Find Jobs
Hire Freelancers

Need Example for Postgres 11 - Procedures

$12-30 SGD

Stengt
Lagt ut nesten 6 år siden

$12-30 SGD

Betalt ved levering
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.
Prosjekt-ID: 17261116

Om prosjektet

4 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
4 frilansere byr i gjennomsnitt $29 SGD for denne jobben
Brukeravatar
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 om 1 dag
4,6 (3 omtaler)
3,0
3,0
Brukeravatar
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 om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

SINGAPOREs flagg
Tampines, Singapore
5,0
5
Medlem siden okt. 7, 2012

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.