On Wed, Apr 20, 2005 at 07:18:13PM -0400, Michael Styer wrote:
ORA-01008: not all variables bound (DBD: oexec error)
I've attached my test script in case anyone should want to look at it.
I've read somewhere that the 'odescr failed' error may have something to
do with DBD::Oracle being
Michael Styler wrote:
So now I'm really confused. In this thread
(http://www.mail-archive.com/dbi-users@perl.org/msg24109.html)
Charles Jardine suggests that when the variable goes out of scope the
cursor is closed, but you're saying they stay in existence.
and Ron Reidy replied:
Wjile I can
On Thursday, 21 April, 2005 3:38 AM Tim wrote:
On Wed, Apr 20, 2005 at 07:18:13PM -0400, Michael Styer wrote:
ORA-01008: not all variables bound (DBD: oexec error)
I've attached my test script in case anyone should want to look at it.
I've read somewhere that the 'odescr failed' error may
Tim wrote, on 20/04/2005 21:46:
On Wed, Apr 20, 2005 at 03:46:20PM -0400, Michael Styer wrote:
What about this:
http://search.cpan.org/~timb/DBD-Oracle-1.16/Oracle.pm#Binding_Cursors
At the end of the Binding Cursors section it says that cursors need to
be (and can be) closed with code like this:
Charles Jardine said:
I am still convinced that Michael should not need explicitly to
close his cursors. I would be interested to know if tracing shows
his cursors being destroyed in a timely fashion, since I suspect
that something may be maintaining references to the DBI handles for
longer
This is my hash structure:
Veterans Day = {
date= '2005',
type= 'US',
federal = 'true',
active = 'true',
},
Would I just use a placeholder (?) in my statement and pass it in via that?
It will be in a loop as I have quite a few.
Thoughts and suggestions would be
All,
I finally managed to connect to the Access database. I found indeed permissions
issues on the network side. However now I built a query on Access via the SQL
view, ran it, got 0 fetched records but the syntax is correct. I c/p the same
query into my program and I get the following:
Hi all,
Just following instructions in the DBD::Oracle README
file by posting-up a log of the failed make that I
experienced. I note that the README suggested that I
try perl Makefilepl.PL -nob which has allowed the
make to complete successfully.
Solaris 8 Generic_117350-13 on Sun Fire V240
Do you have CC installed? If you have gcc create a symbolic link by ln
-s /path/to/gcc /usr/bin/cc.
That should solve your problem.
Thanks
Hemanth
-Original Message-
From: David Bartlett [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 21, 2005 10:30 AM
To: dbi-users@perl.org
Cc:
Since I don't have libclntsh.so.9.0 in the lib directory I tried to
generate it using genclntsh command. But it throws errors like
./genclntsh
Undefined first referenced
symbol in file
nnfyboot /export/home/oracle/OraHome1/lib/libn9.a(nnfgt.o)
ld: fatal: Symbol referencing errors. No output
Hi all,
I'm running into an interesting problem with a database error that
occurs on one statement handle and seems to affect another handle
despite using eval {...} and RaiseError. Perhaps example code would
be describe the situation:
my $attr = {RaiseError = 1};
my $dbh = DBI-connect
On Thu, 21 Apr 2005 09:36:33 -0400, Robert said:
This is my hash structure:
Veterans Day = {
date= '2005',
type= 'US',
federal = 'true',
active = 'true',
},
Would I just use a placeholder (?) in my statement and pass it in via
that?
It will be in a loop
On Thu, Apr 21, 2005 at 09:36:33AM -0400, Robert wrote:
This is my hash structure:
Veterans Day = {
date= '2005',
type= 'US',
federal = 'true',
active = 'true',
},
Would I just use a placeholder (?) in my statement and pass it in via that?
It will be in
Hi ,
I am facing poblem in connecting a database thru perl program
Here are the details about the packages which i installed in my Windows
machine
C:\perl -v
This is perl, v5.8.6 built for
Hi,
Had a problem doing the make step for the building of DBD::ORACLE 1.48. I then redid the perl Makefile.PL step using the -nob option, as suggested in the readme. That seemed to solve my problem. The readme mentioned if I had such a problem and solution to send log of the make and the perl
On 4/21/05, Robert [EMAIL PROTECTED] wrote:
This is my hash structure:
Veterans Day = {
date= '2005',
type= 'US',
federal = 'true',
active = 'true',
},
Would I just use a placeholder (?) in my statement and pass it in via that?
It will be in a loop as I
Michael Styer wrote, on 21/04/2005 13:17:
Charles Jardine said:
I am still convinced that Michael should not need explicitly to
close his cursors. I would be interested to know if tracing shows
his cursors being destroyed in a timely fashion, since I suspect
that something may be maintaining
This was a solution:
my $insert_stmt = Insert into TABLE (name, date, type, federal, active)
values( :name, :date, :type, :federal, :active );
my $sth = $dbh-prepare( $insert_stmt );
my $holidays;
foreach my $name ( keys %holidays ) {
$sth-bind_param( ':name', $name );
On Thu, 21 Apr 2005 18:12:08 +0100, Charles Jardine [EMAIL PROTECTED]
said:
I am sure that Oracle can close the cursors automatically in Oracle
9.2..6. I would be very grateful if you could find out for me if the
same is true in your Oracle 8i database.
Could you please run the following
Ok Guys,
I was able to resove the issue. Two packages were not installed
properly. SUNWsprot and SUNWsra.
Here is a list of packages that have to be present on the Solaris box
for the installation of Oracle client and DBD module to succeed.
for tools (sccs, lex, yacc, make, nm, truss, ld,
If I understand your question, it seems like you would want to do:
$sth = $dbh-prepare(q{
insert into tab (date,type,federal,active) values (?,?,?,?); });
Then in a loop:
$dref = $hash{$d}; # $d has Veterans day in one iteration
$sth-execute($dref-date,$dref-type,$dref-federal,$dref-active);
David,
Your solution is similar to mine. But I like your use of the hash slice
better. I keep forgetting about those darn slices.
-Original Message-
From: David [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 21, 2005 6:53 AM
To: dbi-users@perl.org
Subject: Re: inserting data coming
On 04/21/2005 06:46 AM, [EMAIL PROTECTED] said:
I am facing poblem in connecting a database thru perl program
Here are the details about the packages which i installed in my Windows
machine
...
ppm describe dbd-oracle
===
Name:
On 04/21/2005 10:11 AM, Robert said:
This was a solution:
my $insert_stmt = Insert into TABLE (name, date, type, federal, active)
values( :name, :date, :type, :federal, :active );
my $sth = $dbh-prepare( $insert_stmt );
my $holidays;
foreach my $name ( keys %holidays ) {
$sth-bind_param(
I added some triggers to an existing SQL Server database. I noticed in
testing the triggers using their ad hoc query tool that inserting a row
(thus triggering other insertions) would print out:
(0 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
OK, that was
25 matches
Mail list logo