Mike,
Look at DBI::Proxyserver. or perldoc dbiproxy.
But in short.
dbiproxy --localport=6969
> -Original Message-
> From: Vasquez, Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 29, 2001 11:06 AM
> To: [EMAIL PROTECTED]
> Subject: RE: :OBDC
>
>
> I'll be using a Linux server
I have played with another technique...
The PL/SQL trigger writes something into an Oracle Pipe (using the DBMS_PIPE
package). I then created a PL/SQL procedure that knows how to read the same
pipe. From a perl script I can call this procedure and check the contents
of the pipe. If there is any
I'll be using a Linux server running the Web Server and the Access DB will
reside on another machine running a win2k server. The Linux box will be the
main web server that currently uses DBD::Oracle to connect to the main
oracle database on a different machine. The access database is a smaller
d
Thanks so much for your reply Steve!
The first link (faqplsql.htm) you sent along seems to be the most promising
when I looked at the example
(http://www.orafaqcom/scripts/c_src/extproc.txt). A couple of the other
links seem outdated (288.htm, 267.htm) and much more clunky to implement.
Another
On Wed, 28 Mar 2001, Dexter Coehlo wrote:
> One other question to educate myself, mod_perl and Fast CGI. Is there
> much change in regualr Perl syntax or is it the same , just a different
> technology? I remeber considering mod_Perl to sustain db connection.
I can't speak for Fast CGI, but wit
On Wed, 28 Mar 2001, Dexter Coehlo wrote:
> The reason for using Perl I thought was because I thougt PHP was like ASP
> which was a technology with some tags to put another language code like
> perl into but I learned it is a language in itself.
I thinking trying to embed PHP and and Perl (via M
Hi Dexter,
> But I believe I heard you can embed Perl into a PHP page. That PHP
> as I thought was a technology like ASPallowing embedding different
> languages within PHP tags.
You may want to consider EmbPerl, which is dynamic Perl embedded within HTML
tags, in a similar manner to JSP and oth
I've recently upgraded from Oracle 7.3.4.4.1 to 8.0.6.2.0 (and DBD
as well). After doing so, I noticed that the following connect
string (which used to work fine) no longer works for remote databases:
$dbh = DBI->connect('dbi:Oracle:@DB','username','password');
but the following still does:
> Just started using DBI.
> I installed DBI & DBD-Oracle8 at home, last Sunday, using PPM on Active
> Perl.
> It connected to my Ora8i test server at home with my first test code.
> Great.
> Dumped out 23,000 ascii flat records in 11 second from a clunker
> Celeron366 server... hmmm, this stuff
Fast CGI is almost exactly like regular cgi only you place the bulk of
your code within a while loop... which blocks for until a request is
made. It's somewhat like daemonizing a cgi script to enhance
performance. mod_perl, on the otherhand gives you direct access to the
Apache API and basically
One other question to educate myself, mod_perl and Fast CGI. Is there
much change in regualr Perl syntax or is it the same , just a different
technology? I remeber considering mod_Perl to sustain db connection.
Dexter
On Wed, 28 Mar 2001, Curt Russell Crandall wrote:
> First of all, I'm no
The reason for using Perl I thought was because I thougt PHP was like ASP
which was a technology with some tags to put another language code like
perl into but I learned it is a language in itself.
Dexter
On Wed, 28 Mar 2001, Curt Russell Crandall wrote:
> First of all, I'm not an expert on
First of all, I'm not an expert on PHP. But, I believe you
cpan has modules like Mason that could give you what you want
w/o messing with PHP. Actually, I'm not real
big on mixing presentation layers with code and you might consider using
mod_perl or FastCGI instead. That being said, why do y
Actually I don't think you can, I can't find maxdatafiles and
maxinstances in any V$ table
Do you know where I can Find think information?
Thanks
Mark
On Fri, Mar 23, 2001 at 10:06:55AM +0100, Mark Vandenbroeck wrote:
> Mark,
>
> Is this really necessary ? All you can find in the con
On Wed, 28 Mar 2001, Alexander Farber (EED) wrote:
> Curt Russell Crandall wrote:
> > No that wasn't the case here. Each select only produces 1 result row.
>
> Are you really sure it was 1 row?
>
That has been verified. It is a small table containing only 7
rows... for now.
> > So, I just
My guess, you are trying to add modules to Sun perl distribution. Do not
add modules to Sun's perl distribution.
1. Build your own perl from source and install it in /opt/perl or your favorite
location.
2. Sun supplied scripts which depend on SUNWpl5u reference /usr/perl5/bin/perl.
Break the link
Hi all,
Is there any way of using the transactions in MySQL through the DBI
interface? I think the DBI driver still does not know about
MySQL's transaction support. The latest version of the MySQL
driver I found is Msql-Mysql-modules-1.2215.tar.gz. Is there a
newer version? Even a beta would be o
Howdy dbi-users,
I know a lot of here use perl, How can if possible can I use Perlin PHP,
I now know PHP is another script language.
But I believe I heard you can embed Perl into a PHP page. That PHP
as I thought was a technology like ASPallowing embedding different
languages within PHP tag
On Wed, Mar 28, 2001 at 10:59:05AM -0500, Peter Seabrook wrote:
> When executing a CGI script with the following connect statement:
> $dbh =
> DBI->connect('DBI:Pg:dbname=shop;host=192.168.100.8;port=5432','postgres',''
> ,{ RaiseError => 1, AutoCommit => 1});
>
> I receive the following error:
Hello All...
I am having problems connecting to my PostgreSQL database using DBI/DBD
Background:
PostgreSQL version 7.0.3
DBI version 1.14
DBD.Pg version .95
Perl version 5.6.0
All of the above running on Redhat 7.0 (i386)
When executing a CGI script with the following connect statement:
$dbh
Ok, I'm down to going through the Makefile.PL to see if I can figure out why
this is failing.
Can anyone tell me if it would help to purchase Pro*C?
Tracy
-Original Message-
From: Roper, Tracy D.
Sent: Tuesday, March 27, 2001 5:18 PM
To: Roper, Tracy D.; '[EMAIL PROTECTED]'
Cc: '[EMAIL
Curt Russell Crandall wrote:
> No that wasn't the case here. Each select only produces 1 result row.
Are you really sure it was 1 row?
> So, I just did a
>
> $sth->execute() or die(...);
> $href = $sth->fetchrow_hashref();
I would try
while ($href = $sth -> fetchrow_hashref)
instead
No that wasn't the case here. Each select only produces 1 result row.
So, I just did a
$sth->execute() or die(...);
$href = $sth->fetchrow_hashref();
In the method... the method is executed in a loop within the caller.
With Sybase, it was necessary to insert a finish after the call to
fetch
Do you have installed GCC before installing Perl ?
-Mensaje original-
De: Neil Jonkers [mailto:[EMAIL PROTECTED]]
Enviado el: Wednesday, March 28, 2001 10:13 AM
Para: Domingo Nicolas Ferrer (Dep. Fisica); [EMAIL PROTECTED]
Asunto: Re: problem compiling DBI in Solaris 8
In the Makefile
In the Makefile there is program=path_to_program
For compiler make sure it's gcc and that gcc is in your PATH.
Hope this help.
- Original Message -
From: "Domingo Nicolas Ferrer (Dep. Fisica)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 2:45 PM
Subject:
Tim Bunce wrote:
>
> > - av_store(av, i, newSViv(ora2sql_type(imp_sth->fbh[i].dbtype)));
> > + av_store(av, i, newSViv(ora2sql_type(imp_sth->fbh+i).dbtype));
>
> Umm, why change from subscript to pointer arithmetic?
>
ora2sql_type needs more then dbtype, so it's called with imp_f
hi everybody !!
i need to install the DBI module on my Sparc-Solaris 8 system. I've read
the README file, and i've followed the steps.
perl Makefile.PL ...OK
but when i do make, tries to compile with cc.
What do i have to change in the Makefile generated to compile with gcc
instead of
[Mailed to individual and to list]
Paul
I have a set of Perl+MySQL tutorials at http://savage.net.au/Perl-tutorials.html
In particular, look at # 24 and # 25.
Cheers
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
On Wed, Mar 28, 2001 at 10:32:44AM +0200, Steffen Goeldner wrote:
> Tim Bunce wrote:
> >
> > If you tell me which you'd like to see and why, and I like what you say,
> > then your word will be my command (eventually:) !
> >
> > Better still (and faster still), send me a patch!
>
> O.k. The patch
Hi Curt,
Curt Russell Crandall wrote:
> I ran into a similar problem with Sybase. I had a statement prepared
> using placeholders (a select statement) and I had to loop several times as
> I processed transactions and each time through the loop I had to execute
> the prepared statement. Perl a
Tim Bunce wrote:
>
> If you tell me which you'd like to see and why, and I like what you say,
> then your word will be my command (eventually:) !
>
> Better still (and faster still), send me a patch!
>
O.k. The patch is tested for OCI7 and OCI8 on WinNT 4.0, Borland 5.02.
The output for the test
31 matches
Mail list logo