Please HELP (F1F1F1)
Any hints/idea/solution will be a real help
Thanks, Raghu
>From: "Raghu Karamel" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: DBD::Oracle blob_read() problems
>Date: Wed, 24 Jul 2002 11:50:17 -0700
>
>Hi,
>
>I am getting the following error when I use the b
Mac wrote:
> How is the input file reaching the various Linux hosts? FTP may be
> 'correcting' the line endings going to some and not to others.
The way we *want* it to work is through Samba. When the Windows box has an
input file ready to go, it'll automagically connect to the Linux machine
On Wed, 24 Jul 2002 22:29:46 EDT [EMAIL PROTECTED] wrote:
> Actually, the input file is written by my own code, on a Windows machine, and
> it's been checked and double-checked so many times it makes me sick.
>
> It's the goings-on under perl that have me wondering.
How is the input file reach
Mac wrote:
> Perl's supposed to be deterministic?! Next thing you'll be telling me that
> there aren't really aliens controlling the government.
Um... Well, that's what they want you to think...
> If you have the values in a file, you can use xdt.pl at
> http://home.ix.netcom.com/~mchase/zi
On Wed, 24 Jul 2002 20:53:36 EDT [EMAIL PROTECTED] wrote:
> Wait, I'm being paranoid. Next thing you know, I'll start claiming that perl
> is non-deterministic, or some such nonsense. Of course, I did once encounter
> a C compiler which created code that could forsee the future (or seemed to
Here is another bug in DBD::ODBC 0.45_4. When I try to insert the legal string "" (or
undef) into table1, I get the error:
DBD::ODBC::st bind_param failed: [Microsoft][ODBC SQL Server Driver]
Invalid precision value (SQL-HY104)
(DBD: _rebind_ph/SQLBindParameter err=-1) a
Andrew Crum wrote:
Oh, yeah, I forgot to mention that these two lines are redundant:
> $dbh->{csv_tables}->{table}->{skip_rows} = 0;
> $dbh->{csv_tables}->{table}->{col_names} = [qw( col1 col2 col3 col4)];
csv_skip_rows is automatically set to 0 if you specify the col_names
parameter so you d
Andrew Crum wrote:
> I would think the actual vs expected indicates an issue with 'csv_eol'
> param but I've burned much time trying various settings.
Yes, the problem is csv_eol and that you aren't setting it to what you
think you are setting it to:
> DBI->connect('dbi:CSV:csv_eol=\n;csv_
Here is a script that exercises another bug in DBD::ODBC 0.45_4. It creates two
tables (table1, table2) and a stored procedure (proc1) that simply inserts a value
into table1. If you execute proc1, and then try to insert a second value into table2,
you get the error:
"DBD::ODBC::st e
Mac wrote:
> It is not a DBI or SQL error if a query doesn't return any rows.
I would hope there's an error IF the requested data is actually in the
database. But...
> Perhaps
> you should treat the empty return value as another error and include the
> search criteria with delimiters in th
On Wed, 24 Jul 2002 17:22:04 -0500 Brad Fike <[EMAIL PROTECTED]> wrote:
> What I'd like to see is a script
that would actually build the
"create table..." statement that I could run on a different dB. Is there a
module that anyone can think
of or some sample code that someone could post th
Which database are you using?
-- Joe
-Original Message-
From: Brad Fike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 3:22 PM
To: [EMAIL PROTECTED]
Subject: Backing up a table. Any ideas, tips?
I am working on a development server right now and am ready to migrate to
the
I am working on a development server right now and am ready to migrate to
the production box.
I have written a script that exports the data stored in tables to xml files
but I'm having trouble scripting
the migrating of the tables themselves. What I'd like to see is a script
that would actually
Can anyone help identify why following code block will fetch only one row
when csv_tables->{skip_rows} is set to 0?
A solution for this will go a long way toward solving a more complex
scenario I'm attempting to help someone with.
I would think the actual vs expected indicates an issue with 'csv
On Tuesday 23 July 2002 08:31 pm, Jeff Zucker wrote:
> Jim Blomo wrote:
> > Is there any work being done to support the use of multiple tables in a
> > single SQL statement?
>
> The join-enabled SQL::Statement has been out all year. It supports
> explicit joins (e.g. FROM x NATURAL LEFT JOIN y, e
I am having a problem with my DBD install when I run my make test I keep
getting unresolved symbol errors although they are in libnjni8.sl. Below is
a particle screen dump of my make test.
/usr/lib/dld.sl: Unresolved symbol: mgmt_new_row (code) from
/home/oracle/product/lib//libnjni8.sl
/usr/li
Jeff,
It worked! I reran the coltest.pl script (which worked this morning) and the
inttest.pl script with much better results. I also reran 'nmake test TEST_VERBOSE=1'
and attached the new results as well.
Thanks again.
-Jim
D:\Webroot\cgi-bin\tempdir>coltest.pl
Getting column info for: MyDSN,
Yes, that works for me too. But if the stored procedure executes an INSERT statement
before returning a value via SELECT, then the fetchrow_array fails. Try the following
script with/without the INSERT statement:
#!perl -w
use strict;
use DBI;
# Connect to the database, and create a table an
On Wed, 24 Jul 2002 16:28:22 -0400 [EMAIL PROTECTED] wrote:
> In the simplified example I sent to the list, the error messages are
> more detailed, but the fact that I don't get them at ALL is main symptom
> of the problem. $DBI::err is always zero throughout that routine,
> whether it works or
Mac wrote:
> What he said. 'use strict;' near the top of the script is
> also very useful for keeping small problems from growing
> larger.
Already in there. The one file that get_media_seq sits in is about 14 pages long,
when printed, so I didn't want to type all of it in. [grin] The whole
Having installed DBD::ODBC 0.45_4 and creating the procedure:
Create procedure joe as DECLARE @resultint;SET @result = 1; select @result;
and executing:
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI->connect('dbi:ODBC:mydsn', 'Martin_Evans', 'easysoft') ||
die "failed to connect";
print $DBD::
On Wed, 24 Jul 2002 11:32:31 -0700 (PDT) Ajay Kumar <[EMAIL PROTECTED]> wrote:
> any help on emailing from PERL ?
> will appreciate highly.
A little research in Google or CPAN would have saved you from sending a
message to an inappropriate mail list. See also the URL in my signature
for more hi
On Wed, 24 Jul 2002 12:37:56 -0700 Brian McCain <[EMAIL PROTECTED]> wrote:
> Unless you've redefined the "log" function somewhere, this isn't going
> to do
> what you want it to do:
> }
> else {
>log("connect failed");
>return 0;
> }
> Instead, this form of log will gi
Brian McCain wrote, in part:
> Instead, this form of log will give you the natural
> logarithm of the expression passed to it.
Please, pardon my omission. I had to type in that code snippet by hand (instead of
cut & paste) for a couple reasons, which I won't bore you with.
The upshot is that w
Unless you've redefined the "log" function somewhere, this isn't going to do
what you want it to do:
}
else {
log("connect failed");
return 0;
}
Instead, this form of log will give you the natural logarithm of the
expression passed to it.
Try adding "-w" to the shebang l
A little help, please.
I "inherited" a project a little while ago, and thus have been forcibly initiated into
perl and DBI with code that I did not originally author, but must maintain and upgrade
(so please forgive anything obviously naive, perlwise - but I have been programming
for decades i
I can see where it might get confusing with connection pooling and caching.
See the t\09multi.t and some of the other multiple statements per prepare
samples in mytest\*.pl.
You should be able to:
- insert into foo (etc); select @@Identify in the same prepare statement
- use the
Hi,
I am getting the following error when I use the blob_read() function. Does
anyone know what is the solution for this?
I don't want to use the "LongReadLen" attribute to specify the maximum size
since I don't know how big this field can grow.
Error
-
DBD::Oracle::st blob_read failed:
Mail::Sender works fine:
use Mail::Sender;
$sender = new Mail::Sender
{smtp => 'mail.yourdomain.com', from => '[EMAIL PROTECTED]'};
$sender->MailFile({to => '[EMAIL PROTECTED]',
subject => 'Here is the file',
msg => "I'm sending you the list you wanted.",
file => 'filename.txt'});
Foun
Ajay Kumar wrote:
> Hello all,
>
> After learning basic perl programming, i learnt
> DBI, LDAP by getting some help from this
> user group. It was always been helpfull for me.
> So, though this is DBI group, i thought
> to catch u guys again for something more.
>
> after getting user verifide fro
Hello all,
After learning basic perl programming, i learnt
DBI, LDAP by getting some help from this
user group. It was always been helpfull for me.
So, though this is DBI group, i thought
to catch u guys again for something more.
after getting user verifide from LDAP, i need to
inform all dev
Unfortunately your suggestion doesn't work, because in SQL Server functions cannot
contain INSERT/UPDATE statements.
Returning a result from a stored procedure via SELECT worked in versions 0.28 and
0.43, but it stopped working in 0.45_4, apparently due to the ODBC 3.0 API. So I
still need a
Parwe, Anand wrote:
>
> Is it possible to install DBI module on solaris box without using "make"
> utility.
You can compile and make it on another solaris box and then just copy
into into place on the target box.
OR you might be able to get a pre-built binary from someone else.
OR if neithe
Christian Schneider wrote:
> I have a module that is holding one data base handle (I don't expect
> much traffic). All statements should be constructed from that one
> handle. I insert a value for an identity field and then use
> $sth->prepare("SELECT @@IDENTITY"); $sth->execute(); Should I exp
Hi,
Is it possible to install DBI module on solaris box without using "make"
utility.
thanks & regards
Anand
>
> --
> -
>
> Fidelity Investments Limited, Fidelity I
Hi all,
I'm using the DBI over mod_perl (2.0) with MS SQL Server 2000 via DBD::ODBC.
When I want to get the last inserted value of a field with the identity
flag set, I gather I have to use the variable (or function, don't know)
@@identity. According to the documentation I have at hand that re
Hi Thomas...
Geographic proximity is a poor excuse, IMHO. If you have a non-root account
on the machine, you should be able to install DBD::Oracle and DBD::Proxy.
You may have to ask for a hole in a firewall, but that shouldn't be a huge
obstacle since they're already prepared to allow you to co
I think you'll need to provide details (simple scenario, exact error msgs,
proof that yetc) before anyone can provide help.
Suggested details: simple code that causes problem,
actual evidence/msgs associated with problem,
'perl -V' output
I can understand option #1 being unavailable.
Why can't you install DBD::Proxy and DBD::Oracle on the Oracle server
itself? Then you only need to install DBD::Proxy on your 32 bit PA-RISC
machine.
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original
Hi,
can someone help me to understand what happens with my DBD::CSV on
Solaris. How can I check if the instalation of drivers and modules are
correct. The test.pl is fine but if I run a script on Solaris doesn't
work and on my machine, Windows, works fine. It failed when it's start
to use SQL sta
Hi,
> Check the archives, but in a nutshell it can't be done. Two oprions
> 1. Install the oracle client, (Client is free after all)
I'm using HP/UX on a PA-RISC 32bits. There are no available version of
Oracle for this architecture (only for 64 bits PA-RISC).
> 2. Install the DBD::Proxy module
Hi,
I'm currently trying to compile the DBD::Oracle driver on a HP/UX platform.
I want to access a distant Oracle database, and Oracle is not installed on
my local machine. And the compilation of this driver seems to require Oracle
installed on the local machine.
Do you have any advices/links or
John,
try
select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, NULLABLE
from USER_TAB_COLUMNS
where TABLE_NAME='';
You have to execute the statement and fetch the result set like any other
select
statement.
This is a table of the oracle data dictionary. It contains all col
Hi,
Figured this out myself eventually...
I got it to work by getting rid of all the quoting, and specifying a
different Escape character - not sure why I hadn't thought of that
earlier !
$sth2 = $dbh->prepare("UPDATE table2 SET Status = 110 WHERE Status <> 110
AND Key LIKE '%~___' ESCAPE '
44 matches
Mail list logo
