facing problem in outparameters in c - Mailing list pgsql-general

From Mahesh Bodepati
Subject facing problem in outparameters in c
Date
Msg-id MAXPR01MB36478D4B42FF07E5657B068C96190@MAXPR01MB3647.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: facing problem in outparameters in c  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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.



pgsql-general by date:

Previous
From: Vasu Madhineni
Date:
Subject: Open source monitoring streaming replication
Next
From: Philip Semanchuk
Date:
Subject: Re: postgres materialized view refresh performance