Austin,
I usually call my procedures with begin which would look
like...
my $csr = $dbh->prepare( "BEGIN
checkimages.getfrontpic(:1,:2,:3,:4,:5,:6); END;" ) ;
$csr->bind_param(1,$acctnbr);
$csr->bind_param(2,$checknbr);
$csr->bind_param(3,$seqnbr);
$csr->bind_param_inout(4,\$content_type,20);
$
Hi
I'm having problems with building of the DBI module using ActiveState Perl.
Would like instead to use the "binary" distribution.
Can someone point me to a reliable source to download the latest stable
version.
My configuration is Win2K, ActiveState Perl, Interbase Database.
Another question
Perl 5.6.1
unixODBC-2.0.9
DBD-ODBC-0.28
ODBCHOME=/usr ( installed and functioning )
One major error. One minor error.
Minor error: Note (probably harmless): No library found for
-llibgtkodbcconfig.a ( it is installed in /usr/lib. )
Major error:
[jim@jim DBD-ODBC-0.28]$ make test
PERL_DL_NON
I have a stored procedure that returns a a jpeg file as a blob. When I
invoke this procedure I am receiving the following error:
DBD::Oracle::st execute failed: ORA-06553: PLS-306: wrong number of types of
arguments in call to 'GETFRONTPIC'
Any suggestions as to what is wrong? Perhaps I just hav
Hi,
Im trying to find an older copy of DBD-Oracle.
I need version 0.6. I've searched all over and can't find any versions earlier than
1.06.
If anybody has this module or knows where I can get it, it would help me out much.
Thanks
Sean Porth
System Admin
Tortus Technologies
www.tortus.com
You must use bytea type on postgres side to insert binary data, and bind
your variable as SQL_BINARY.
ALternatively, byte64 or hex encode your binary data.
On Wed, 3 Oct 2001, K Old wrote:
> Hello,
>
> I am trying to load encrypted data (a credit card number encrypted by the
> Crypt::Twofish
We upload jpegs using bind parameters into mysql using the following:
$stmt=replace into mytable (fld1,bfld1) values ('fld1',?);
$sth=$dbh->prepare($stmt);
$sth->execute($var_with_binary_data);
James D. White wrote:
>>7384998737264839
>>
>>when encrypted by Crypt::Twofish would look like
>>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Oct 03, 2001 at 03:06:49PM -0500, K Old wrote:
> I am trying to load encrypted data (a credit card number encrypted by the
> Crypt::Twofish perl library) and postgres won't accept the data. I have
> tried escaping each character, and nothin
I don't know about Postgress, but you could convert the string to hex or
uuencode it, then you have normal printable characters which should be
acceptable, if a bit longer string.
K Old wrote:
> Hello,
>
> I am trying to load encrypted data (a credit card number encrypted by the
> Crypt::Twofish
Hello,
I am trying to load encrypted data (a credit card number encrypted by the
Crypt::Twofish perl library) and postgres won't accept the data. I have
tried escaping each character, and nothing works.
For example a credit card number like
7384998737264839
when encrypted by Crypt::Twofish
Sounds like it is like FreeBSD, which has perl libs installed in
/usr/libdata/perl. DBI probably installed into /usr/local/lib/perl5 or
/usr/lib/perl5. You could upgrade perl to 5.6.1 and install it into
your directory of choice and have a newer version of perl :-)
On 03-Oct-01 Alex Kirk wr
> I vaguely recall that the directory DBI gets installed in changed
> slightly at some point, so you have to manually delete all traces
> of the old DBI, especially the parts in those 'auto' directories
> under the lib directory.
Any idea what typically gets installed? It's kind of hard to weed o
Stephen,
Indeed when I added the line to my script the result was there was no
ORACLE_HOME value. Can you help me determine where it is I need to place
this value in order to recognize it? I've already added the filesystem path
to the following registry settings:
\HKEY_LOCAL_MACHINE\SOFTWARE\O
Folks,
Now that I figured out the data problem, how do I obtain the following
information from DBI?
Thamks.
keith
--
-
Keith Clay, [EMAIL PROTECTED]
Lead Programmer, Web Integration and Programming
286 Adams Center for Teaching Excellence
Abile
> Fra: Mitch Helle-Morrissey [mailto:[EMAIL PROTECTED]]
>
> I couldn't find anything in the archive that answers this question:
>
> Is there a way to get the server name from a database handle
> without parsing
> the $dbh->{Name} attribute? I'd like to keep this code
> database-independent, an
> From: Alex Kirk [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 6:25 PM
> To: [EMAIL PROTECTED]
> Subject: DBI Version Problem
>
>
> Pardon me if this has been covered before; I can't reach the
> archives, and
> I'm the impateint type. ;-)
> For some reason, when I ran my "pe
I couldn't find anything in the archive that answers this question:
Is there a way to get the server name from a database handle without parsing
the $dbh->{Name} attribute? I'd like to keep this code
database-independent, and since the format of the DSN can vary from one db
to the next, I'd like
Is the product column indexed? Without an index the SQL server may be
forced to
According to msdn UPDLOCK "hold(s) locks until the end of the statement
or transaction".
Did you complete the transaction?
Michael Peppler wrote:
>
> Venkataramana Mokkapati writes:
> >
> > select * from catalo
Hi
I have a batch script that performs the following tasks
prepare insert statement for oracle
loop through files in a directory
read each line from the current file using dbd-csv
insert into oracle using dbd-oracle
end loop
This runs fine on Windows 2000, but when I try on NT, after readin
19 matches
Mail list logo
