Run the following lines in both the command line and crontab:
perl -MData::Dumper -e' print Dumper @INC' >~/inc.log
env|sort >~/env.log
The first will have output that looks something like this:
perl -MData::Dumper -e' print Dumper @INC'
$VAR1 = '/usr/lib/perl5/5.8.7/i586-linux-thread-multi';
$
Oscar,
Are there errors in your alert log? The ora-600 is a "generic" message.
It's quite possible oracle generated a trace file that may also help.
Kevin
Oscar Gomez wrote:
i have this error when i made interface program perl with oracle 10g trough
DBD module.
DBD::Oracle::st execute faile
Title: Running DBI, ODBC in the crontab
Hi,
I am running a perl script, using DBI and ODBC (from DataDirect), on a linux box to connect to SQL server. It works fine if I run it from a shell command line.
However, if I put it into a crontab (the same user), I got the following error:
i
Called "Oracle OLE DB"
(http://www.oracle.com/technology/tech/windows/ole_db/index.html), I
think...
on 4/11/06 5:02 PM, Ron Savage at [EMAIL PROTECTED] wrote:
> On Tue, 11 Apr 2006 12:58:23 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
>
> HI Philip
>
>> * DBD::Proxy - requires another syst
On Tue, 11 Apr 2006 12:58:23 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
HI Philip
> * DBD::Proxy - requires another system that DOES have DBD::Oracle
> (or, you could proxy through a Windows server that has an ADO
> driver for Oracle)
I've never heard of an ADO driver for Oracle. What's the
On Tue, 2006-04-11 at 11:09 -0500, Maniace Libi - lmania wrote:
> I have a developer who wants DBD::ORACLE installed on a Solaris server.
> There is not an instance of
>
> Oracle installed on this server. He is certain that it can be installed,
> but I can't find information supporting
>
> this.
Hi all,
I guess I found the source of the problem. The new line chars at the end
was preventing the insertion at middle rows.
Below code works fine.
Regards,
Mehmet Baserdem
#!/usr/bin/perl
use DBI;
use DBD::DB2::Constants;
use DBD::DB2;
@IDS =();
# open file
open(FILE, "data.txt")
You do not need an "Oracle Database" installed.
However, you at least need an Oracle client installed on the same box. This
is the Oracle_home that DBD:Oracle wants.
Cheers
John Scoles
***
The information contained in thi
Baserdem, Mehmet wrote:
> Hi all,
>
> I am trying to insert 16K records into some table through DBI. But my
> script only inserts the last record. I check the array size and the sql
> return values. Everything seems normal. Any ideas?
>
>
> Regards,
>
> Mehmet Baserdem
>
>
>
> Here is the my
No, DBD::Oracle requires the Oracle client libraries to be installed.
There are other options, though, depending on your requirements:
* DBD::Proxy - requires another system that DOES have DBD::Oracle (or,
you could proxy through a Windows server that has an ADO driver for
Oracle)
* DBD::JDBC
Hi all,
I am trying to insert 16K records into some table through DBI. But my
script only inserts the last record. I check the array size and the sql
return values. Everything seems normal. Any ideas?
Regards,
Mehmet Baserdem
Here is the my script:
#!/usr/bin/perl
use DBI;
use DBD::DB2
I have a developer who wants DBD::ORACLE installed on a Solaris server.
There is not an instance of
Oracle installed on this server. He is certain that it can be installed,
but I can't find information supporting
this. It always errors out with wanting "Oracle_home". Is there a way to
install DBD
Mary Anderson wrote:
>
> >Hi All,
> I have picked up ParseExcel and started to work with it. I am having
> a problem with code that essentially looks like this:
>
> for ($iR = 0; ($oWkS->{MaxRows} && $iR <=$oWkS->{MaxRows}, $iR++){
>for ($iC=0; ($oWkS->{MaxCols} && $iC <=$oWkS-
>Hi All,
I have picked up ParseExcel and started to work with it. I am having
a problem with code that essentially looks like this:
for ($iR = 0; ($oWkS->{MaxRows} && $iR <=$oWkS->{MaxRows}, $iR++){
for ($iC=0; ($oWkS->{MaxCols} && $iC <=$oWkS->{MaxRows}, $iC++){
$o
14 matches
Mail list logo