From: | Mahesh Bodepati <mahesh(dot)bodepati(at)Xius(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | facing problem in outparameters in c |
Date: | 2020-10-26 10:45:16 |
Message-ID: | MAXPR01MB36478D4B42FF07E5657B068C96190@MAXPR01MB3647.INDPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Team,
i am facing the problem in passing the outparameters in postgres package calling by using c language.can you please help us to solve the problem..
below is way iam calling the package.
snprintf(buffer, sizeof(buffer),"SELECT smp_ss7_mig_dev.pr_pkg_oss_networkserver_pr_sp_apply_sl_yn('%s','%s','%s', %d ,%d)",m_h_imsi.arr,m_h_hlraddress.arr,m_h_vlraddress.arr,m_ht_message,m_ht_msgType,allow_yn,po_ns_relay_reason,po_sl_relay_reason);
res = PQexec(con,buffer);
if (PQresultStatus(res) != PGRES_TUPLES_OK) {
printf("No data retrieved\n");
PQclear(res);
PQfinish(con);
exit(1);
}
printf("allow_yn===%d\tpo_ns_relay_reason==%d\tpo_sl_relay_reason==%s\n",allow_yn,po_ns_relay_reason,po_sl_relay_reason.arr);
Thanks & Regards,
Mahesh Bodepati
Software Engineer- Engineering
XIUS
INNOVATE . LEAD.
mahesh(dot)bodepati(at)xius(dot)com<mailto:battini(dot)subrahmanyam(at)xius(dot)com>
http://www.xius.com<http://www.xius.com/>
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Semanchuk | 2020-10-26 13:21:47 | Re: postgres materialized view refresh performance |
Previous Message | Vasu Madhineni | 2020-10-26 09:35:47 | Open source monitoring streaming replication |