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 1sjvuI-005kHM-3k for pgsql-novice@arkaria.postgresql.org; Fri, 30 Aug 2024 07:18:54 +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 1sjvuG-00GCyZ-6I for pgsql-novice@arkaria.postgresql.org; Fri, 30 Aug 2024 07:18:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjvuF-00GCws-U8 for pgsql-novice@lists.postgresql.org; Fri, 30 Aug 2024 07:18:52 +0000 Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sjvuD-002DAt-7v for pgsql-novice@lists.postgresql.org; Fri, 30 Aug 2024 07:18:51 +0000 Received: by mail-lf1-x129.google.com with SMTP id 2adb3069b0e04-5334eec7485so234436e87.3 for ; Fri, 30 Aug 2024 00:18:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725002330; x=1725607130; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=j1cj81tTzEbAddzI/VFJUXUXzASybdOq3cCyoswMc6Y=; b=CEwxy/qm94dwMRyTdyMAdjKCmgY6SnydTRdzAnOILXOvARAyZqtFoz3Sd1qwWkldiv wL4L8W7ptFJQCyPwSm/wea12vXzcFkva8UGCEwUbcADp5Vnqj4ODqyYRFrAvdMMWxNAu 8PKI7QuzPiW9ToIIt3Bi2GtcTRw5LTwMcJZW1SFV2CSCXOVVZKTDiQ6TdpyQlbxhQ2mo ytg2c1bTG/OdufMyxiWxYfgjN5PAFPivjzs6kv53CyrUUaAbj8ftZVno+tKNTvNZ0kzz s/3z3rTiZ/nBT8VChJJ4x4VNXIRJRjm0bgDa8VqEJZCvy6B8hbQmGSRSJgWJeendiNXG IijA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725002330; x=1725607130; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=j1cj81tTzEbAddzI/VFJUXUXzASybdOq3cCyoswMc6Y=; b=ZDoOaez2QL7P40tZjy4dkRHzCfmksjpHeJOIaCAlkfKner5IHOy7M5+X876Ftza9ml D4pW8tVJZXtaBOnO2UoMFZzx7h6FnEKZIACu0tG7VrnqU5XAoz0wc7SWwbPYG5KZRG+A xrhU/098OL/hdNKe+RhHN+YIZBqPKkEk2uNk6EMWzvpp0azBvmjcx4W9gA0lEEZrTIgf q2SKfnVjUniNElaDldtrXl9njBH42pDWFkww/FIcaxZVTDJsmfNP5hlfISPMnMdNlgor PhaFpqk5RYvn709GRuVLN+Fee3FquszBGcB6nZiiKmP65Qk45PH8XmOb+ymF9pO27Y6N 6AQg== X-Gm-Message-State: AOJu0Yxl7yNtTIvS6FhZGqN4yCLGMhLN+xpor7/k9YpDpSmpYlmPvN7E TlwqPKmWuGtWz0MQbQKNzplx1G1i6goieOPTNefOHMbgOLuHVbJphf9IcULt7cJr3ZysJdOfm/k 7k8+/J6ayKdXufvm6sf216zT8Y/A= X-Google-Smtp-Source: AGHT+IG99OaNXXjKg7EDp5CezfihmVnrfXHr1wYcacf1floQE6ins627i2cATVoTZ+RUXahZl3yMZYtdEV40aowKMuw= X-Received: by 2002:a05:6512:3b8a:b0:52f:c0dd:d168 with SMTP id 2adb3069b0e04-53546bb944amr413412e87.7.1725002329193; Fri, 30 Aug 2024 00:18:49 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Muhammad Ikram Date: Fri, 30 Aug 2024 12:18:32 +0500 Message-ID: Subject: Re: Calling oracle function from PostgreSQL To: Shweta Rahate Cc: pgsql-novice@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000011855c0620e1677e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000011855c0620e1677e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Please explore oracle_fdw. Regards, Muhammad Ikram On Fri, Aug 30, 2024 at 12:09=E2=80=AFPM Shweta Rahate wrote: > 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 th= e > output. > Please suggest a way to achieve this. > > > > Regards, > Shweta > --=20 Muhammad Ikram --00000000000011855c0620e1677e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

Please explore oracle_fdw.=C2=A0

Regards,
Muhammad Ikram


On Fri, Aug 30, 2024 at 12:09=E2=80=AFPM Shweta Rahate <rahateshweta20@gmail.com> wrote:
Hi A= ll,

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.
Pleas= e suggest a way to achieve=C2=A0this.=C2=A0



Regards,
Shweta


--
Muhammad Ikram

--00000000000011855c0620e1677e--