Sponsored Content
Full Discussion: Unix Oracle
Top Forums Shell Programming and Scripting Unix Oracle Post 102358 by buffoonix on Friday 17th of March 2006 08:24:47 AM
Old 03-17-2006
I would assume that the sqlplus utility would return with non-zero return code
which you could catch either through $? or by direct shell logic.
However, I would rather rely on something like Perl's DBI (or DBD::Oracle below)
for anything in Oracle/Unix interaction.
 

9 More Discussions You Might Find Interesting

1. Programming

Oracle 9i on Unix

i am upgrading my Oracle 8i database to 9i that runs on Unix platform. Does this require me to make any changes in Unix so as to run the upgrade successfully? Regards, Gerald. (2 Replies)
Discussion started by: gerald_agoi
2 Replies

2. UNIX for Advanced & Expert Users

Oracle and Unix

Hi I am having trouble with a script to export individual schemas to tape from an oracle database. Basicaly I need to export each shema through a pipe with compression and store each shema name in a file with the relevant tape marker. (3 Replies)
Discussion started by: truma1
3 Replies

3. UNIX for Dummies Questions & Answers

Oracle to MySQL through Unix

Hello All, I'm a complete Unix newbie, and I have been asked to provide a solution for the following opportunity: Currently there is an Oracle database residing on a Unix box that I need to connect to on a regular basis from another Unix box. Upon connecting I need to hit multiple tables and... (6 Replies)
Discussion started by: Z24_2000
6 Replies

4. HP-UX

Restore of oracle 8i from hp unix 11.0 to HP unix 11i

Hi, We are planning to migrate oracle 8.1.7.2 (8i) currently installed on a host with HP unix 11.0 to a host with HP Unix 11i. The method we are adopting is backup and restore of all file systems. Could this be a problem, apart from linking libraries on the target system. Thanks for the... (1 Reply)
Discussion started by: amitb
1 Replies

5. Shell Programming and Scripting

Unix + Oracle

Hello people, at the moment, I have a database server running HP-UX and Oracle. From time to time, I need to extract data from oracle, and then do some data management (Awk, sed) within unix. At the moment, what I do is to copy the output from my oracle query and then paste into a file on another... (1 Reply)
Discussion started by: Khoomfire
1 Replies

6. UNIX for Dummies Questions & Answers

unix for oracle

Hi unixers, :) Anyone have any links or online tutorials for Shell Scripting with respect to Oracle . Any example of script calling any Oracle procedure or function or passing parameters is highly appreciated. (6 Replies)
Discussion started by: ravi raj kumar
6 Replies

7. UNIX for Advanced & Expert Users

oracle to unix

how can i safely transfer a oracle database to a unix system thanks (1 Reply)
Discussion started by: djbilly
1 Replies

8. Shell Programming and Scripting

unix-oracle

Hallo Friends, My script looks like this: #!/bin/ksh set -x ######################################################################### # # Name: # statistics.ksh # # Details: # Performs a series of queries on the database to analyse application performance; # reports on backlog of... (2 Replies)
Discussion started by: kekanap
2 Replies

9. Programming

Oracle/UNIX

How do you combine the two language. (1 Reply)
Discussion started by: zbest1966
1 Replies
DBIx::Connector::Driver(3pm)				User Contributed Perl Documentation			      DBIx::Connector::Driver(3pm)

Name
       DBIx::Connector::Driver - Database-specific connection interface

Description
       Some of the things that DBIx::Connector does are implemented differently by different drivers, or the official interface provided by the
       DBI may not be implemented for a particular driver. The driver-specific code therefore is encapsulated in this separate driver class.

       Most of the DBI drivers work uniformly, so in most cases the implementation provided here in DBIx::Connector::Driver will work just fine.
       It's only when something is different that a driver subclass needs to be added. In such a case, the subclass's name is the same as the DBI
       driver. For example the driver for DBD::Pg is DBIx::Connector::Driver::Pg and the driver for DBD::mysql is DBIx::Connector::Driver::mysql.

       If you're just a user of DBIx::Connector, you can ignore the driver classes.  DBIx::Connector uses them internally to do its magic, so you
       needn't worry about them.

Interface
       In case you need to implement a driver, here's the interface you can modify.

   Constructor
       "new"

	 my $driver = DBIx::Connector::Driver->new( $driver );

       Constructs and returns a driver object. Each driver class is implemented as a singleton, so the same driver object is always returned for
       the same driver.  The "driver" parameter should be a Perl DBI driver name, such as "Pg" for DBD::Pg or "SQLite" for DBD::SQLite. If a
       subclass has been defined for $driver, then the object will be of that class.  Otherwise it will be an instance of the driver base class.

   Instance Methods
       "ping"

	 $driver->ping($dbh);

       Calls "$dbh->ping". Override if for some reason the DBI driver doesn't do it right.

       "begin_work"

	 $driver->begin_work($dbh);

       Calls "$dbh->begin_work". Override if for some reason the DBI driver doesn't do it right.

       "commit"

	 $driver->commit($dbh);

       Calls "$dbh->commit". Override if for some reason the DBI driver doesn't do it right.

       "rollback"

	 $driver->rollback($dbh);

       Calls "$dbh->rollback". Override if for some reason the DBI driver doesn't do it right.

       "savepoint"

	 $driver->savepoint($dbh, $name);

       A no-op. Override if your database does in fact support savepoints. The driver subclass should create a savepoint with the given $name. See
       the implementations in DBIx::Connector::Driver::Pg and DBIx::Connector::Driver::Oracle for examples.

       "release"

	 $driver->release($dbh, $name);

       A no-op. Override if your database does in fact support savepoints. The driver subclass should release the savepoint with the given $name.
       See the implementations in DBIx::Connector::Driver::Pg and DBIx::Connector::Driver::Oracle for examples.

       "rollback_to"

	 $driver->rollback_to($dbh, $name);

       A no-op. Override if your database does in fact support savepoints. The driver subclass should rollback to the savepoint with the given
       $name. See the implementations in DBIx::Connector::Driver::Pg and DBIx::Connector::Driver::Oracle for examples.

Authors
       This module was written and is maintained by:

       David E. Wheeler <david@kineticode.com>

       It is based on code written by:

       Matt S. Trout <mst@shadowcatsystems.co.uk>
       Peter Rabbitson <rabbit+dbic@rabbit.us>

Copyright and License
       Copyright (c) 2009-2010 David E. Wheeler. Some Rights Reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-06-03					      DBIx::Connector::Driver(3pm)
All times are GMT -4. The time now is 12:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy