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.