Stack Overflow
Stack Overflow

Questions tagged [orafce]

An open source software that implements some Oracle PL/SQL subprograms and packages in PostgreSQL.

An open source (BSD license) software that implements some Oracle PL/SQL subprograms and packages in PostgreSQL.

12 questions
2
votes
1 answer

collect2: fatal error: cannot find 'ld' when executing make install

I am migrating an Oracle Database to Postgres and I wanted to install orafce which is a module that contains some useful function which can help with the porting. I tried to execute the command "make install" but I got this error "collect2: fatal…
Massadi
  • 21
  • 1
  • 8
2
votes
1 answer

Schemas installed with extension orafce on PostgreSQL

I installed orafce extension on PostgreSQL 9.5. I saw that it is better to create a specific schema for all extensions and that what I did. I connected to template 1 and performed the next commands : template1=# create schema extensions; CREATE…
JeyJ
  • 3,582
  • 4
  • 35
  • 83
1
vote
1 answer

Convert text in PLPGSQL/Orafce

I'm working with PL/pgSQL and Orafce after a conversion from Oracle. In a function I'm writing in a file. I would like to write with the LATIN1 encoding. My database is in UTF8. There is convert functions but I think I miss something because I don't…
Martin Dejax
  • 11
  • 1
1
vote
1 answer

Orafce install in postgresql 9.5

I am new to programmer world so i want to learn so many things, and about what i want to ask, can i install orafce in postgresql? I mean all the tutorial always show use BigSql but iam using from enterprise DB. I am already try take orafce.dll from…
dwir182
  • 1,539
  • 10
  • 20
1
vote
1 answer

How to install / use orafce package in postgresql 9.4?

I'm running the "official" docker container of postgresql in version 9.4. I went inside the running container and installed orafce docker exec -i -t my_postgres bash apt-get install postgresql-9.4-orafce afterwards I've tried to reload and restart…
peter
  • 14,348
  • 9
  • 62
  • 96
0
votes
1 answer

Is it possible to support orafce in google postgres cloud sql

we used orafce for our oracle to postgres migration, it work very well. https://github.com/orafce. Recently we try to migrate to cloud db, we choose the google cloud, however, I found that the google cloud is not support the orafce…
Ralph Yang
  • 13
  • 2
0
votes
1 answer

Oracle UTL_FILE exceptions alternatives in Postgres

I'm migrating an Oracle stored procedure to AWS Aurora Postgres which has UTL_FILE operations to read and write in external files. In the Exception part, I have all these exception types used. UTL_FILE.invalid_path, UTL_FILE.invalid_operation,…
Mano
  • 601
  • 10
  • 32
0
votes
1 answer

ERROR: could not load library ~/orafce.so: ~/orafce.so: undefined symbol: pq_sendbyte SQL state: XX000

Im trying to enable Orafce(3.7.1-1) extension on my postgress11 (11.2-2) My OS is Ubuntu 18.04 The extension is already available in the database , and is listed if I run the following command : select * from…
ABR
  • 1
0
votes
1 answer

orafce for postgresql version 10.1 undefined symbol: Float8GetDatum

I'm trying to install orafce extension on postgresql 10.1. I'm getting the next error : Could not load library "$libdir/orafce": ERROR: could not load library "MyPATH/orafce.so": MyPATH/orafce.so: undefined symbol: Float8GetDatum When I run make…
JeyJ
  • 3,582
  • 4
  • 35
  • 83
0
votes
1 answer

migrate oracle to Postgresql UTL_FILE EXCEPTIONS

I have the same situation as described in this post: Porting Oracle procedure to PostgreSQL (exception codes from orafce for utl_file module) I'm migrating from oracle to postgres with ora2pg and I`m trying to correct the syntax of the exception…
JeyJ
  • 3,582
  • 4
  • 35
  • 83
0
votes
1 answer

Porting Oracle procedure to PostgreSQL (exception codes from orafce for utl_file module)

I am in the middle of a database migration from Oracle to PostgreSQL. We are using ora2pg to make the conversion the plus automatic possible and the orafce plugin for PostgreSQL for functions compatibility. We have just started and a lot of work is…
Ciges
  • 1,133
  • 11
  • 17
-3
votes
1 answer

UTL_FILE in pl/pgsql

Can someone explain to me how to use UTL_FILE package with PostgreSQL (pl/pgsql). Every time I do a query I have this error missing FROM clause entry for table "utl_file"`: This is my code: CREATE OR REPLACE FUNCTION xxxxxx( IN strficname…
Kamfasage
  • 181
  • 1
  • 7
  • 14