RE: Having problems setting up DBD::ODBC

2006-01-24 Thread Jeff Urlwin
Here's a warning I see: Warning: LD_LIBRARY_PATH doesn't include /users/openlink/lib Is that where libiodbcinst.so is located? Jeff -Original Message- From: Mark Nettleingham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 2:24 PM To: Jeff Urlwin; dbi-users@perl.org Cc: [EMAIL

RE: bind varray as in or inout param

2006-01-24 Thread Ted Behling
One workaround, although somewhat inelegant, would be to turn your array into a Perl string, then interpolate the string into an anonymous PL/SQL block which invokes the procedure. You could use something like the following half-pseudocode: $varray = join(q{', '}, @input_array); $sth =

RE: bind varray as in or inout param

2006-01-24 Thread Shuxteau, Kiki
Thanks. I came across the same posting and I thought since 2 years had gone by, things might have changed and varray is supported now. In general, I think if I want to output a varray, I would use refcursor as a work around. But if I want to input a varray, say, I want to avoid calling a SP from

Re: bind varray as in or inout param

2006-01-24 Thread John Scoles
I have searched around a bit and have no real answer for you. A much earlier post (2004) on this list said "You have probably worked this out by now, but what you are trying to do is not directly possible with the current version of DBD::Oracle. If you are returning a VARRAY, there are some ways

bind varray as in or inout param

2006-01-24 Thread Shuxteau, Kiki
Hi, Can I pass in a VARRAY data type to an oracle stored procedure via perl or receive VARRAY from Oracle SP? Thanks, KS

Re: Installing Perl DBI

2006-01-24 Thread Alexander Foken
Sorry, compiling from source on Win32 is nothing for beginners. I doubt Raja has properly installed nmake and the C compiler ActivePerl 5.6 was compiled with. For a beginner, installing PPDs from ActiveState's repository is much easier and faster. Don't get me wrong: It is possible to use "per

RE: Installing Perl DBI

2006-01-24 Thread Gupta, Razat
Try it with nmake and nmake install instaed of PPM if you have downladed the DBI. Regards Razat -Original Message- From: Dilly raja [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 2:21 AM To: dbi-users@perl.org Subject: Reg: Installing Perl DBI I have installed ActivePerl-5.6

Re: Reg: Installing Perl DBI

2006-01-24 Thread Alexander Foken
Look at ActiveStates Website for PPD packages. (You could also compile and install the packages from CPAN yourself, but you usually do not want that.) For Perl 5.6, use http://ppm.activestate.com/PPMPackages/zips/6xx-builds-only/ For Perl 5.8, use http://ppm.activestate.com/PPMPackages/zips/8

Reg: Installing Perl DBI

2006-01-24 Thread Dilly raja
I have installed ActivePerl-5.6.1.638-MSWin32-x86 in my Windows-Xp system. I have to install perl DBI on it. I dont have Internet connection. i downloaded the DBI-1.50.tar from the net and unzipped and saved in a location. when i try to type the command "Install dbi" in the PPM> it gives the "error