Hi Tim and Jeff,
I saw the Perl FAQ that "For AS Perl 5.8 or higher, there is no
officially supported version of DBD-Oracle"., so I wento your ftp
site,
And tried to download it by instructions:
ftp://ftp.esoftmatic.com/outgoing/DBI/DBI.ppd
ftp://ftp.esoftmatic.com/outgoing/DBI/DBD-Oracle.pp
On Fri, 2004-06-11 at 02:14, Jeff Urlwin wrote:
> > I noticed what looks like a typo bug in dbd-odbc 1.09. Line
> > 139 has 8/ instead of */ Is that the same in your version?
>
> Why don't we do this (er, the "royal we"). Can you get subversion and pull
> the latest so we are talking apples and
Hi all!
I'm looking for a Firebird/Interbase DBD under Debian Unstable - I'm not
finding a package. Is there one?
Ron:
I could use the "column_value from table()" approach, but want to manipulate the
vector as a whole for speed... like a BLOB. Same with updating. I read your earlier
post, but want to avoid specifying each element in a comma-separated list.
Thank you for your response, however, I think I
Hi All,
Since we do recieve messages from the dbi-users group, I was wondering would anyone be
interested in taking the Oracle 9i DBA or Developer program with us. If so I can send
further information about our training. Please contact me at 410.594.2265 or via email.
Best Regards
Darrell McCai
Ron,
thank you very much, that sounds great. Slowly it drove me crazy because I
didn't found any documentation how to do this.
Kind regards,
Frank
"Reidy, Ron" <[EMAIL PROTECTED]>
22.06.2004 15:58
An
<[EMAIL PROTECTED]>, "Hardy Merrill" <[EMAIL PROTECTED]>
Kopie
<[EMAIL PROTECTED]>
Thema
Bruce,
My error stack begins with:
Field 1 has an Oracle type (108) which is not explicitly supported
You will need to use strings delimited with ',' to move your data around. You should
look into table functions also.
See my earlier posts.
--
Ron Reidy
Sr. DBA
Array PioPharma, Inc.
---
Goal:
Array operations (equivalent to shift, memcpy or push/pop) are quite CPU-intensive on
the server-side, so I'm trying to load arrays client-side and take advantage of perl's
speed. I get errors when I try to read an "array() of number" into perl.
Versions:
Perl v5.8.0 built for sun4-solar
You will need to populate the table using code similar to this:
Method 1:
my $sql = qq{
DECLARE
v my_tagnames;
BEGIN
};
my $i = 1;
foreach (@arry)
{
$sql .= " v($i) := '$_';\n";
$i++;
}
$sql .= "END;"
$sth->prepare($sql);
etc.
Method 2:
my $arry_str = join(",",@arry);
$sth->prep
On Wed, 2004-06-16 at 19:44, Brian Millett wrote:
> Hi Michael
> I'm trying to compile this on a x86_64 platform running SuSE Enterprise
> Server 8.
> cc -c -I/usr/include -DNO_THREADS -DSYB_LP64
> -I/usr/lib/perl5/site_perl/5.8.1/x86_64-linux-thread-multi/auto/DBI
> -D_REENTRANT -D_GNU_SOURCE
my problem is not the stored procedure call but the handling of the Oracle
type definition in perl.
TYPE my_tagnames IS TABLE OF varchar2(200) INDEX BY BINARY_INTEGER;
It's not clear to me how or even if I can call a stored procedure with
such input values.
Thanks for any help in advance !!!
11 matches
Mail list logo
