function creation error on the postgresql ! - Need support please

From: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: function creation error on the postgresql ! - Need support please
Date: 2021-12-16 04:07:48
Message-ID: CAEz7P_uprCke5DyXKnD5k7X=EhPe+Uwh=_mgKGcj-uOcbm2N9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I tried to migrate oracle to PostgreSQL 11. x by using *Ora2PG.* The below
error was encountered while creating the function suggested by this tool.

Error 1#
LINE 6: Type c_DB_fields is Varray(10) of varchar(100);
CONTEXT: invalid type name "c_DB_fields is Varray(10) of varchar(100)"

Error2# (For oracle db link ). I tried to create extension as suggested :
WARNING: 'foreign data wrapper' is a beta feature!
HINT: To suppress this warning, set the 'ysql_beta_feature_foreign data
wrapper' yb-tserver gflag to true.
(Set 'ysql_beta_features' yb-tserver gflag to true to suppress the warning
for all beta features.)
CREATE EXTENSION
Query returned successfully in 4 secs 588 msec.

Error3#
ERROR: syntax error at or near "TABLE"
DETAIL: Internal error: Catalog Version Mismatch: A DDL occurred while
processing this query. Try again.
SQL state: XX000

Error4#
ERROR: syntax error at or near "DBMS_SQL"
LINE 47: DBMS_SQL.PARSE(source_cursor,sqlstmt,dbms_sql.v7);
^

Error5#
ERROR: relation "c_get_smtp_host_name" does not exist CONTEXT: compilation
of PL/pgSQL function "sendmail" near line 7 SQL state: 42P01

Error6#
ERROR: schema "utl_smtp" does not exist
LINE 13: l_conn utl_smtp.connection;
^
SQL state: 3F000
Character: 447

SQL state: 42601
Character: 2057

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2021-12-16 09:38:29 Re: [EXTERNAL] Re: Limits user connection in pgbouncer
Previous Message Godfrin, Philippe E 2021-12-15 19:57:24 RE: [EXTERNAL] Re: Limits user connection in pgbouncer