RE: Can't call method prepare on an undefined value

2007-01-31 Thread Chong, Wei-Ling
Hi, The error happen on the line to connect to that database: $lda = ora_login('','[EMAIL PROTECTED]','dlbest') If I add or die $ora_errstr on the same line, it returns error below: $lda = ora_login('','[EMAIL PROTECTED]','dlbest') or die $oraerrstr; (UNKNOWN OCI STATUS 1804)

issue in locating Dynaloader

2007-01-31 Thread Tapas Swain
Hi, This is Tapas.I am very new to the perl. I have got an error while connecting to the SQL Server database.I have added Win32::OLE,DBI and DBD::ODBC module.I am getting error can't locate loadable object for module DBi in INC path.I have added Dynaloader , Exporter and Carp

Re: issue in locating Dynaloader

2007-01-31 Thread Ron Savage
On Wed, 31 Jan 2007 10:07:47 +0530, Tapas Swain wrote: Hi Tapas can't locate loadable object for module DBi in INC path.I have Perl is a case-sensitive language. In a program you must say: use DBI; # D, B and I all in upper case. added Dynaloader , Exporter and Carp in INC path.But still

Re: Can't call method prepare on an undefined value

2007-01-31 Thread Alexander Foken
Please delete that script NOW, it is EXTREMLY INSECURE. There are at least THREE ways to compromise the database, the webserver and to send arbitary mails. It lacks all kinds of error checks, as you have seen yourself. The code is written in a way that makes it very hard to detect accidentally

RE: Can't call method prepare on an undefined value

2007-01-31 Thread Reidy, Ron
Chong, You have not left the realm of DBI/perl issues. This is an Oracle issue. From the error docs: $ oerr ora 1804 01804, 0, failure to initialize timezone information // *Cause: The timezone information file was not properly read. // *Action: Please contact Oracle Customer

Help Needed :: urgent

2007-01-31 Thread veera sekar
Hello, I used perl DBI module for my threading concept.but i am getting problem, few things not working because of DBI resource break some time when more connection made on mysql. some block issue happen on my product because DBI. Let me know how to find out DBI resource count and valid DBI

error in locating loadable object in DBI module.

2007-01-31 Thread Tapas Kumar Swain
Hi, I am new to perl. I am using Active state perl for windows XP version5.8.8. I am trying export data from text file to an remote sql server database .I have followed the code given in URL http://www.oreillynet.com/pub/a/databases/2006/12/21/dts-imports.html

Re: installing DBD-Informix on fedora 6

2007-01-31 Thread Oliver Howe
I did have ipv6 switched on, so I tried turning it off but got the same error. I am going to reinstall the fedora server, without ipv6 this time and try it again. On Tue, 30 Jan 2007 17:58:27 -0800 , Jonathan Leffler [EMAIL PROTECTED] wrote: On 1/30/07, Oliver Howe [EMAIL PROTECTED] wrote:

RE: error in locating loadable object in DBI module.

2007-01-31 Thread Reidy, Ron
Did you install the DBI module? Did you really type DBi vs. DBI (it makes a huge difference)? Did you install DBI using ppm? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Tapas Kumar Swain [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 1:27 AM To:

DBD-Oracle-1.19 Installation problem

2007-01-31 Thread David . Livingstone
I'm attempting to load DBD-Oracle-1.19 on a RH ES 4(latest update) proliant system and have an error when running 'make test'. 10gR2(10.2.0.10) is loaded on the server. Any help would be appreciated. Thanks ORACLE_USERID set to dba user : [EMAIL PROTECTED] DBD-Oracle-1.19]# make test

RE: DBD-Oracle-1.19 Installation problem

2007-01-31 Thread Garrett, Philip \(MAN-Corporate\)
Hi David, You can ignore that error. It is just testing that the array execute feature generates the expected warning. Since the test is written against a 9i database, it could be that 10g just doesn't produce that warning. List: has anybody else had this problem installing against 10g? I

DBD::Oracle, cursor_sharing, and ORA-01008

2007-01-31 Thread Andrew McFarlane
I ran into a problem with queries executed on an intranet site. The web server was running with Apache on a Windows XP Pro machine using DBI 1.53 and DBD::Oracle 1.19. The database server was upgraded from Oracle 10.2.0.2 to 10.2.0.3. As soon as the upgrade happened, all of my queries

RE: :Oracle, cursor_sharing, and ORA-01008

2007-01-31 Thread Reidy, Ron
Well, first of all, the poster on that forum did not state any reason why he took that road (did Oracle support suggest this; was there a bug, etc.), so I would take this with a large grain of salt until that route is closed. What version of the Oracle client are you running on your web server?