This is an Oracle database driver for Rust based on ODPI-C.

Don't use this until the version number reaches to 0.1.0.

• Rust 1.18 or later
• C compiler. See Compile-time Requirements in this document.

• Oracle client 11.2 or later. See ODPI-C installation document.

Rust-oracle was published to crates.io. However it is old. Use rust-oracle in the github.

[dependencies]
oracle = { git = "https://github.com/kubo/rust-oracle.git" }

When you need to fetch or bind chrono data types, enable chrono feature:

[dependencies]
oracle = { git = "https://github.com/kubo/rust-oracle.git", features = ["chrono"] }

NLS_LANG consists of three components: language, territory and charset. However the charset component is ignored and UTF-8(AL32UTF8) is used as charset because rust characters are UTF-8.

The territory component specifies numeric format, date format and so on. However it affects only conversion in Oracle. See the following example:

// The territory is France.
std::env::set_var("NLS_LANG", "french_france.AL32UTF8");
let conn = oracle::Connection::new("scott", "tiger", "").unwrap();

// 10.1 is converted to a string in Oracle and fetched as a string.
let mut stmt = conn.execute("select to_char(10.1) from dual", &[]).unwrap();
let row = stmt.fetch().unwrap();
let result: String = row.get(0).unwrap();
assert_eq!(result, "10,1"); // The decimal mark depends on the territory.

// 10.1 is fetched as a number and converted to a string in rust-oracle
let mut stmt = conn.execute("select 10.1 from dual", &[]).unwrap();
let row = stmt.fetch().unwrap();
let result: String = row.get(0).unwrap();
assert_eq!(result, "10.1"); // The decimal mark is always period(.).

Note that NLS_LANG must be set before first rust-oracle function execution if required.

Values in Oracle are converted to Rust type as possible as it can. The following table indicates supported conversion.

This conversion is used also to get values from output parameters.

When a rust value is set to an input parameter, its Oracle type is determined by the rust type.

When chrono feature is enabled, the following conversions are added.

• Connection pooling
• Read and write LOB as stream
• REF CURSOR, BOOLEAN
• Autocommit mode
• Scrollable cursors

Rust-oracle itself is under 2-clause BSD-style license.

ODPI-C bundled in rust-oracle is under the terms of:

1. the Universal Permissive License v 1.0 or at your option, any later version; and/or
2. the Apache License v 2.0.