-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 4:58 PM
To: [EMAIL PROTECTED]
Subject: OLDB - ODBC
Does this belong in the DBI list? Sorry if the answer is yes.
*
Hi,
We have a problem. We run Perl for Window NT. We
Create a dummy table and try :)
José.
-Original Message-
From: Brian Avis [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 2:52 AM
To: dbi-users
Subject: Dropping tables
Can I do this via DBI connecting to a PostgreSQL database?
$dbh-do(DROP TABLE $tablename);
I
This is a little bit Out of Topic but if somebody can give input I will greatly
appreciate!
I know that in Perl OO the name of a method can be a variable.
Which end up with code like this:
my $obj= new MyClass;
#here the thing
$obj-$method();
$method var holding the name of my method.
I would
Is it possible to do something similar with Java ?
José.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 5:39 PM
To: NYIMI Jose (BMB); [EMAIL PROTECTED]
Subject: RE: Perl OO - Dynamic method call
IMHO: This is not bad
Hello,
As far as I know, fetchrow_hashref() return a hashref
with colum_name as keys.
My question is:
Is there a way to say to fetchrow_hashref() to return a hashref
where keys will contain both table_name and colum_name ?
I know that I can use aliases in my sql statement like this :
$sql=
Hello,
As far as I know, fetchrow_hashref() return a hashref
with colum_name as keys.
My question is:
Is there a way to say to fetchrow_hashref() to return a hashref
where keys will contain both table_name and colum_name ?
I know that I can use aliases in my sql statement like this :
$sql=
Hello,
I have a function in our Oracle database (a function, not a procedure).
I would like to execute this function from my perl script using DBI.
I wrote something like this :
my $sql=qq[
BEGIN
OWNER.MY_FUNCTION(?,$action,?,$meta_type);
END;
];
my
PROTECTED]; NYIMI Jose (BMB)
Subject: Re: Execute an Oracle Function (not a Procedure)
On Mon, 18 Nov 2002 15:32:52 +0100 NYIMI Jose (BMB)
[EMAIL PROTECTED] wrote:
I have a function in our Oracle database (a function, not a
procedure). I would like to execute this function from my
perl
I'm trying to install perl modules (DBI actually ...) for windows using
PPM.
My connection is via proxy and I have set HTTP_proxy , HTTP_user and
HTTP_pass variables ...
When I type the ppm command : search *
I got the following messages:
Searching in repository 1 (ActiveState Package
-Original Message-
From: loan tran [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 5:12 PM
To: [EMAIL PROTECTED]
Subject: perl and DB connectivities
Howdy,
Does someone know if there is a function in sybperl
(use Sybase::DBlib) which does exactly the same thing
of: $data
Hello Tim,
I'm very interested by DBI-trace method.
I gave a look in DBI.pm, I can't find the implementation.
Where it is ?
What is the meaning of this line:
'trace' = { U =[1,3,'[$trace_level, [$filename]]'], O=0x04 },
Thanks in advance for your help.
José.
-Original
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:26 PM
To: NYIMI Jose (BMB)
Cc: Tim Bunce; Dolan, Mark; Perl Users Help (E-mail)
Subject: Re: Problem populating execute using @array.
NYIMI Jose (BMB) [[EMAIL PROTECTED
It's in the source archive, DBI-1.30.tar.gz. Extract all the
files and grep for 'trace'. Note that trace() itself is
That is what I did and I thought that I will find some where( not in
lib/DBI/PurePerl.pm file)
a line beginning with:
sub trace{
None
Is that part written in C ?
Yes. There is more to DBI than the Perl sections. There are
also .xs and .c files. Keep looking for 'trace', not 'sub trace'.
Mamamiya ! :-)
Thanks ...
DISCLAIMER
This e-mail and any attachment thereto may contain information which is confidential
and/or protected by
Start look from here : http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/sld024.htm
Index: http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/index.htm
José.
-Original Message-
From: Ildar Gabdulline [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 01, 2002 6:40 PM
To: Matthew O.
To avoid dbh beeing distroyed without disconnection from DB,
change the _init() sub like this
(oups ! Super:: should be SUPER:: I guess :)
sub _init{
my($self,@args) = @_;
ref($self) || croak $self is not an object\n;
#let DBI to make the connection and keep the dbh as
Dear,
A friend recommended me this white paper:
http://www.ambysoft.com/persistenceLayer.html
The Author suggests to implement what he called Robust Persistence Layer between
Business Classes and Storage mecanism (ex Relational Database).
Here an extrait from the white paper:
This approach
(BMB)
Cc: [EMAIL PROTECTED]
Subject: Re: Hard-coding SQL in DBI violates OO encapuslation ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Jul 31, 2002 at 09:25:15AM +0200, NYIMI Jose (BMB) wrote:
Dear,
A friend recommended me this white paper:
http://www.ambysoft.com
Give a look to
http://aspn.activestate.com/ASPN/Reference/Products/ActivePerl/faq/ActivePerl-faq2.html
HTH,
José.
-Original Message-
From: Narayan, Raj [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 6:20 PM
To: [EMAIL PROTECTED]
Subject: RE:DBI MODULE FOR WINDOWS
Hi
Hello,
I would like to write a script (with DBI) that convert my Oracle table to CSV file.
What is the best way.
Is there a module to do that ?
My apologies if the response already in one FAQ list :-).
Thanks,
José.
DISCLAIMER
This e-mail and any attachment thereto may contain
cgi-list or beginners-cgi
At
http://lists.perl.org/
José.
-Original Message-
From: Jonathan Gines [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:21 AM
To: Stephen Keller; [EMAIL PROTECTED]
Subject: RE: DBI works, but CGI + DBI bombs?
Stephen,
I have implemented
perdoc -f system
perdoc -f exec
Or use backtick stuff
$result=`your_unix_command`
José.
-Original Message-
From: Anand Kumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 4:58 AM
To: [EMAIL PROTECTED]
Subject: Unix command in Perl
Hi,
I had to issue a UNIX
Oups!
I meant
perldoc -f system
perldoc -f exec
José.
-Original Message-
From: Anand Kumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 4:58 AM
To: [EMAIL PROTECTED]
Subject: Unix command in Perl
Hi,
I had to issue a UNIX command source DBINST* from a
perl
Hello,
I guess the Object Oriented concept has been used to implement the DBI class
(package).
Is there any UML diagrams ? (which explain for example the relationship (inheritance
?) between differents involved classes)
Thanks,
José.
DISCLAIMER
This e-mail and any attachment
]]
Sent: Wednesday, May 15, 2002 2:18 PM
To: NYIMI Jose (BMB)
Cc: [EMAIL PROTECTED]
Subject: Re: DBI -- DBD -- UML
Try this:
http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/sld046.htm
http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/sld047.htm
Tim.
On Wed, May 15, 2002 at 02:09
http://otn.oracle.com/doc/server.815/a66736/ch63.htm#307
José.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 7:03 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: (Fwd) Do you know how to select * from a.table1@oracle_database1
-Original Message-
From: Dave K [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 2:07 PM
To: [EMAIL PROTECTED]
Subject: Syntax for Driver Specific attributes
Hi All,
I'm trying to use driver specific attributes,
specifically pg_type:
my @tables = $dbh-tables;
-Original Message-
From: Dave K [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 4:16 PM
To: [EMAIL PROTECTED]
Subject: Re: Syntax for Driver Specific attributes
Jose,
Tried that, no good!
Upgraded to DBI 2.01 same result (access violation)
Try upgrading your
While( $array_ref = $sth-fetchrow_arrayref() ) {
#recordset treatement here ...
}
José.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:34 AM
To: [EMAIL PROTECTED]
Subject: How to retrieve multiply recordsets returned by
According to Ilya in one his reply :
Ilya wrote:
[BEGIN]
You need a Visual C++ compiler in order to compile any perl modules for ActiveState
perl, and it's utility is nmake not make. cl is the actual compiler.
You don't have to do it though as you can install binaries already precompiled.
I
1. try this command line:
ldd /home/csc/sps/perl/lib/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.so
It will tell you if you are missing some libraries.
You can also use ldd -s (to see more ...)
2. export LD_LIBRAY_PATH=$ORACLE_HOME:$LD_LIBRAY_PATH
3. If you have changed something from
Hello,
I've found it very handy downloading perl from www.activestate.com as pre-compile
package, ready to be used, you no longer need to (trouble :-)) perl makefile.pl, make,
...and so on. Click and use !
Why DBI can not be downloaded as a pre-compile package, ready to be used on Windows OS
When you run perl Makefile.pl
this create automatically a Makefile in the current directory.
Could you show the content of this Makefile, please?
Jose.
-Original Message-
From: tied [mailto:[EMAIL PROTECTED]]
Sent: woensdag 20 februari 2002 9:30
To: [EMAIL PROTECTED]
Subject: Please help
Hello, I need your help!
I've got the following massage :
Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so
'
for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal:
libclntsh.so.1.0:
open failed: No such file or directory at
Use DBI Proxy Server.
It was designed for those kind of problem.
José.
-Original Message-
From: Justin Derrick [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 29 januari 2002 17:06
To: [EMAIL PROTECTED]
Subject: Re: Accessing a remote DB
I'd be curious to know if any of the DBD modules
Hello,
Is there somebody who can tell me how I can execute
a Stored Procedure with Oraperl ?
I know that is possible to do that with DBI but
I have a constraint to keep Oraperl that I'm using now.
Thanks in advance,
José.
DISCLAIMER
This e-mail and any attachment thereto may
I think you have to try this instead:
$sth=$dbh-do(BEGIN index_reporting.index_report($pass) END;);
or explicitly like this:
$sth=$dbh-prepare(BEGIN index_reporting.index_report(:1) END;);
$sth-bind_param($pass);
$sth-execute();
-Original Message-
From: Stan Brown [mailto:[EMAIL
]]
Sent: zaterdag 18 augustus 2001 18:45
To: NYIMI Jose (BMB); [EMAIL PROTECTED]
Subject: RE: Remote DB Connection
Well if you use DBD::ODBC for which you will have to have third party ODBC
software installed, then just set up a DSN and use that in your connection.
Anyways just see perldoc DBD
How I can connect to a remote Informix database ?
The database from which I would like to extract
data (a simple SQL select ...) is installed on a remote machine(Solaris 8).
The local machine is also a Sun machine using Solaris 8. I don't have
an Informix database installed on this local
39 matches
Mail list logo