On 2001-03-12 21:38:45 -0700, Peter Loo wrote:
1) $DICEpackage is a store procedure we use internally.
So your package is actually called $DICEpackage? There is no perl
variable of this name which contains the name of the package?
Then this is the problem. Perl replaced $DICEpackage with the
Comments below.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Peter Loo" [EMAIL PROTECTED]
To: "Michael A. Chase"
unsubscribe
Comments below.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Peter Loo" [EMAIL PROTECTED]
To: "Michael A. Chase"
I forgot to mention. You are not checking for errors after the prepare()
calls. Either set $dbh-{RaiseError} to 1 or check after all connect(),
prepare(), execute(), and fetch*() calls or you will get errors after the
real cause and have more trouble tracking down the real cause.
--
Mac :})
**
Checking the DBD::Oracle version:
perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"'
1.06
Tom
--
Thomas A. Lowery[EMAIL PROTECTED]
http://tlowery.hypermart.net
_
Do You Yahoo!?
Get your free @yahoo.com address at
Michael,
Thanks for all your advise. I will give them a try now.
Peter
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 5:23 AM
To: Peter Loo; Loo, Peter # PHX; [EMAIL PROTECTED]
Subject: Re: Stored Procedure (arguments)
Comments
Hi Michael and All,
I am trying to use getopt.pl, however, it give me errors and terminate when
I use 'use strict;'.
aztec:/usr/local/apps/sma/devl/binrunAgg_TAlgnRxTerrSpcltDrugPlan.pl
Loading DB routines from perl5db.pl version 1.0402
Emacs support available.
Enter h or `h h' for help.
Here is the debug status:
devserver:/usr/local/apps/sma/devl/binrunAgg_TAlgnRxTerrSpcltDrugPlan.pl
Loading DB routines from perl5db.pl version 1.0402
Emacs support available.
Enter h or `h h' for help.
main::(sma_run_aggs.pl:28): require "getopt.pl";
DB1 b 121
DB2 c
SCHEMA =
Jim, thanks for your response, I am using the "format"
command as you suggested
right in the statment. and it's working just fine. I did
not have to create any queries.
Thanks, for your help, I'm really glad I have access to
this mailing list, it has helped
me in a couple of occasions
Comments below.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Loo, Peter # PHX" [EMAIL PROTECTED]
To: "'Michael A.
Any value you add to %ENV is added to the environment of the current process
and any called subprocesses. They won't return to the program that called
the Perl script though.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat
On Tue, 13 Mar 2001, Loo, Peter # PHX wrote:
Does anyone know how I can export a variable as I would in Unix.
Export it where and on what OS?
-- Brett
http://www.chapelperilous.net/~bmccoy/
Hey folks. I'm at the depilatory stage on this one. I have two stored
procedures, the first of which is (sort of) getting executed correctly,
and the second of which is dying with a so-far-mystifying error message.
DBD::Oracle 1.0.6
Oracle Server version 8.1.6.3.0
DESCRIBE on the two
So if I were to add an environment to ENV like so:
$ENV{'ENVR'} = "devl";
will I be able to reference the variable $ENVR directly or I must call it as
$ENV{'ENVR'} to get the value?
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 1:39
On Tue, 13 Mar 2001, Loo, Peter # PHX wrote:
Example:
export SOMETHING="A_VALUE"
Right, I understand what exporting variables are. You said 'like in
Unix'. Where are you trying to export variables 'like in Unix'? Sun OS
IS Unix, but if you are using ksh and not bash, you can't do it
Sorry everyone for this interruption. Aaron asked me to try another forum:
All of this has nothing to do with DBI. You should really ask this in
another forum. try perlmonks.com or any other number of lists /irc/website
etc... As far as your question you should go ahead and write the 3 line
Guys,
This was picked up by our Trend Micro virus scanner - not even running in
paranoid mode!
It detects things like mime tag overflows etc. - first one received on this list
though.
Probably not a virus in the attachment - just bad mime tags.
Regards
Chris
Tim Harsch wrote:
OK. Maybe
Hi everybody,
I just started using PostreSQL few days ago and i have a problem. What would
PostgreSQL return for empty table or when the SELECT doesn't find any item
specified in the condition.
$sth-prepare("SELECT * from userInfo where username=$usernameField");
$sth-execute;
Continuing the ongoing saga... I wrote that the "top-n" queries in
Oracle can be handled by using a nested SELECT with an ORDER BY, then
using ROWNUM in the external WHERE clause. But...
I just tried it on our instance and it doesn't work. We are on
Oracle7 Server Release 7.3.4.5.0. Is
unsubscribe
"Dawa" == Dawa Lama [EMAIL PROTECTED] writes:
Dawa What would PostgreSQL return for empty table or when the SELECT
Dawa doesn't find any item specified in the condition.
I'm unfamiliar with the "fetchrow" method.
My preferred method is to use "fetch", which will return an array
reference so
"Brett W. McCoy" wrote:
On Tue, 13 Mar 2001, Loo, Peter # PHX wrote:
Example:
export SOMETHING="A_VALUE"
Right, I understand what exporting variables are. You said 'like in
Unix'. Where are you trying to export variables 'like in Unix'? Sun OS
IS Unix, but if you are
You might also want to use fetchrow_array instead of fetchrow since fetchrow
was replaces by it and is depricated.
Ilya Sterin
-Original Message-
From: Dawa Lama [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 6:05 PM
To: Brett W. McCoy; Loo, Peter # PHX
Cc: dbi-users
Subject:
Yeah, that's right. There's a place in my application where I can check
every argument passed and change them from empty strings to undef where
relevant, but I'd rather avoid that overhead if there's some sort of
PostgreSQL and/or DBI configuration that'll do it for me.
Thanks!
David
On Wed,
Hi All,
Apologies for cross-posting.
I've ported a mod_perl application from Oracle to PosgreSQL, but have run
into a difference that's significant for web work. When I get a form field
submitted, if it's empty, mod_perl assumes it to be an empty string ('').
When I inserted empty strings into
26 matches
Mail list logo