On 7/5/19 5:35 AM, Abraham, Nikhil (COR), Vodafone Idea wrote:
Dear Team,
Good Wishes.
We are planning to migrate one of our critical applications from Oracle
to 11.1 Postgresql. The UI of the application calls lots of PL/SQL
procedures. In order to have that calling facility there is a jar
provided by the respective databases. Currently the ODBS-JDBC
connectivity drivers are provided by Oracle in the form of jar. However
connectivity from UI to call procedures in Postgresql is currently not
possible in absence of such a driver. The reason being no jar is
provided for such connectivity for version 11.1 Postgresql.
There is a JDBC driver for Postgres:
https://jdbc.postgresql.org/documentation/head/index.html
and it can call stored functions:
https://jdbc.postgresql.org/documentation/head/callproc.html
If this is not what you are looking for then can you be more specific
about your needs?
This challenge has become a show stopper for migration, please let us
know whether any alternative are available for the same.
Regards
Nikhil
This E-Mail (including any attachments) may contain Confidential and/or
legally privileged Information and is meant for the intended
recipient(s) only. If you have received this e-mail in error and are not
the intended recipient/s, kindly notify us at
mailadmin@xxxxxxxxxxxxxxxx and then delete this e-mail immediately from
your system. You are also hereby notified that any use, any form of
reproduction, dissemination, copying, disclosure, modification,
distribution and/or publication of this e-mail, its contents or its
attachment/s other than by its intended recipient/s is strictly
prohibited and may be unlawful. Internet Communications cannot be
guaranteed to be secure or error-free as information could be delayed,
intercepted, corrupted, lost, or may contains viruses. Vodafone Idea
Limited does not accept any liability for any errors, omissions, viruses
or computer shutdown (s) or any kind of disruption/denial of services if
any experienced by any recipient as a result of this e-mail.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
