| How to add Error Msg when format is XML Oracle Repor Builder 6i [message #613800] |
Mon, 12 May 2014 07:08 |
 |
tomrubble
Messages: 3
Registered: May 2014
|
Junior Member |
|
|
Is there a way to print error to view log when conc program is listed as XML in the format . per this article https://community.oracle.com/thread/2471859?start=0&tstart=0 it says to change to Text as format. This prints error in format Text mode in conc program definition
ORA-01861: literal does not match format string
SELECT pov . vendor_name Vendor , pvs . vendor_site_code Vendor_site , pvs . address_line1 Address , pvs . address_line2 , pvs . address_line3 , pvs . city , pvs ............
. when changed format changed back to XML in format
Environment will now switch to UTF-8 code-set.
Parts of this log file may not display correctly
as a result. This is an expected behavior.
XML_REPORTS_XENVIRONMENT is :
/oadev/u60/oadevora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to /oadev/u60/oadevora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
'.,'
stat_low = 8B
stat_high = 0
emsg:was terminated by signal 11
When listed as text
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.US7ASCII
'.,'
I want to hit the view log and see the error similar to Text mode when the format is set to XML
Thanks
[Updated on: Mon, 12 May 2014 07:47] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
