orginally posted on perlmonks http://www.perlmonks.com/?node_id=622139
I've cut-n-pasted it here.
I'm trying to install *DBI-1.57*
Perl 5.8.8
SunOS cofjora01d 5.9 Generic_118558-39 sun4us sparc FJSV,GPUZC-MM
Here is the error...
t/10_units/04_drivers/01_sysrw...ok 1/17
Ya, I saw that, I was just hoping that there was a way to do it without involving
a Win32 box.
My sysadmins downstairs are Sun Solaris bigots and cannot (will not?) tolerate
any kind
of Win32 servers in our production environment.
Bart Lateur wrote:
> On Tue, 25 Jun 2002 08:41:01 -0700, Er
Thanks,
But this is not being done on a Win32 box. Does anybody know how I go about
getting an ODBC driver for Sun Solaris ?
Bart Lateur wrote:
> On Mon, 24 Jun 2002 16:22:38 -0700, Erick Nelson wrote:
>
> >I've just spent the last 15 minutes looking at CPAN for a module
I've just spent the last 15 minutes looking at CPAN for a module to
query a MS Access database.
Which modules do I need to download?
Can someone throw me a hint? :)
ingore the "use ORA;" in my example
Erick Nelson wrote:
> you can if you prepare and use fetchrow_hashref and rows...
>
> use DBI;
> use ORA;
>
> my $dbh = DBI->connect(...connect stuff here...)) || die $DBI::errstr;
> my $sql = "select * from sfile";
you can if you prepare and use fetchrow_hashref and rows...
use DBI;
use ORA;
my $dbh = DBI->connect(...connect stuff here...)) || die $DBI::errstr;
my $sql = "select * from sfile";
my $sth = $dbh->prepare($sql) || die $dbh->errstr;
$sth->execute || die $sth->errstr;
while (my $href = $sth->fet
"HUA, Qing" wrote:
> I am trying to insert using the following statements. Somehow,
> VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me
> ORA-01722: invalid number (DBD ERROR: OCIStmtExecute).
>
> What did I do wrong? Thanks!
>
> $insert = "INSERT INTO test_database (TEST_PRIOR,
No need to finish.
Finish is typically for cleaning up a select cursor when you
break out of fetching rows before the cursor is exhausted.
I'm sure there are other uses for it but that is the main one.
Also, is autocommit on? If not you will need a commit in
there. If you are actually doing 4 mi