need a help

2005-09-13 Thread rami doqa
hello , i am a new perl programmer and i work in a nested loops that each lop excutes an sql to get a result ( 1 - M )relationship. but i faced problem: that i must finish the excute the parent sql before continuing fetching the childs results. sql format: --- my

need help to install dbi perl modules

2005-09-13 Thread Radhakrishna, Vasudeva
Hi I am not able to install dbi perl modules in my HP-UX environment. I am attaching all logs, pls look into this and help me with a solution thanks in advance. regards, radhakrishna +hp = everything is possible bash-2.01# perl Makefile.PL *** You are using a perl configured with

prepare failing

2005-09-13 Thread Jain, Abhay K, ALABS
I am new to DBI. I wrote a simple program and I get the following in prepare method. DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD: error possib ly near * indicator at char 8 in 'SELECT *FROM GIGE WHERE CUSTOMER_SITE LIK E '%Middletown%'') What may be going on. Abhay

IBM Informix Client SDK

2005-09-13 Thread Oliver Howe
hi, i'm looking to download the IBM Informix Client SDK for linux (fedora), but i cant get it from http://www.ibm.com/software/data/informix/downloads.html (it is impossible to subscribe at the moment). can anyone point me in the right direction? thanks, oliver -- Oliver Howe Systems

Re: prepare failing

2005-09-13 Thread Jeffrey Seger
Can you post the code that is producing that error? On 9/13/05, Jain, Abhay K, ALABS [EMAIL PROTECTED] wrote: I am new to DBI. I wrote a simple program and I get the following in prepare method. DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD: error possib ly near *

Re: need a help

2005-09-13 Thread James D. White
Three solutions: 1) Save the results of the first select in an array. This solves the problem, unless the initial query results are too large. 2) Open two database handles and let the inner select use the other handle. This also solves the problem without using extra memory but uses an extra

RE: DBD:ORACLE test failing

2005-09-13 Thread Reidy, Ron
Your output shows you are using the Sun C compiler. Which C compiler is installed on your system (command is 'which cc')? Did you build this Perl or did you get one that was already built for your platform? rr -Original Message- From: raja agireddy [mailto:[EMAIL PROTECTED] Sent:

Re: DBD:ORACLE test failing

2005-09-13 Thread raja agireddy
Ron, Following is the output: Summary of my perl5 (revision 5 version 8 subversion 6) configuration: Platform: osname=solaris, osvers=2.9, archname=sun4-solaris uname='sunos cfoifdv1 5.9 generic_118558-02 sun4u sparc sunw,sun-fire-880 '

Re: Recipe to build DBD::Oracle against Instant Client??? [Solved]

2005-09-13 Thread Jay Strauss
Jay Strauss wrote: Hi, Does anyone have a WORKING recipe for building DBD::Oracle against Instant client? I have followed the recipes: ... I'm doing this on linux thanks Jay Hate replying to my own message. You must edit the Makefile.pl to point at YOUR OWN header files. In my case it

Re: need help to install dbi perl modules

2005-09-13 Thread Jonathan Leffler
On 9/13/05, Radhakrishna, Vasudeva [EMAIL PROTECTED] wrote: I am not able to install dbi perl modules in my HP-UX environment. I am attaching all logs, pls look into this and help me with a solution The log file contains warnings that the C compiler you have installed (likely to be the