Lightlines
By github

migrating-oracle-to-postgres-stored-procedures

github1.9k installs

Your Oracle procedures, translated for PostgreSQL.

What it does

Convert Oracle stored procedures and functions into PostgreSQL equivalents while preserving their signatures and behavior.

When to use it

Use when converting Oracle stored procedures or functions to PostgreSQL during a database migration.

How to use it

Give it a project containing Oracle procedure sources and schema definitions; it writes each translated procedure into the project's PostgreSQL output directory.

What you provide

  • An existing project

Uses

Latest review

What you need · 2

Requires access to the target PostgreSQL environment to query its available collations.

The orafce extension enables translations that use it to improve clarity or fidelity.


Access · 1

This skill

PostgreSQL

Read

Queries available PostgreSQL collations