Actually neither one is a computer language. I think you probably mean SQLPLUS (Oracle inquiry) and UNIX shell.
Simple example using a UNIX shell here document to call a sqlplus command
for a pretend user, passwd, and Oracle instance. You have to be able to execute the sqlplus command and have a valid oracle account before this will work:
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)
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)
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)
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)
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)
Through a shell script ...
I am invoking sql plus..
Code is as follows...
echo " set feedback off verify off pagesize 0
select column from table " | sqlplus -s/@dbname | read var_col
Now if oracle throws an exception for above select statement ...then how can i catch it ?... (15 Replies)
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)
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
LEARN ABOUT DEBIAN
apache::session::store::oracle
Apache::Session::Store::Oracle(3pm) User Contributed Perl Documentation Apache::Session::Store::Oracle(3pm)NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.10.1 2010-10-18 Apache::Session::Store::Oracle(3pm)