Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjvkn-005iV9-Js for pgsql-novice@arkaria.postgresql.org; Fri, 30 Aug 2024 07:09:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sjvkk-00G43o-Qw for pgsql-novice@arkaria.postgresql.org; Fri, 30 Aug 2024 07:09:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjvkk-00G43e-Gc for pgsql-novice@lists.postgresql.org; Fri, 30 Aug 2024 07:09:03 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sjvkh-0028WU-7Z for pgsql-novice@lists.postgresql.org; Fri, 30 Aug 2024 07:09:01 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-42bb8c6e250so9175555e9.1 for ; Fri, 30 Aug 2024 00:08:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725001737; x=1725606537; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=7gNdl1E9aEAeS067buf/j7psufhfPGgTvKuKP2hLouw=; b=Rj9E+DkaEVRUJRSpP8nmay4YPqlJ7jCIQYGs5mWFCKA86it9fzFGNz+nItehkkQz8t 2N5kfvbtmM97JeBKDeE87KFwrbEEP3LP7PlkqqycrxIqTjYKY6aigJ7wHRbj83WXL8mz CYs+gVgzCFaql8J/kWw+iOgddiuDbZ6+tbtNdSrlL2wqDi+4L/c1DS5vi+HJ6N3G8WG0 9j3rG9tmDq/0koTk9d+VAMjAsUtBrKVinRD8W7cdx4MOKy3GS31IU0U4HTZ/uMOvm2IL d1yb5nBAzcbOhdE1aqL0dHG/RfpIZkEIeir8oA2thkDF7GmLRdycYuRdGhjJP0VcOeeI nIxw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725001737; x=1725606537; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=7gNdl1E9aEAeS067buf/j7psufhfPGgTvKuKP2hLouw=; b=hmZHijFlXnR1q0+kPaDLctQYseKBVj9F9y39DQ1HMCdTWGcyh/sueOPNrmmvey0dF1 UQBC/47OxsetQPUaBq6BqOmXMTsreTlY2UY9xcYTrDgErGTSaRkuaL4D7w7F+F6Jpe2u t6zjejeXrfNPRNsnmSLdgo5Mtqxh7ubiyO2pkrf+FMpOq5HoyahiRoBdKVCxjF5T0li9 9Shje280IUeZeY3BFEysAR/eUilre0X1OS+lsq4Du42f+GLb+2LIAo44SftW20ApROCU 86Ro0Ahi2oBgscF/h++901nLlpMNLW03oUoIAv7NkFRionYBxhGWXdKlhCi848Nmc63d SeGw== X-Gm-Message-State: AOJu0Yyn1Rn/q3K+2ExLvUHwp+N+qsKa+HtiyingAR/b5JHZDf6IAltl Cdx7+f1607EkB5D6SEcx2Eq04udXAQiAbhgFB+TYbbbr35qQIg2moY531zl/P6MkHCV9rWU2a+K s4PCcLPHpQL9xTkHoERD/GTCSZ8m1PA== X-Google-Smtp-Source: AGHT+IGDHADsxJdx24dBe8x/fkstIy5tH15g/p4TyH1YdgfeAR8JAqIngnkkXAS4pOzAWaBFh+oyoJ6weFxlrrnpl5M= X-Received: by 2002:a05:600c:1548:b0:428:2e9:65a9 with SMTP id 5b1f17b1804b1-42bb02d8cf2mr42012855e9.28.1725001737341; Fri, 30 Aug 2024 00:08:57 -0700 (PDT) MIME-Version: 1.0 From: Shweta Rahate Date: Fri, 30 Aug 2024 12:38:45 +0530 Message-ID: Subject: Calling oracle function from PostgreSQL To: pgsql-novice@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ca943b0620e143e7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ca943b0620e143e7 Content-Type: text/plain; charset="UTF-8" Hi All, In my application there is a requirement to call the oracle function from PostgreSQL db. The oracle function should take the input from Postgres db and returns the output. Please suggest a way to achieve this. Regards, Shweta --000000000000ca943b0620e143e7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All,

In m= y application there is a requirement to call the oracle function from Postg= reSQL db.

The oracle fun= ction should take the input from Postgres db and returns the output.
<= div dir=3D"auto">Please suggest a way to achieve=C2=A0this.=C2=A0



<= /div>
Regards,
Shweta
--000000000000ca943b0620e143e7--