Please don’t pick random places to send emails. This is neither a bug nor a security issue so neither of these lists apply. The -general list is most appropriate.
On Sunday, July 21, 2019, jay chauhan <
jaychauhan.src@gmail.com> wrote:
<<My PostgreSQL version : "PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit">>
Use a newer version
Good evening!
I am migrating Oracle DB into PostgreSQL. However I am facing some issue in postgreSQL as listed below.
Error-1)
ERROR: cannot begin/end transactions in PL/pgSQL
HINT: Use a BEGIN block with an EXCEPTION clause instead.
CONTEXT: PL/pgSQL function icmsuatnew.eload_commission_payout_active(text,text,text,text,text,text) line 486 at SQL statement
SQL state: 0A000
Rewrite your code as instructed
Error-2)
ERROR: schema "utl_http" does not exist
Insufficient data provided to even guess
Maybe hire an experienced migration company then.
David J.