Hello all,
exist a better error description for DBI errors? I have quite complex
datastructure, I'm saving it to DB, using ODBC and MS SQL 2000. I get
only:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid charact
er value for cast specification (SQL-22018)(DBD:
On Fri, May 13, 2005 at 03:53:07PM -0700, Hilmar Lapp wrote:
As another episode of the DBD::Oracle on MacOSX quest, I tried the
Oracle 10g Instant Client for 10.3 on Panther, using DBD::Oracle 1.16
(the latest I believe).
First the good news (and it's primarily good news). The Instant
On Mon, 2005-05-16 at 08:58, Ing. Branislav Gerzo wrote:
Hello all,
exist a better error description for DBI errors? I have quite complex
datastructure, I'm saving it to DB, using ODBC and MS SQL 2000. I get
only:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid
Hello,
I'd like to do something like this:
$sth-prepare(...)
$sth-execute(...)
while (my $hr = $sth-fetchrow_hashref) {
my $oses = get_os( $hr-{id} );
...
}
Function get_os() prepare, execute and return $sth-fetchall_arrayref();
but I'm getting error:
DBD::ODBC::st execute failed:
On Windows XP Pro using Perl 5.8.6, DBI v1.43 and DBD::Oracle v1.06:
I'm encountering a strange fetchrow_hashref error that I can't find any
information about, either in the DBI or DBD::Oracle documentation or via
Google. I have a script that runs in a loop, reading data files (usually
.xls or
On Wed, 2005-04-20 at 12:57, Michael Styer wrote:
Thanks for that. That's definitely the limit I'm running up against. Now
if I could only figure out how to close my cursors...
Why don't you just close them the same way you opened them:
via PL/SQL.
On Mon, 16 May 2005 10:58:39 -0400, Michael Styer [EMAIL PROTECTED]
said:
On Windows XP Pro using Perl 5.8.6, DBI v1.43 and DBD::Oracle v1.06:
DBD::Oracle::st fetchrow_hashref warning: at dataspider.bat line 89,
DATA line 1.
Answered my own question; this is the standard output of DBI when
Hi All,
Can any body help on how we pass by reference n the following context:
Sub callingfunc
{
My $tempvar;
$tempvar-{'name'} = ABCD;
Calledfunc($tempvar);
}
# I need to pass the $ tempVal ; which is a reference to another background
file , where I can access
This list is for discussion of DBI, not perl in general. If you have
general perl questions, please use news://comp.lang.perl.misc or
http://www.perlmonks.org. That said, you can either do
Calledfunc($tempvar-{name});
sub Calledfunc {
my($name)[EMAIL PROTECTED];
}
Or else:
On May 16, 2005, at 2:41 AM, Tim Bunce wrote:
I also edited README.macosx, patch included too.
Great. Applied. Thanks Hilmar!
You're very welcome. (Thanks for creating DBI and DBD::Oracle!)
As another note, the Instant Client instructions from Oracle by default
tell you to copy everything from
On Mon, 2005-05-16 at 15:22, Ing. Branislav Gerzo wrote:
Hello,
I'd like to do something like this:
$sth-prepare(...)
$sth-execute(...)
while (my $hr = $sth-fetchrow_hashref) {
my $oses = get_os( $hr-{id} );
...
}
Function get_os() prepare, execute and return
1) This is way off topic for this list.
2) You can't pass a hash in that way. When you build a system call like
that, everything is semantic. If there are particular keys in that hash
that you want to dereference and pass, you can do that.
Or you can do something like this: (you'll have to
On Mon, May 16, 2005 at 10:23:34AM -0700, Hilmar Lapp wrote:
As another note, the Instant Client instructions from Oracle by default
tell you to copy everything from the individual downloads to a single
destination folder, which ends up having an extremely flat directory
structure (in
On Mon, May 16, 2005 at 11:36:29AM -0400, Michael Styer wrote:
On Mon, 16 May 2005 10:58:39 -0400, Michael Styer [EMAIL PROTECTED]
said:
On Windows XP Pro using Perl 5.8.6, DBI v1.43 and DBD::Oracle v1.06:
DBD::Oracle::st fetchrow_hashref warning: at dataspider.bat line 89,
DATA line
I have compiled DBD-ODBC-1.13 on RedHat Enterprise Linux 4.
Failed 2/9 test scripts, 77.78% okay. 6/137 subtests failed, 95.62% okay.
Good enough for me so I installed it.
I am using unixODBC-2.2.9-. connecting with isql is fine:
$isql mysql1 root
Yet a simple perl script:
Hi,
I am using the DBI to extract some data from the underlying Informix
Database. Even after doing the following when I am printing the value
for $start_date, it is in the format 'dd/mm/' instead of the
expected '/mm/dd'. Can any of you advise as to why this is
happening..??
$sth =
On 2005-05-16, at 12.41, Tim Bunce wrote:
Great. Applied. Thanks Hilmar!
great to hear Instant Client will be supported. when can we expect a
release which would include Instant Client support?
br. aspa
17 matches
Mail list logo