MPMinus::Store::Oracle - Oracle
Version 1.51
use MPMinus::Store::Oracle; # Oracle connect my $oracle = new MPMinus::Store::Oracle ( -m => $m, # OPTIONAL -host => '192.168.1.1', -database => 'TEST', -user => 'login', -pass => 'password', -attr => { RaiseError => 0, PrintError => 0, }, ) my $dbh = $oracle->connect; my $pingstat = $oracle->ping if $oracle; # Table select (as array) my @result = $oracle->table($sql, @inargs); # Table select (as hash) my %result = $oracle->tableh($key, $sql, @inargs); # $key - primary index field name # Record (as array) my @result = $oracle->record($sql, @inargs); # Record (as hash) my %result = $oracle->recordh($sql, @inargs); # Fiels (as scalar) my $result = $oracle->field($sql, @inargs); # SQL/PL-SQL my $sth = $oracle->execute($sql, @inargs); ... $sth->finish;
Oracle Database independent interface for MPMinus on MPMinus::Store::DBI based.
See MPMinus::Store::DBI
use MPMinus::Store::Oracle; my $oracle = new MPMinus::Store::Oracle ( -name => 'mylocaldb', -user => 'root', -password => 'password' ); my @table = $oracle->table("select * from tablename where date = ?", "01.01.2000")
Init version
OOP style supported
Module movied to global level
Module movied to MPMinus level
Added in MPMinus poject
General refactoring
MPMinus::Store::DBI, CTK::DBI, Apache::DBI, DBI
Serz Minus (Lepenkov Sergey) http://serzik.ru <minus@mail333.com>
Copyright (C) 1998-2013 D&D Corporation. All Rights Reserved
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
See LICENSE file
LICENSE
To install MPMinus, copy and paste the appropriate command in to your terminal.
cpanm
cpanm MPMinus
CPAN shell
perl -MCPAN -e shell install MPMinus
For more information on module installation, please visit the detailed CPAN module installation guide.