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
 
 
FCCN - Fundação para a Computação Científica Nacional | DNS.PT
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 ]

NOTA DE CONFIDENCIALIDADE: Esta mensagem poderá conter informação
privilegiada e confidencial. Se não é o destinatário da presente
comunicação, agradecemos que nos informe e elimine a mensagem sem que a
mesma seja divulgada, distribuída ou copiada.
 
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
> and there are some Unicode characters, like "ç ã õ é è í ì" that we
> 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.
>
> Even if ask to run the linux command "echo mão" (in English is "echo
> hand") the output is wrong.
>
> declare
> cmdoutput varchar2(32767);
> cmd varchar2(32767);
> begin
> cmd := 'echo *mão*';
> 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
>  
>  
> FCCN - Fundação para a Computação Científica Nacional | DNS.PT
> 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 ]
>
> NOTA DE CONFIDENCIALIDADE: Esta mensagem poderá conter informação
> privilegiada e confidencial. Se não é o destinatário da presente
> comunicação, agradecemos que nos informe e elimine a mensagem sem que
> a mesma seja divulgada, distribuída ou copiada.
>  
> 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.
>

• Help on Calling external Perl script from Oracle DB by Assis Guerreiro
• Re: Help on Calling external Perl script from Oracle DB by Assis Guerreiro