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
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 |