perl-oracle

What problem does it solve?

Provides concise best-practice guidance for interacting with Oracle databases from Perl to avoid common bugs, performance pitfalls, and encoding issues when using DBI and DBIx::Class.

Core Features & Use Cases

• Connection Handling: Recommended DBI/DBIx::Class connection options and session initialization for Oracle.
• Date Handling: Guidance on InflateColumn::DateTime usage and when to pass DateTime objects versus formatted strings.
• IN Clause Chunking: Safe chunking patterns to avoid ORA-01795 with large IN lists.
• Bulk Operations & Debugging: Patterns for efficient bulk insert/update/delete and tips for DBIC_TRACE logging and performance tuning.
• Use Case: Audit a Perl codebase that interfaces with Oracle to fix date bugs, prevent large-IN failures, and optimize bulk data loads.

Quick Start

Use the perl-oracle skill to review a Perl project's DBI/DBIx::Class usage and recommend fixes for Oracle-specific connection, date, chunking, and bulk-operation issues.