racle. 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
unch of stuff
unless 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 <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
permissions of the f
n see or access 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
worked
with gcc.
google suggests this, and it looks familiar (its been years since I had
to deal with this)
http://perldoc.perl.org/perlsolaris.html
http://twiki.org/cgi-bin/view/Codev/SolarisInstallCookbookPerlModules
http://search.cpan.org/~aburlison/Solaris-PerlGcc-1.3/pod/perlgcc.pod
--
john r
connection 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
u have 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
possible 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
e probably different.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
4-X13)
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 p
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
-users-h...@perl.org>
List-Unsubscribe: <mailto:dbi-users-unsubscr...@perl.org>
List-Subscribe: <mailto:dbi-users-subscr...@perl.org>
List-Id:
so, sending a message to that dbi-users-unsubscr...@perl.org address
will likely remove you.
--
john r pierce
uff all working, 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
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
somewh
: 1254-004 The error code from 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
ttp://search.cpan.org/%7Ejesse/perl-5.12.1/README.solaris>
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
ensed product, it is not included with AIX
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
nt thing in spite of the similarities in names.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
t->execute($field1, $field2, $field3, $field4)
or die $st->errstr;
cleaner, easier 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
you should free it before
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 pierce
;t 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
retries the query a reasonable number of times.
--
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
ike 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
t sort of
operation via a single 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 co
On 10/07/10 8:18 AM, Mayank Gupta wrote:
PPM> install dbi
Install package 'dbi?' (y/N): y
Installing package 'dbi'...
Downloading
http://ppm.activestate.com/PPMPackages/5.6/MSWin32-x86-multi-thread/DBI-1.48.tar.gz
...
Error installing package 'dbi': Error reading
http://ppm.activestate.com/PPM
On 09/21/10 2:32 AM, SUNANDA SURYA KUMARI Y (ssuryaku) wrote:
Hi,
I am facing problem with the interfacing of Mysql with perl module . It
is showing me the following output.
"install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
contains:
C:/Perl64/site/lib C:/Perl64/lib
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 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 alre
On 05/18/10 9:41 AM, Charles Jardine wrote:
On 17/05/10 23:05, 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 hac
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
http://www.microsoft.com/sqlserver/2005/en/
On 08/26/10 10:59 AM, Tim Bunce forwarded:
Hope you are doing good. I am a software programmer struggling to solve the
problems in my code.
Pls. find below the summary of my problem
1. I am migrating data from MSSQL to MSSQL DB.
2. I am fetching data from source DB, manipula
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 not
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 co
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 Libra
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 DBI
Tim Bunce wrote:
I am Joe and manage a test team. We use PERL extensively for our test
automation. Recently, there has
been a change in the way we access internet in our company. The new proxy
server does not allow the ppm
package to access the necessary repo to download the missing pa
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.
A
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 dow
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 pr
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 com
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 README.ai
46 matches
Mail list logo