DBIx::...:Oracle(3pm)

🌸 DBIx::...:Oracle 💜

okay bestie, welcome to the manual page for DBIx::SearchBuilder::Handle::Oracle — yeah, the manual name on the tin is DBIx::...:Oracle(3pm) and it lives in the User Contributed Perl Documentation, but the actual star of the show is this Oracle-specific Handle object. sit down, grab a snack, we're doing Oracle idiosyncrasies together 🫶

---

✨ NAME ✨

DBIx::SearchBuilder::Handle::Oracle — an Oracle-specific Handle object. that's her. that's the girl. 👑

---

✨ SYNOPSIS ✨

literally nothing here bestie 😭 no synopsis, no example, just vibes. the author said "read the methods" and honestly? fair.

---

✨ DESCRIPTION ✨

So basically this module is a subclass of DBIx::SearchBuilder::Handle that exists purely to compensate for some of the idiosyncrasies of Oracle. you know how Oracle is. we all know how Oracle is. this module is the emotional support subclass. 💅

---

✨ METHODS ✨

🌟 Connect PARAMHASH: Driver, Database, Host, User, Password

Takes a paramhash and connects to your DBI datasource. that's it, that's the method, she connects you. no cap. 🦋

🌟 BuildDSN

This is the customized version of the BuildDSN in DBIx::SearchBuilder::Handle method. same energy, Oracle flavor ✨

It takes an additional argument SID. The Database argument gets used unless SID is provided.

Two forms of DSN get generated, depending on whether Host is defined or not:

dbi:Oracle:sid=<SID>;host=...[;port=...]
dbi:Oracle:<SID>

For the details, go read the documentation for the DBD::Oracle module. iykyk. 📖

🌟 Insert

Takes a table name as the first argument, and assumes the rest of the arguments are an array of key-value pairs to be inserted. mwah, simple. 💖

🌟 InsertFromSelect

A customization of InsertFromSelect in DBIx::SearchBuilder::Handle.

Unlike other DBs, Oracle needs:

• an id generated from sequences for every new record 🔢
• query wrapping in parens 🎀

NOTE that on Oracle there's a limitation on the query! Every column in the result should have a unique name or alias, or else. for example, the following query would generate the ORA-00918: column ambiguously defined error:

SELECT g.id, u.id FROM ...

Solve it with aliases, bestie:

SELECT g.id AS group_id, u.id AS user_id FROM ...

🌟 KnowsBLOBs

Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs for inserts. she's a yes/no girlie. 💅

🌟 BLOBParams FIELD_NAME FIELD_TYPE

Returns a hash ref for the bind_param call, to identify BLOB types used by the current database for a particular column type. The current Oracle implementation only supports ORA_CLOB types (112). that's the whole menu, babe. 🍓

🌟 ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW

Takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW. massage therapy for queries, periodt. 💆‍♀️

🌟 DistinctQuery STATEMENTREF

Takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set. only the unique ones make the cut, as they should. 👑

🌟 BinarySafeBLOBs

Returns undef, because Oracle doesn't support binary-safe CLOBS. not her fault, she's just the messenger 😭

🌟 DatabaseVersion

Returns the value of the ORA_OCI constant. see "Constants" in DBI. 📌

🌟 SimpleDateTimeFunctions

Returns a hash reference with the specific datetime functions of this database for DateTimeFunction in DBIx::SearchBuilder::Handle. ⏰✨

🌟 ConvertTimezoneFunction

A custom implementation of ConvertTimezoneFunction in DBIx::SearchBuilder::Handle. timezones, but make it Oracle. 🌈

Use the following query to get the list of timezones:

SELECT tzname FROM v$timezone_names;

And read Oracle's docs about timezone files right here:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667

---

🎀 that's a wrap 🎀

that's the whole page bestie, thanks for reading all the way to the end, you're the main character fr fr 💖 this was DBIx::...:Oracle(3pm) in the User Contributed Perl Documentation, running on perl v5.40.1, dated 2026-05-07. slay, bye 👋✨💅