Home  |  Linux  | Mysql  | PHP  | XML
Date:Wed Feb 11 20:25:15 2009
Subject:Re: Help on Calling external Perl script from Oracle DB
Hi,

It seems that the problem is solved. I was about the character code
<http://ipv6.google.com/search?hl=en&ei=bDKTScbnNcyp-gbhgpmuCw&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=character+Code&spell=1>of
the ASM listener.

Thanks
Best Regards

--
Assis Guerreiro
WG-DNS


Apartado 50366 | 1708-001 Lisboa | Portugal
Tel.: +351 218 440 140 | Fax.: +351 218 440 157
Email: assis.guerreiro@fccn.pt <mailto:assis.guerreiro@fccn.pt>
http://www.dns.pt


[ Antes de imprimir esta mensagem pense no ambiente. Before printing
this message, think about environment ]


CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential
and may be privileged. If you are not a named recipient, please notify
the sender immediately and do not disclose the contents to another
person, use it for any purpose or store or copy the information in any
medium.


Assis Guerreiro said the following on 11-02-2009 10:35:
> Hi,
>
> I've got you email address from a presentation called "Perl for Oracle
> - Tools and Technologies, by Tim Bunce (Jan 2002)", and I really hope
> you can help me on a issue that I'm trying hard to solve, but with no
> positive result.
> The thing is:
> I used to have the database on a single machine and everything was
> ok, until last week, when we changed to new machines.
> now I have a Oracle 10.2.0.4 Standard Edition Database on a two nodes
> (RAC) Linux X86-64.
> And I'm trying to run a perl script (external procedure) from the
> Database.
> Everything works fine but with a problem. My language is Portuguese
> use here.
>
> So when I call the perl script from the database those Unicode
> characters don't work, instead they are replaced by the "?" character.
>
> I've installed the DBI module, the DBD Driver and I'm using a
> libosint.so library and the osutil.RunOsCmd procedure to call external
> procedures, like it was before when everything was ok.
>
> hand") the output is wrong.
>
> declare
> cmdoutput varchar2(32767);
> cmd varchar2(32767);
> begin
> osutil.RunOsCmd(cmd, cmdoutput);
> dbms_output.put_line (cmdoutput);
> end;
>
> the ouput is:
>
> 19:38:12 Start SQL Editor Execution ...
> 19:38:12 Processing ...
> *m?o*
> 19:38:12 *** SCRIPT END : Session:WFCCN@FCCN(1) 10-02-2009
> 19:38:12 ***
> 19:38:12 End SQL Editor Execution
>
>
> Can you give any idea how to solve this problem?
>
> Thanks in advance from Portugal :)
>
> Assis Guerreiro
> WG-DNS
>
>
> Apartado 50366 | 1708-001 Lisboa | Portugal
> Tel.: +351 218 440 140 | Fax.: +351 218 440 157
> Email: assis.guerreiro@fccn.pt <mailto:assis.guerreiro@fccn.pt>
> http://www.dns.pt
>
>
> [ Antes de imprimir esta mensagem pense no ambiente. Before printing
> this message, think about environment ]
>
>
> CONFIDENTIALITY NOTICE: This e-mail and any attachments are
> confidential and may be privileged. If you are not a named recipient,
> please notify the sender immediately and do not disclose the contents
> to another person, use it for any purpose or store or copy the
> information in any medium.
>


Navigate in group perl.dbi.oracle-oci at sever nntp.perl.org
Previous Next





  
© No Copyright
You are free to use Anything, but please consult your advocate before doing so as this website
also list content from other sources which may be copyrighted.
Site Maintained by Zareef Ahmed
Powered By PHP Consultants