Linkedin

  • Home >
  • Handle overloaded Oracle functions in Aurora PostgreSQL-Compatible

Handle overloaded Oracle functions in Aurora PostgreSQL-Compatible

Project Overview

Project Detail

The code you migrate from an on-premises Oracle database to Amazon Aurora PostgreSQL-Compatible Edition might include overloaded functions. These functions have the same definition—that is, the same function name and the same number and data type of input (IN) parameters—but the data type or the number of output (OUT) parameters might differ. 

These parameter mismatches can cause problems in PostgreSQL, because it’s difficult to determine which function to run. This pattern illustrates how to handle overloaded functions when you migrate your database code to Aurora PostgreSQL-Compatible.

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/handle-overloaded-oracle-functions-in-aurora-postgresql-compatible.html?did=pg_card&trk=pg_card

To know more about this project connect with us

Handle overloaded Oracle functions in Aurora PostgreSQL-Compatible