If you expect to do this more than once, you should use placeholders. See
below.
I recommend you not use $a and $b outside the comparison block for sort(),
they cause the Perl compiler stage to act in special ways throughout the
code if they are found anywhere.
--
Mac :})
** I normally forward
On Fri, Mar 30, 2001 at 10:02:14AM -0500, Ondercin, Boris wrote:
Is the workaround setting $dbh-{RaiseError}=0 ?
Don't use local() on handle attribute. Reset the attribute value
explicitly at the end of the block and in any exception handlers that
may catch exceptions thrown from within the
My oracle data base and perl DBI are on the same unix host.But when i
tried to connect using $dbhandle =
DBI-connect('dbi:Oracle:SHIPDB','userid','passwd');
I get error as DBI-connect(SHIPDB) failed: ORA-12541: TNS:no listener
(DBD ERROR: OCIServerAttach) at testoracle.pl line 15A)
I know that
It gives me great pleasure to announce the arrival of DBI 1.15:
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.15.tar.gz
size: 192879 bytes
md5: b1e37f03bdbd91451102e1b8e4b093d4
Should reach a CPAN near you in the next day or three.
Changes in DBI 1.15,28th March 2001
Added
DBI::ProxyServer installs automaticall with DBI. So on the windows machine
you must install ActiveState Perl 5.6 www.activestate.com
and then in command prompt say
ppm install DBI
That will install the DBI and DBI::ProxyServer
Ilya Sterin
-Original Message-
From: Vasquez, Mike
To:
Do you have the Oracle client installed on the machine where you are
connecting from?
Also look at your connect statement, since after you resolve you problem it
will probably fail on the connect anyways. Run perldoc DBD::Oracle and see
the connection parameters. You must also include SID.
Yes, the Oracle Client (and all SQL*Net software) is installed. SQLPlus can
connect just fine, as can any ColdFusion (cfm) application using ODBC.
Ah, I knew SID had to be included, sorry for leaving it off. But as you can see
the execution is not even getting that far because the connection
Anthony,
Which DBD::Oracle package did you install and which version of Oracle are
you connecting to? There are two Win32 packages for Oracle, DBD-Oracle and
DBD-Oracle8. I had a similar problem when I installed DBD-Oracle instead of
DBD-Oracle8.
--
Dave Davisson
[EMAIL PROTECTED]
-
c:ppm install DBD::Oracle
It pulled the most recent version (I assume) from ActiveState ppm archive. I am
connecting (or more precisely attempting to connect to) Oracle 7.3 (which is on
a Unix system). The webserver is IIS on NT.
"David M. Davisson" wrote:
Anthony,
Which DBD::Oracle
IUSR_systems name
is the internet user alias for IIS.
alias is my word, that may not be the accepted term
so, IUSR_foo may need access to that directory.
Not sure what your doing, but that sounds like a symptom of the error msg.
good luck :(
keep your ears attached,
don't do the vangogh thing,
Is cl.exe on the system path?
Where is it installed? (there have been reports of problems when it is
installed under directories with spaces in the directory names)
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a
Try setting ORACLE_HOME and ORACLE_SID, clearing TWO_TASK, and using
'dbi:Oracle:' for the connect string and see if that helps.
--
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
Most Perl modules have to be able to compile on a wide variety of C
compilers. As a result, 'unused variables' may occur; they are not normally
a problem.
Make sure your account has at least read and execute permission on all
directories leading up to DBI???.so. You also need to be able to
Hi friends,
I am using perl DBI on my Unix user account which has oracle DB installed on
the same host.
Previously I had an error which said install solaris patch.I read the
README.java and used LD_PRELOAD=/lib/libthread.so.1 and set the env var for
ORACLE-HOME and ORACLE-SID.
But the
I probably should include DBI and DBD::ADO versions too: I'm using DBI 1.15
and DBD::ADO 0.4 revision 1.19. My syntax for calling stored procs is
exactly what's stated in Programming the Perl DBI:
my $sth = $dbh-do("{call ClsAct_getSA('01F')}");
except, of course, that the docs say that passing
On Fri, 30 Mar 2001 16:43:22 +0100, Tim Bunce [EMAIL PROTECTED] wrote:
Was wonder if a new Programming w/DBI book will be coming out that will cover
all these new changes in the near future??
Hope so :)
It gives me great pleasure to announce the arrival of DBI 1.15:
file:
I found out the problem, It was an incorectly installed Visual Studio.
Thanks for your help.
Matt
- Original Message -
From: "Michael A. Chase" [EMAIL PROTECTED]
Date: Friday, March 30, 2001 5:28 pm
Subject: Re: Help with DBD::Oracle install
Is cl.exe on the system path?
Where is
I am attempting to insert a large string of text into a Postgres database.
When reading the Postgres documentation, it seemed that having a column with
type = text would do the job. However, when I tried to do the insert, I hit
the 8k tuple limit.
I then tried to use lo_creat and lo_write
hello,
I'm new in perl dbi. i have a linux RH7 and Oracle 8.1.7.
I want to write a script that runs from a browser.
my first script is only to test the DB connection and works fine if i run it
from the shell.
if i run it from a browser, it does the DBI-available_drivers() but it
does'nt
The problem seems to lie in the fact that I cannot seem to insert a NULL
value into a column as a bind parameter. This same thing works fine
when putting the NULL directly into the prepared INSERT statement. I
have attached a copy of a build I made of DBD-Oracle-1.06, in which I
ran the tests
Hi,
'nmake' cannot find 'cl.exe', Microsoft's C++ Compiler.
you seem to try to compile the whole thing with MS VC++ 6,
make sure you have the PATH environment variable to the 'bin' directory of
MS VC set (there is a batch file usually called VCVARS32.BAT or something
installed by VS setup that
Looks like I need to setup DBI::ProxyServer on the windows machine before I
can do anything. Questions is how to you do it. What do I need on the
win2k server machine. I have read the docs. There is no specifics on
setting up the DBI::ProxyServer.
I must be missing some key understanding of
22 matches
Mail list logo
