Hi,
Yes, I know about that script - but you should still be careful when you
use a binary built with a 12.5.1 client installation against a 15.0
run-time. It would probably be better to rebuild.
Michael
Extranet
[EMAIL PROTECTED] - 25/04/2006 17:13
To: Michael PEPPLER
cc:
Hello,
I was wondering (and found nothing bout that on the web), can I use DBI to
execute some oracle DB functions?
Here's my case: I have a (oracle) function that returns a new free ROW ID
randomly and I have to manage that RI from a perl script. Can I use DBI to
submit the request to oracle?
Hi Everyone,
i did the following
$dbh-prepare(UPDATE contentTable SET filename = '$dbfile date_modefied =
'CURRENT_DATE()' time_modefied = 'CURRENT_TIME() WHERE ext = '$ext' )
and the value of the current date and current time were not updated on the
table. It seems perl
Akpome Akpoguma [mailto:[EMAIL PROTECTED] wrote:
Hi Everyone,
i did the following
$dbh-prepare(UPDATE contentTable SET filename = '$dbfile date_modefied
= 'CURRENT_DATE()' time_modefied = 'CURRENT_TIME() WHERE ext = '$ext' )
and the value of the current date and current time
Yes one can quite simply at least for a Stored procedure as for a function
you may have to wrap it in some SQL first.
my $db=;
my $db = DBI-connect();
my $desc = 'Comments from user ';
my $desc_out =;
my $sql=begin insert_comment(:p_id ,:p_desc,:p_desc_out); end;;
my $c=$db-prepare($sql)
You want to read
http://search.cpan.org/~pythian/DBD-Oracle-1.17/Oracle.pm#PL/SQL_Examples
Alexander
Riccardo Bonuccelli wrote:
Hello,
I was wondering (and found nothing bout that on the web), can I use DBI to
execute some oracle DB functions?
Here's my case: I have a (oracle) function that
http://search.cpan.org/~pythian/DBD-Oracle-1.17/Oracle.pm#Other_Data_Typ
es
-Original Message-
From: Riccardo Bonuccelli [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006 8:46 AM
To: dbi-users@perl.org
Subject: Oracle functions through DBI?
Hello,
I was wondering (and found
On 4/24/06, Greg Sabino Mullane [EMAIL PROTECTED] wrote:
I've proposed adding something simlilar to DBI itself, but I don't recall
getting
any feedback on it. Presumably once in place DBIx::Class will someday support
it.
DBI is complex enough, and AIUI the DBI philosophy opposes adding
Ron Savage wrote:
On Sun, 16 Apr 2006 22:15:22 +1000, Daniel Kasak wrote:
Hi Daniel
DBI: V 1.47
DBD::mysql: V 3.002
There are critical bugs in the $dbh-column_info() method in
DBD::mysql-3.x that prevent us from upgrading :(
I've tried a line identical to your:
$id = $self - dbh() -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
DBI is complex enough, and AIUI the DBI philosophy opposes adding features
to the core that will cause implementation headaches for driver authors.
The standard perl idiom for default values is
You misunderstand. The DEFAULT is on the database
Any other repositories anyone knows of where I can download this?
ftp.esoftmatic.com and ppm.activestate.com have both been unreachable all
day. Google has been uncharacteristically unhelpful.
tia,
jeff
--
On Thu, 27 Apr 2006 03:45:22 -, Greg Sabino Mullane wrote:
Hi Greg
You misunderstand. The DEFAULT is on the database side, not the
Just curious.
Which database server is this?
And, can you omit the name of the column you want defaulted, and does this
server then insert the default value?
On Wed, 26 Apr 2006 23:55:43 -0400, Jeffrey Seger wrote:
Hi Jeffrey
Any other repositories anyone knows of where I can download this?
I tried a few sites, but can't see Oracle stuff.
As a last resort, try http://dada.perl.it/#ppm
and go round the PerlRing site by site :-(.
--
Ron Savage
Any other repositories anyone knows of where I can download this?
I tried a few sites, but can't see Oracle stuff.
As a last resort, try http://dada.perl.it/#ppm
and go round the PerlRing site by site :-(.
Thanks Ron. I tried the search the ring tool on the perlring and no joy.
Maybe one
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
Which database server is this?
This is definitely the behavior of MySQL, PostgreSQL, and Oracle,
and I'm pretty sure most others follow it as well.
And, can you omit the name of the column
On Thu, 27 Apr 2006 04:37:20 -, Greg Sabino Mullane wrote:
Hi Greg
It's late here, so hope that made sense. :)
Yep. It means just that much more I don't know...
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
16 matches
Mail list logo