Home » RDBMS Server » Server Utilities » Procedures, triggers and other object with character changed. (10.2.0.5.0)
Procedures, triggers and other object with character changed. [message #570607] Mon, 12 November 2012 13:46 Go to next message
xeremzovisck
Messages: 2
Registered: November 2012
Location: Brasil
Junior Member

Hy

Procedures, triggers and other object with character changed.

Every character was replaced by ã? the content of procedures and other objects after importing a schema for production approval.

Help me.


Example:


EXCEPTION
WHEN OTHERS THEN
p_msgerro := p_msgerro ||
' Erro na selec?o da Unidade Administrativa. ' ||


The character (?) deveria ser (ã)
Re: Procedures, triggers and other object with character changed. [message #570609 is a reply to message #570607] Mon, 12 November 2012 13:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Procedures, triggers and other object with character changed. [message #570611 is a reply to message #570607] Mon, 12 November 2012 14:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Example:


VERY bad example, read WHEN OTHERS and remove this from ALL your code, this is a BUG.

Regards
Michel
Re: Procedures, triggers and other object with character changed. [message #570612 is a reply to message #570607] Mon, 12 November 2012 14:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Every character was replaced by ã? the content of procedures and other objects after importing a schema for production approval


This depends on NLS_LANG and/or database character set.

Regards
Michel
Re: Procedures, triggers and other object with character changed. [message #570639 is a reply to message #570611] Tue, 13 November 2012 06:54 Go to previous message
xeremzovisck
Messages: 2
Registered: November 2012
Location: Brasil
Junior Member

Hi!

I Export Sources for procedures, triggers, functions and packages from production and recompile to Homologation enviroment. it's work!

Thanks for fast response


Thanks for all !
Previous Topic: What is LKFILE in oracle
Next Topic: Error executing 'Impdp' utility
Goto Forum:
  


Current Time: Fri Mar 29 06:22:00 CDT 2024