migrating-oracle-to-postgres-stored-procedures

Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies explicit collation mapping (`COLLATE "C"` only when appropriate, locale collations when required). Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.

Install

KitScout test notes

Not tested by KitScout yet. When our harness runs it, pros, cons and the tasks we tried appear here, with the date and evidence.

Similar tools

• fix-slow-queries 113,505 ★
  Diagnose and fix slow Paperclip PostgreSQL queries using Cloud and Neon evidence, local reproduction, performa
• html-ppt-zhangzara-long-table 107,550 ★
  OpenDesign's unit-economics and BYOK cost model: the assumptions, the sensitivity, and why it scales. Built as
• data-scientist 70,897 ★
  Processes and analyzes data with resident-kernel engines (DuckDB, Polars) and one-shot tools. Use for CSV/parq
• data-quality-frameworks 49,672 ★
  Implement data quality validation with Great Expectations, dbt tests, and data contracts. Use when building da
• database-architect 49,672 ★
  Expert database architect specializing in data layer design from scratch, technology selection, schema modelin