orafce | project implements in Postgres some of the functions | Database library

by orafce C Version: VERSION_4_2_4 License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(2)Vulnerabilities Install Support

kandi X-RAY | orafce Summary

orafce is a C library typically used in Database, Oracle applications. orafce has no bugs, it has no vulnerabilities and it has low support. However orafce has a Non-SPDX License. You can download it from GitHub.

Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS. There is an associated Google group - The Orafce is supported in AWS Aurora with PostgreSQL Compatibility and also in Azure Database for PostgreSQL.

Support

Quality

Security

License

Reuse

Support

orafce has a low active ecosystem.

It has 405 star(s) with 143 fork(s). There are 42 watchers for this library.

It had no major release in the last 12 months.

There are 0 open issues and 122 have been closed. On average issues are closed in 7 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of orafce is VERSION_4_2_4

Quality

orafce has 0 bugs and 0 code smells.

Security

orafce has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

orafce code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

orafce has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

orafce releases are available to install and integrate.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of orafce

Get all kandi verified functions for this library.

orafce Key Features

No Key Features are available at this moment for orafce.

orafce Examples and Code Snippets

No Code Snippets are available at this moment for orafce.

Community Discussions

Trending Discussions on orafce

Is it possible to support orafce in google postgres cloud sql

Oracle UTL_FILE exceptions alternatives in Postgres

QUESTION

Is it possible to support orafce in google postgres cloud sql

Asked 2020-Oct-24 at 06:35

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 extension.
https://cloud.google.com/sql/docs/postgres/extensions#postgresql-extensions-supported-by-cloud-sql

Is it possible to support orafce extension in google cloud?

...

ANSWER

Answered 2020-Oct-24 at 06:35

At the moment “orafce” extension is not supported.

As you can see on this public issue tracker, many other users of Cloud SQL wish for this, I would recommend you to “star” or +1 this public issue in order to show your interest for this feature and by +1 it you will be updated for any changes on the implementation of this feature.

Source https://stackoverflow.com/questions/64510527

QUESTION

Oracle UTL_FILE exceptions alternatives in Postgres

Asked 2020-Jul-21 at 18:43

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, UTL_FILE.invalid_mode, UTL_FILE.read_error, UTL_FILE.write_error, and WHEN OTHERS.

Is it possible to handle all these exceptions in Postgres or should I go for orafce extension?

...

ANSWER

Answered 2020-Jul-21 at 18:43

What I know, The AWS Aurora Postgres uses Orafce too

https://aws.amazon.com/about-aws/whats-new/2020/06/amazon-aurora-supports-postgresql-versions-117-1012-and-9617-and-adds-global-database-for-postgresql-117/

Postgres has not custom named exceptions like Oracle, so you have to rewrite your code little bit, you have to check error message instead - for example - Oracle's UTL_FILE.write_error is a Postgres's RAISE exception (named raise_exception - P0001) with error message (available in SQLERRM variable or via GET STACKED DIAGNOSTICS) is "UTL_FILE_WRITE_ERROR".

Source https://stackoverflow.com/questions/62952333

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install orafce

You can download it from GitHub.

Support

orafce’s VARCHAR2 implements parts of Oracle database specification about VARCHAR2:. Please note that PostgreSQL does not allow to dynamically specify how we interpret varchar strings. It always interprets them as 'character' strings as determined by database encoding. So, we cannot support both BYTE and CHARACTER semantics for a given varchar type in the same database. We chose to implement the BYTE semantics as that is default in Oracle. For CHARACTER semantics, please see NVARCHAR2 which by default always implements the CHARACTER semantics. Please be careful when using the above type to store strings consisting of multibyte encoded characters wherein each character may be composed of an arbitrary number of bytes.

Find more information at: