OraFAQ Forum: Server Utilities » Procedures, triggers and other object with character changed.

Home » RDBMS Server » Server Utilities » Procedures, triggers and other object with character changed. (10.2.0.5.0)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Procedures, triggers and other object with character changed. [message #570607]

Mon, 12 November 2012 13:46

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 (ã)

Report message to a moderator

Re: Procedures, triggers and other object with character changed. [message #570609 is a reply to message #570607]

Mon, 12 November 2012 13:48

BlackSwan
Messages: 20099
Registered: January 2009

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Procedures, triggers and other object with character changed. [message #570611 is a reply to message #570607]

Mon, 12 November 2012 14:10

Michel Cadot
Messages: 54181
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

Report message to a moderator

Re: Procedures, triggers and other object with character changed. [message #570612 is a reply to message #570607]

Mon, 12 November 2012 14:13

Michel Cadot
Messages: 54181
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

Report message to a moderator

Re: Procedures, triggers and other object with character changed. [message #570639 is a reply to message #570611]

Tue, 13 November 2012 06:54

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 !

Report message to a moderator

Previous Topic:	What is LKFILE in oracle
Next Topic:	Error executing 'Impdp' utility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 06:07:23 CDT 2013

Total time taken to generate the page: 0.17861 seconds