$dbh = DBI->connect("dbi:Oracle:ORACLE","scott", "tiger",
Change to
$dbh = DBI->connect("dbi:Oracle:ORACLE",'scott', 'tiger',
--Raju
-Original Message-
From: Kotha, Nagaraju [mailto:[EMAIL PROTECTED]]
Sent: Friday, Ju
Try with set up ORACLE_HOME environment var in your script:
$ENV{ORACLE_HOME} = '/local/oracle/8.1.7/...';
--Raju
-Original Message-
From: Roger Patrick [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 1:23 PM
To: [EMAIL PROTECTED]
Subject: Problem with Oracle DBD on client serv
Hi All,
I am using DBI->connect() method right now, I am trying to change it to
DBI->connect_cached().
Any one have any idea and experience? what is the performance issue? or any memory
leaks?
Please let me know.
Thanks in advance,
Raju
Here is the thing you need to do:
BEGIN
{
$dbh = DBI->connect("connect_sting") or die "$DBI::errstr \n";
$dbh->{LongReadLen}=65000;
$dbh->{LongTruncOk}=1;
}
$sth->bind_param(1,$clob1,{ora_type=>ORA_CLOB, ora_field=>'FIELDNAMEOFCLOB1'});
$sth->bind_p
What is the SQL you are running?
For me looks like you are getting error message in your PL/SQL block.
--Raju
-Original Message-
From: Marius Keraitis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 12:27 AM
To: DBI Perl
Subject: whats da error?
when i trying to select
Here is simple call:
my $sp_sth =
$dbh->prepare(q{begin
my_Pack.my_SP(:in,:out);
end;
});
$sp_sth->bind_param(":in",$p);
$sp_sth->bind_param_inout(":out",\$v_n,3000);
$sp_sth->execute();
--Raju
-Original Message-
From: Tim Har
use prepare_cached() function
--Raju
-Original Message-
From: Kipp, James [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 11:09 AM
To: [EMAIL PROTECTED]
Subject: Inserting Multiple values
Hello
I am quite new to DBI and I am learning from the Perl DBI Book. It does not
cov
May be this link can help you:
http:[EMAIL PROTECTED]/msg00636.html
--Raju
-Original Message-
From: Brad [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 10:22 AM
To: DBI-Users
Subject: Strange DBI Error.. Please help
Howdy,
I installed DBI, DBD, MySQL modules on a sun4u s
Hi,
Go to this page :
http://dbi.symbolstone.org/index.html
There you can find every thing. You need to get DBI and DBD:Oracle.
--Raju
-Original Message-
From: $uren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 10, 2001 10:42 AM
To: [EMAIL PROTECTED]
Subject: Drivers to connec
Oracle string values need sigle quotes 'STRING'.
I think good practice to have all the column names while you are inserting the values
into table.
Insert into emp_table (id, name) values (1234,'$myname')
--Raju
-Original Message-
From: Rozengurtel, Daniel [mailto:[EMAIL PROTECTED]]
S
I think you need to do like this,
$dbh = DBI->connect($connect_str);
$dbh->{LongReadLen}=65000;
$dbh->{LongTruncOk}=1;
That should work, I didn't tried with BLOBs but I used with CLOBs, it's working fine.
Raju
-Original Message-
From: Darren Nickerson [mailto:[
11 matches
Mail list logo
