Date sent: Mon, 5 Mar 2001 10:04:44 -0800 (PST)
From: Luis Colon <[EMAIL PROTECTED]>
Subject:Re: (Fwd) "Can't call method execute" error "undefined value"
To: Bodo Eing <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Hi Luis,
meanwhile th
yes i believe this type of application can be done using DBI and oracle..
will this application be running on the WEB? I've done previous applications
that maintains an oracle database through the web. I dont know a good site
that shows a demo of this exact application but the DBI documentation
Hi, all
I have a question about how to connect from perl-CGI program on a WEB server
to a DB2 on another server.
I really use a DBD::DB2 module to develop some program to a local DB2 in a
same BOX(machine).
However, I have no Idea which I should use DBD::? on a separate server
environment, what s
This is explained very well in the DBD::Oracle documentation, complete with
examples. If you installed DBD::Oracle, you have this documentation. Just
type 'man DBD::Oracle'. Otherwise, you can download it form www.cpan.org.
Mark
- Original Message -
From: "I.Salís - Listín.com" <[EMAIL
On Mon, Mar 05, 2001 at 10:04:44AM -0800, Luis Colon wrote:
> $dbh =
> DBI->connect("DBI:Oracle:host=$host;sid=$sid;port=1521",$user,
> $password) or die "Can't connect:$DBI::errstr\n";
>
> $deviationid = time();
> $statement = "INSERT INTO CGTI_AR VALUES
>
>($deviationid,$formdata{'Requestor_N
I think the problem is that the connect method failed. Use the double
pipe || version of the 'or' operator instead of the word 'or' here:
$dbh= DBI->connect("DBI:Oracle:host=$host;sid=$sid;port=1521",$user,
$password)
--> || die "Can't connect:$DBI::errstr\n";
(If you use 'or' perl is a
Could someone please help. I am still having this problem and dont know how to
resolve it.
I am having a problem building DBD-Oracle-1.06 on a linux 6.2 system
I am using perl 5.00503 and DBI 1.14.
I hang in the make test with:
csr reassigned (forces destruction)...
Fetch list of tables:
Fetc
Hi all,
I am tasked to design a database so people can open a ticket, modify/close
as need. Does someone ever do this with DBI and Oracle database? Is there
any good resource I can go for demo?
Thanks,
David
> "David" == Nguyen, David M <[EMAIL PROTECTED]> writes:
David> I am tasked to design a database so people can open a ticket,
David> modify/close as need. Does someone ever do this with DBI and
David> Oracle database? Is there any good resource I can go for demo?
It's almost certain that s
Hi Ronald. As I said, the DBD::DB2 version has nothing to do with your
problem so I don't understand what kind of a map you're requesting. The
version that the message is referring to is the DB2 client version not the
DBD::DB2 version. DBD::DB2 works with any DB2 client from v5.2 onward.
Regar
On Mon, 5 Mar 2001, Luis Colon wrote:
> my $sth = $dbh->prepare($statement);
You need to make sure that this call is successful. I would also use
placeholders:
$statement = qq(INSERT INTO CGTI_AR VALUES(?,?,?,?));
my $sth = $dbh->prepare($statement) or die "error preparing statement
I wrote:
>> Then you can grab the matching businesses by joining against this
>>
>> table:
>> | SELECT bi.*
>> | FROM bus_info bi, bus_search_words bsw
>> | WHERE bsw.bus_id = bi.bus_id
>> | AND bsw.search_word = 'target'
>>
>> Variations on this (probably adding DISTINCT or GROUP BY w
Hi there.
My question is very easy.
How can i execute a Oracle Function (into ORacle package body) from perl
code (Cgi), and catch the return code after execution that Oracle function?
Ptda: excuseme for my poor english, sorry.
Thank's you very much.
Here is the code in question:
#!/usr/local/bin/perl
use DBI;
&parse;
&connect;
sub parse
{
(parses data code)
}
sub connect
{
$host = "$nameofmyserver";
$sid = "$sid";
$user = "lcolon";
$password = "time2fly";
$|=1;
BEGIN {
$ENV{ORACLE_HOME} = "/apps/oracle/product/8.1.6";
$ENV{EPC_DISABLE
Hi all,
I am tasked to design a database so people can open a ticket, modify/close
as need. Does someone ever do this with DBI and Oracle database? Is there
any good resource I can go for demo?
Thanks,
David
Robert,
Thanks for the update. Since I have no control over the mainframe I am going
to have to try an downgrade my client side. The mainframe is running DB2/MVS
5.1, my client is UDB DB2 V7.1.
Is there any client libraries for anything that will let me compile DBD::DB2
so I could access the da
Luis,
On Mon, Mar 05, 2001 at 04:30:56PM +, Tim Bunce wrote:
> - Forwarded message from Luis Colon <[EMAIL PROTECTED]> -
>
> Date: Mon, 5 Mar 2001 07:44:29 -0800 (PST)
> From: Luis Colon <[EMAIL PROTECTED]>
> Subject: "Can't call method execute" error "undefined value"
> To: [EMAIL P
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Mar 05, 2001 at 11:21:35AM +, Barry Jeapes wrote:
> Im in the very early stages of developing an intranet website where I
> have scope to
> choose which DBMS software I want to install and use.
>
> Since this is a new area of web developm
Date sent: Mon, 5 Mar 2001 16:30:56 +
From: Tim Bunce <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Subject:(Fwd) "Can't call method execute" error "undefined value"
Organization:
- Forwarded message from Luis Colon <[EMAIL PROTECTED]> -
Date: Mon, 5 Mar 2001 07:44:29 -0800 (PST)
From: Luis Colon <[EMAIL PROTECTED]>
Subject: "Can't call method execute" error "undefined value"
To: [EMAIL PROTECTED]
Please assist:
I'm trying to create an interactive HTML that will
P
That is it. It worked once I set my proxy env variable.
Thanks a lot.
-V Prabhakar
-Original Message-
From: Steve Howard [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 8:09 PM
To: Prabhakar, V; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: DBI install help
It sounds like
With the help of many of you, I've been able to get this far. I have had
difficulty installing the DBD::Oracle module on the following system for the
past couple months. I believe that my problem was with Oracle 8.1.7 because
I have just gotten much further when I tried it with 8.1.6.
My system
Hi Ronald, the message is correct. It has nothing to do with the DBD::DB2
version, it is strictly referring to your DB2 client version vis-a-vis the
DB2 server version. If they are too far removed then they are not
compatible. Please follow the instructions in the full help text for the
error
To piggy back on what Steve said, I would add, where is the current
level of DB experience in the organization. If everyone is familiar w/
Sybase and you have a Sybase DBA then why would you use Oracle? The
point is unless your requirements are specialized, each DB has pluses
and minuses, you sh
On Mon, 5 Mar 2001 15:17:39 +0100, "Peter J . Holzer" <[EMAIL PROTECTED]> wrote:
>>MySQL has transactions in the latest versions. It also has (and always
>>had) BLOBS but is rather limited in using them.
If you have BDB berkley table support. Then it supports transactions
Mike(mickalo)Blezi
On Mon, 5 Mar 2001, Simon Oliver wrote:
> > Consider
> > * MySQL(www.mysql.com)
> > * PostgreSQL(postgresql.readysetnet.com)
> >
> And make yourself aware of their limitations such as lack of
> transactions in MySQL, blobs, tuple size, etc.
I think as of the upcoming 7.1 release of PostgreSQ
Lars,
I have built several Oracle objects and thoroughly tested them with DBI. So I
am sure that the Perl DBI mechanism works with them. However the biggest issue
that I have with Oracle objects is data integrity. Column level nullability is
not a guarantee that the object is fully populated.
On 2001-03-05 14:16:03 +, Simon Oliver wrote:
> Hardy Merrill wrote:
>
> > Consider
> > * MySQL(www.mysql.com)
> > * PostgreSQL(postgresql.readysetnet.com)
> >
> And make yourself aware of their limitations such as lack of
> transactions in MySQL, blobs, tuple size, etc.
MySQL has tran
Hardy Merrill wrote:
> Consider
> * MySQL(www.mysql.com)
> * PostgreSQL(postgresql.readysetnet.com)
>
And make yourself aware of their limitations such as lack of
transactions in MySQL, blobs, tuple size, etc.
--
Simon Oliver
Consider
* MySQL(www.mysql.com)
* PostgreSQL(postgresql.readysetnet.com)
Joe Chernysh [[EMAIL PROTECTED]] wrote:
> Barry,
>
> Technologically, Oracle would be a good choice.
> It is pretty costly, though.
>
> Joe.
>
>
> > -Original Message-
> > From: Barry Jeapes [mailto:[EMAIL PR
Barry,
Technologically, Oracle would be a good choice.
It is pretty costly, though.
Joe.
> -Original Message-
> From: Barry Jeapes [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 6:22 AM
> To: [EMAIL PROTECTED]
> Subject: Can you recomend a DBMS?
>
>
> Hi All,
>
> Im in th
It depends on everything from the size of the database(s) you plan to need
on the backend of your web-site to the size of your budget, and what OS you
will be using for your database server. There is no one right answer for
this. Consider how critical your data is, what you can afford whether or n
Did you read
"3.7 What database do you recommend me using?" in DBI::FAQ?
> perldoc DBI::FAQ
or
DBI::FAQ
http://dbi.symbolstone.org/doc/faq.html
==
Kawai, Takanori(Hippo2000)
Mail: [EMAIL PROTECTED] [EMAIL PROTECTED]
http://member.nifty.ne
Hi'
We are considering using Oracle 8 objects in our Oracle DB (vers. 8.1.7).
My question is simple: Is Oracle 8 objects supported in DBI / DBD::Oracle ? Which
versions ?
-- Lars S. Eskildsen (M.Sc.) - Software Developer
-- Stibo Directory Solutions - ADVICE
-- e-mail: MAILTO:[EMAIL PROTECTED
if you are going to use Solaris - when the best solution for you is ORACLE !
[EMAIL PROTECTED] wrote:
> From: Barry Jeapes <[EMAIL PROTECTED]>@swindon.ericsson.se
> on 03/05/2001 11:21 AM GMT
>
> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> cc:
> Subject: Can you recomend a DBMS?
>
> H
Hi All,
Im in the very early stages of developing an intranet website where I
have scope to
choose which DBMS software I want to install and use.
Since this is a new area of web development for me I have little/no
experience of which DBMS' are good and bad. Of course I could just try
a few, but
36 matches
Mail list logo
