Home » Developer & Programmer » Reports & Discoverer » How to add Error Msg when format is XML Oracle Repor Builder 6i
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

Previous Topic: report errors need help on query multiple date format in table
Next Topic: how to get the figure in word
Goto Forum:
  


Current Time: Tue Sep 29 16:44:01 CDT 2020