12-20-2008
ORACLE_HOME environment variable not set!
hi,
i am new to perl:
os : Linux
i wrote simple perl script to select from table i am getting this error and how to set ORACLE_HOME environment variable :
script:
#!usr/bin/perl
use DBI;
use Mail::Sendmail;
#use Date::Calc;
use MIME::QuotedPrint;
use HTML::Entities;
use POSIX qw(strftime);
$dbhpindb= DBI->connect("dbi:Oracle:host=172.16.1.23;sid=pindb", "pin", "pin") or die "Unable to connect: $DBI::errstr";
$query="select * from prakash";
$sth = $dbhpindb->prepare($query);
$sth->execute() || die "Error in execute";
$sth->finish;
$dbhpindb->disconnect;
error i am getting:
[it@surapp02 DailyMail]$ perl testperl.pl
ORACLE_HOME environment variable not set!
Thanks
Prakash
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
How does the PATH and MANPATH environment variable get set?
I want to add "/opt/SUNWspro/bin" to the search path for all the users. Where can I access this variable.
I know in my home directory, depend on which shell I use, there are files such as .profile and .cshrc which I can edit to... (3 Replies)
Discussion started by: vtran4270
3 Replies
2. UNIX for Advanced & Expert Users
Installed a program, need to set the system up so that when the executable is entered, it finds the path to the executable. In Windows, set under system properties, advanced, environmental variables. How do I do this with Unix? Specifically using Solaris 9. I have tried:
env... (3 Replies)
Discussion started by: kohoutek
3 Replies
3. UNIX for Advanced & Expert Users
hi,
I have one environment variable like path in my system.But in my program i need to change that path .suppose it has a value "config" now i need to chage it as "config1" or something else.i need to use that variable for complete project.It means at first it will use the old path but after... (4 Replies)
Discussion started by: sada@123
4 Replies
4. Shell Programming and Scripting
hi all
i have joined new to the group.
i have set an variable in my bashrc file.
.bashrc
PROGHOME=/home/braf/braf/prog
export PROGHOME
but while using it in my shell script its path is not taken and i had to explicitly give the export command to set the path.
in my script... (8 Replies)
Discussion started by: krithika
8 Replies
5. Linux
Hi,
I am quite new to Linux. And I have doubt how to set new environment variable with value to a C executable.
Let say I have a environment variable $Hack ;
I would like to load a value for this variable; so that when the C executable is executed, the $Hack would set the variable value.
... (4 Replies)
Discussion started by: ahjiefreak
4 Replies
6. Solaris
I am working with solaris 9 sunBlade150 Box.
I Installed a program, need to set the environment variable so that when the executable is entered,it finds the path to the executable.
The documentation for the software says: Set the appropriate environment variable:
Connect to server failed;... (8 Replies)
Discussion started by: smartgupta
8 Replies
7. Shell Programming and Scripting
Hi,
I can run shell script from the command line using
$ . set
If the run the script inside perl script using
$var = system("set");
print $var;
This prints 0.
This command sets up the environment from command line. But when used inside the shell script or perl script it... (2 Replies)
Discussion started by: sandy1028
2 Replies
8. Shell Programming and Scripting
Hi,
i have the following env variable. currently i am exporting variable in the same script file. but i need this is in a text file and the scripts need to export this variable from the text file.
can you please suggest me. is it possible.
export... (6 Replies)
Discussion started by: rsivasan
6 Replies
9. Shell Programming and Scripting
rflow@ucabclg1pp]netech$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory:o
while connecting to database i am getting the above error.
---------- Post updated at 08:49 AM ---------- Previous... (1 Reply)
Discussion started by: susant4u
1 Replies
10. Solaris
Hi all,
In Solaris 10, is there a way to search for the sessions that have a certain environment variable set? (8 Replies)
Discussion started by: ejianu
8 Replies
LEARN ABOUT MOJAVE
dbd::sponge5.18
DBD::Sponge(3) User Contributed Perl Documentation DBD::Sponge(3)
NAME
DBD::Sponge - Create a DBI statement handle from Perl data
SYNOPSIS
my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });
my $sth = $sponge->prepare($statement, {
rows => $data,
NAME => $names,
%attr
}
);
DESCRIPTION
DBD::Sponge is useful for making a Perl data structure accessible through a standard DBI statement handle. This may be useful to DBD module
authors who need to transform data in this way.
METHODS
connect()
my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });
Here's a sample syntax for creating a database handle for the Sponge driver. No username and password are needed.
prepare()
my $sth = $sponge->prepare($statement, {
rows => $data,
NAME => $names,
%attr
}
);
o The $statement here is an arbitrary statement or name you want to provide as identity of your data. If you're using DBI::Profile it
will appear in the profile data.
Generally it's expected that you are preparing a statement handle as if a "select" statement happened.
o $data is a reference to the data you are providing, given as an array of arrays.
o $names is a reference an array of column names for the $data you are providing. The number and order should match the number and
ordering of the $data columns.
o %attr is a hash of other standard DBI attributes that you might pass to a prepare statement.
Currently only NAME, TYPE, and PRECISION are supported.
BUGS
Using this module to prepare INSERT-like statements is not currently documented.
AUTHOR AND COPYRIGHT
This module is Copyright (c) 2003 Tim Bunce
Documentation initially written by Mark Stosberg
The DBD::Sponge module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. In particular
permission is granted to Tim Bunce for distributing this as a part of the DBI.
SEE ALSO
DBI
perl v5.18.2 2013-06-24 DBD::Sponge(3)