AW: UNIX : script help/input
Hi Speaking of Perl, ... maybe somebody (Jared) can help out with some Perl / Windows problems: I'm using ActiveState 5.6 with DBI module, which works fine. Now, since I basically work within a CygWin environment on my laptop, I installed perl there, but there are no DBI modules. The basic problem is, that in order to get the DBI stuff compiled within cygwin, you would need a unix/cygwin wrapper for the OCI dlls, which are common windows dlls coming with the Oracle client (9.2.0.4) in order to import OCI stuff correctly, which is needed by DBI (at least I think so). The dlltool doesn't really help me here, since the dlls supplied by Oracle seem to be stripped (at least, dlltool can't find any symbols). If I try: $ nm oci.dll | grep ' T _' | sed 's/.* T _//' oci.def I only get: nm: oci.dll: no symbols Does anybody have an idea how to use the windows oci (or any other Oracle dll) from cygwin ? Otherwise I can also go ahead and toss out cygwin, since accessing Oracle is basically all I need it for. Regards, Stefan -Ursprüngliche Nachricht- Von: Jared Still [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. Oktober 2003 00:29 An: Multiple recipients of list ORACLE-L Betreff: RE: UNIX : script help/input Good! The more the merrier! Welcome to the club. Oh most definitely. As I just finished writing a prototype package for assigning MAC addresses ( we make network stuff - that's a technical term ), I have endured the agonies of doing hex math in PL/SQL. I finally bit the bullet and used string manipulation to convert hex to decimal and do what I needed that way. Couldn't get BITAND to work properly on very large integers. Besides, doing XOR with BITAND in PL/SQL is very painful. UTL_RAW has an XOR, but it requires RAW values and I didn't feel like messing with it. This is all very simple in Perl. Given a MAC of 5AA, with a fixed portion of 500, it is very easy to determine the variable portion of the address via $x = 0x5AA ^ 500. Not quite so simple in PL/SQL. Jared On Wed, 2003-10-01 at 14:44, Mladen Gogala wrote: On Wed, 2003-10-01 at 14:34, Jamadagni, Rajendra wrote: Funny .. I am currently sitting in a Perl class, so I can actually read what MG has written. I'll be soon Perl-literate ... Raj Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
Re: AW: UNIX : script help/input
A search on 'cygwin perl dbi oracle' revealed a number of URL's that may be helpful. This one looked promising: http://sources.redhat.com/ml/cygwin/2002-08/msg00923.html Jared Stefan Jahnke [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/02/2003 03:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:AW: UNIX : script help/input Hi Speaking of Perl, ... maybe somebody (Jared) can help out with some Perl / Windows problems: I'm using ActiveState 5.6 with DBI module, which works fine. Now, since I basically work within a CygWin environment on my laptop, I installed perl there, but there are no DBI modules. The basic problem is, that in order to get the DBI stuff compiled within cygwin, you would need a unix/cygwin wrapper for the OCI dlls, which are common windows dlls coming with the Oracle client (9.2.0.4) in order to import OCI stuff correctly, which is needed by DBI (at least I think so). The dlltool doesn't really help me here, since the dlls supplied by Oracle seem to be stripped (at least, dlltool can't find any symbols). If I try: $ nm oci.dll | grep ' T _' | sed 's/.* T _//' oci.def I only get: nm: oci.dll: no symbols Does anybody have an idea how to use the windows oci (or any other Oracle dll) from cygwin ? Otherwise I can also go ahead and toss out cygwin, since accessing Oracle is basically all I need it for. Regards, Stefan -Ursprüngliche Nachricht- Von: Jared Still [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. Oktober 2003 00:29 An: Multiple recipients of list ORACLE-L Betreff: RE: UNIX : script help/input Good! The more the merrier! Welcome to the club. Oh most definitely. As I just finished writing a prototype package for assigning MAC addresses ( we make network stuff - that's a technical term ), I have endured the agonies of doing hex math in PL/SQL. I finally bit the bullet and used string manipulation to convert hex to decimal and do what I needed that way. Couldn't get BITAND to work properly on very large integers. Besides, doing XOR with BITAND in PL/SQL is very painful. UTL_RAW has an XOR, but it requires RAW values and I didn't feel like messing with it. This is all very simple in Perl. Given a MAC of 5AA, with a fixed portion of 500, it is very easy to determine the variable portion of the address via $x = 0x5AA ^ 500. Not quite so simple in PL/SQL. Jared On Wed, 2003-10-01 at 14:44, Mladen Gogala wrote: On Wed, 2003-10-01 at 14:34, Jamadagni, Rajendra wrote: Funny .. I am currently sitting in a Perl class, so I can actually read what MG has written. I'll be soon Perl-literate ... Raj Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED