Re: Oracle error with swedish characters

2004-02-10 Thread Lincoln A. Baxter
On Tue, 2004-02-10 at 02:49, [EMAIL PROTECTED] wrote: > > > i am accessing an oracle database from redhat linux. oracle version 8.1.7 > when i execute a query against the data that contains the swedish character > Ã i get a ? returned instead. i've run some test in perl and oracle. in > oracle

PL/SQL Data Structures and Perl

2004-02-10 Thread Williams, Richard Alun (IPG Partner-ops)
I am using Perl DBI/DBD for Oracle. I have a lot of PL/SQL, and I can't find any mention of whether or not Perl DBI can receive Oracle PL/SQL structures (PL/SQL tables of type RECORD) back from a call to a PL/SQL call. Does anyone know if I can define this: -- TYPE t_task_cmd_list IS TAB

DBD::Oracle 1.15 + Oracle 10g + Linux = success (with a small tweak)

2004-02-10 Thread Andy Hassall
Just to pre-empt the probably soon to be frequently-asked question, here's one data point: DBD::Oracle 1.15 appears to work OK on Oracle 10.1.0.2 on Linux. [EMAIL PROTECTED]:~/src/DBD-Oracle-1.15-andyh$ make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'bli

getting rid of the "Issuing rollback()" warning

2004-02-10 Thread Andrew Pimlott
This sounds like it must be a FAQ, but I can't find it... Is there any way to prevent the following from warning "Issuing rollback() for database handle being DESTROY'd without explicit disconnect()."? use DBI; my $dbh = DBI->connect('dbi:Pg:dbname=...', undef, undef,

Re: Connecting Unix to windows.

2004-02-10 Thread Peter Hircock
Hello I found DBI-Proxy very useful for this. On the windows machine, you run the DBI-Proxy server which connects to the windows DB( My case it was an ODBC connection ). The Unix box can then run using DBI. Peter > Dear Lee - > >> "Lee" == Lee Swale <[EMAIL PROTECTED]> writes: > > Lee>

Re: Connecting Unix to windows.

2004-02-10 Thread William Goedicke
Dear Lee - > "Lee" == Lee Swale <[EMAIL PROTECTED]> writes: Lee> I am trying to connect to a windows DB [...] from UNIX [...] Lee> Do you know if this is possible? It's certainly possible, but the last time I used it it was awkward at best. The solution I know is to install ODBC on

Re: Test Message

2004-02-10 Thread Michael A Chase
On 02/09/2004 10:07 PM, Waseem Anis wrote: Please ignore Forever. -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fis

Connecting Unix to windows.

2004-02-10 Thread Lee Swale
I am trying to connect to a windows DB (Sage line 100: an accounting package) from UNIX (Perl) and all I've been supplied with is MS Access ODBC drivers. Do you know if this is possible? Can DBD::ODBC do this without touching the Access drivers or is that how DBD::ODBC works (connecting one set

RE: Redirect trace() to a filehandle

2004-02-10 Thread Orton, Yves
Tim Bunce wrote on 09 February 2004 18:17: > On Mon, Feb 09, 2004 at 04:31:34PM -, Orton, Yves wrote: > >> That's long been on the to-do list. Patches welcome > > > >If I look into this is a callback mechanism OK? > > No, not directly. Has to be a PerlIO filehandle - but *that* > can

Re: Oracle error with swedish characters

2004-02-10 Thread Reinhard Pagitsch
Hello Reiner, [EMAIL PROTECTED] wrote: > let me try to clarify. > i have the problem running perl to oracle on linux only. the windows > machine was just a test to see if it was a greater perl problem. since it > works on windows i am now trying to get perl DBI to work only on linux. > Windows ha

Re: Oracle error with swedish characters

2004-02-10 Thread reiner . peterke
let me try to clarify. i have the problem running perl to oracle on linux only. the windows machine was just a test to see if it was a greater perl problem. since it works on windows i am now trying to get perl DBI to work only on linux. Windows has nothing to do with the issue. :) is there som

Re: Oracle error with swedish characters

2004-02-10 Thread Reinhard Pagitsch
Hello Reiner, it seems to me it is a code page conversion problem from Windows <-> redhat. Maybe you can set in the Oracle client on your Windows machine which codepage DBI have to use connecting to your Oracle on redhat. I think DBI uses the codepage from your Windows to display characters with L

Oracle error with swedish characters

2004-02-10 Thread reiner . peterke
i am accessing an oracle database from redhat linux. oracle version 8.1.7 when i execute a query against the data that contains the swedish character å i get a ? returned instead. i've run some test in perl and oracle. in oracle the character mentioned is ascii 229. perl has no problem with