. You do need to have the
oracle client libraries and headers (which you have to get from Oracle).
or you could install the perl from sunfreeware/unix packages or opencsw.
--
john r pierce, recycling bits in santa cruz
I'm confusing this with Pro*C, something else our old stack required.
--
john r pierce, recycling bits in santa cruz
On 6/22/2016 2:05 PM, Bruce Johnson wrote:
On Jun 22, 2016, at 1:34 PM, John R Pierce <pie...@hogranch.com
<mailto:pie...@hogranch.com>> wrote:
if root installed it to /root, no other user can see or access that.
running cpan as root is fine, since that doesn’t affect the
that.
the Oracle user account that wants to run the perl scripts should
instead be the ones to run CPAN. and no way no how you should be doing
Oracle database work while logged on as the unix root user.
--
john r pierce, recycling bits in santa cruz
parameters.
it would also be useful to see the command line you use to successfully
connect to this database at the command prompt.
--
john r pierce, recycling bits in santa cruz
bit version, so only 32 bit
applications using ODBC can read Access .mdb files.
--
john r pierce, recycling bits in santa cruz
ble to compile perl extensions with
GCC, it likely requires jumping through hoops as the compiler options
are /very/ different.
--
john r pierce, recycling bits in santa cruz
the software installed at all.
cc_r is the multithreaded version of the cc command from XLC ... perl is
built with multithreading, so...
--
john r pierce, recycling bits in santa cruz
.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
)
Version: 11.01..0006
Do note, IBM XLC and/or XLCPP are licensed on a named user basis. At my
work, only two of us have licenses to use it.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
list as a
variable when preparing a statement, but apparently I'm not getting
the type correct?
You are not supposed to be able to do that in SQL. parameters can only
be used for data values, not field names or other statement components.
--
john r pierce
On 9/12/2013 3:13 PM, Manimegalai Visvanathan wrote:
export ORACLE_HOME=/app/oracle/client/jdk/jre
that likely should be something more like...
export ORACLE_HOME=/app/oracle/product/11.2.0.3
(Adjust to suit)
--
john r pierce 37N 122W
somewhere
on a hunch) that
this problem isn't with DBI or Perl, but with the OS level UnixODBC
implementation and its configuration. Having never seen or touched an
HP-UX system, I can't offer any more suggestions.
--
john r pierce 37N 122W
somewhere
, you could maybe achieve what you want, but its
almost never optimal as the planner for the 'primary' database has no
way to optimize JOIN operations etc involving other databases.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
-Unsubscribe: mailto:dbi-users-unsubscr...@perl.org
List-Subscribe: mailto:dbi-users-subscr...@perl.org
List-Id: dbi-users.perl.org
so, sending a message to that dbi-users-unsubscr...@perl.org address
will likely remove you.
--
john r pierce 37N 122W
the last command is 127.
you don't have the IBM XLC compiler in your path. this is a commercial
product ($$) and if you have it installed, its default path is generally
/usr/vac/bin or /usr/vacpp/bin
--
john r pierce 37N 122W
somewhere on the middle
://search.cpan.org/%7Ejesse/perl-5.12.1/README.solaris
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
product, it is not included with AIX
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
in spite of the similarities in names.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
you reconnect it or you're probably leaking some memory.
and I still think you should be doing this in a db-do() wrapper, whcih
checks for connection related errors and does the reconnect there.
you're not doing any error checking now.
--
john r pierceN 37, W 122
to read, far less likely to get nailed with SQL
Injection. PLUS we're catching errors.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
and retries the query a reasonable number of times.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
be running into timing issues.
or do exactly that, only with a connection pooler like pgbouncer...
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
On 09/01/11 2:10 AM, Clive Eisen wrote:
What 'simple' piece of sql do the team suggest?
select 1 from systables where tabid =1
why not just SELECT TRUE; ?
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
a schema designed
by a spreadsheet user. It violates the tenets of relational data design.
If the table was properly structured, the required data could be queried
with a single JOIN, albeit not in the exact output form shown.
--
john r pierceN 37, W 122
santa cruz
statement using a SQL JOIN, and do so far more
efficiently than what you show above, as it will reduce round trips to
the database.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
On 04/07/11 3:10 AM, Ganesh KS wrote:
Hi,
when i run the command,
perl D:\Perl\DBI-1.616\DBI-1.616\Makefile.pl
I am getting the attached error. Please can you tell a possible solution.
read the error message, follow the instructions
On 11/22/10 11:58 AM, E R wrote:
Hi,
I have two DBD/Oracle/Oracle.so shared libraries. In one case ldd
reports that libocci is linked in, and in another case libocci doesn't
show up.
wild guess says one was linked statically (eg, libocci.a rather than
libocci.so). static linking embeds a
On 09/14/10 5:35 AM, John Scoles wrote:
Did this ever get tested and entered into the DBD-Oracle release ?
This issue has surfaced at work, so I can probably try testing your
patches some time in the next week or so, possibly on both sparc and
aix/power platforms, but if someone else has
On 09/14/10 6:58 AM, John Scoles wrote:
On 9/14/2010 9:17 AM, John R Pierce wrote:
Sorry, I meant, the make test problems with t/58object on big endian
machines like Sparc, IBM Power
Ok that clears it up a little.
I am not sure if it was fixed yet.
Give the latest trunk version a try
On 08/26/10 10:12 PM, Mahesh y wrote:
John,
Appreciate your quick response and Thank you very much.
Pls, let me know the tools I can use instead of Perl.
Brian suggested SSIS, SQL Server Integration Services, which is in SQL
Server 2005 and 2008
On 08/06/10 1:37 AM, Robert Roggenbuck wrote:
There is a standard method, wich requires just a working Perl
environment and Internet access:
$ perl -MCPAN -e install 'DBI'
on many platforms, you need to install optional C compilers and
associated libraries to build modules that have C
On 08/06/10 2:31 AM, Satish Bora wrote:
Thanks for some quick insights.
Well I had tried this option earlier and now also. Here is what I get. (I have
attached only error or warnings block)
***
Warning: prerequisite ExtUtils::MakeMaker 6.48
On 07/08/10 1:36 AM, Clive Eisen wrote:
On 08/07/2010 11:18, Martin J. Evans wrote:
Scripting Giri wrote:
Hi Team
Need Your help ASAP.I am getting error while installing the PERL DBI
module,as mentioned below
===
[r...@dba /]# cd /usr/bin/
[r...@dba bin]# cd DBI-1.611
[r...@dba
On 07/07/10 8:37 AM, lippel anna wrote:
Hello guys, I am supposed to have the Sybase Open Client library installed in my pc under the
folder OCS-12_0. I started the installation of DBD::Sybase with the download provided
on CPAN and when I run perl Makefile.PL it tells me Unknown Client Library
Bart Lateur wrote:
2) edit the C source of SQLite and replace the fsync() with fflush(),
which ought to be around 100 times faster, but which isn't garanteed to
withstand computer crashes, if it goes down before the data is finally
stored on disk - not ideal in the eye of ACID perfectionists.
Victor Churchill wrote:
The line you highlighted tells you that the make command failed
because it could not find a C compiler (cc: not found). This could be
because it's not present on your system, or because it can't be found
in your $PATH. The C compiler exists because it is detailed lower
I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM
AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL
C v11.1 + the latest PTF.
to build DBD-Oracle, i had to hack the makefile slightly to remove a
bogus -q32 from the LD commands, this per the
John R Pierce wrote:
I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for
IBM AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using
IBM XL C v11.1 + the latest PTF.
to build DBD-Oracle, i had to hack the makefile slightly to remove a
bogus -q32 from the LD commands
John R Pierce wrote:
ugh, the make test output came out unreadable, lets try again...
dang. one last time, and if this fails, I dunno whats going on, I'm
copy/pasting this from my ssh session into this email.
the important part is ...
t/58object.t 1/51 DBD::Oracle::db prepare
40 matches
Mail list logo