Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Error while reading CLOB data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] Error while reading CLOB data
 Login/Join
 
Swap
Gold member
posted
Hi,

I have an oracle stored function which returns me JSON format data in a string.
The length of string returned by Oracle is approximately 260000.
When I do PRINT * in the WebFOCUS, it throws error 

 

 (FOC1400) SQLCODE IS 24812 (HEX: 000060EC)
 : ORA-24812: character set conversion to or from UCS2 failed
 (FOC1407) SQL FETCH CURSOR ERROR.  : SQLOUT


I plan to insert newline characters after end of every record from the output using PERL script. But WF is failing at retrieving level only.

Is There any way I can read the data?
I tried TX format, but doesn't help.

Below is snapshot of my code.

 

SQL SQLORA PREPARE SQLOUT FOR
SELECT SNGLPRAC_VIEW_GRID(&mnth) AS OP FROM dual;
END

TABLE FILE SQLOUT
PRINT *
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS MYJASON
END


FILEDEF MYJASON DISK myjason.ftm
-RUN
! perl -pi -e 's/\%\$//g'        myjason.ftm
! perl -pi -e 's/          / /g' myjason.ftm
! perl -pi -e 's/         / /g'  myjason.ftm
! perl -pi -e 's/        / /g'   myjason.ftm
! perl -pi -e 's/       / /g'    myjason.ftm
! perl -pi -e 's/      / /g'     myjason.ftm
! perl -pi -e 's/     / /g'      myjason.ftm
! perl -pi -e 's/    / /g'       myjason.ftm
! perl -pi -e 's/   / /g'        myjason.ftm
! perl -pi -e 's/  / /g'         myjason.ftm
! perl -pi -e 's/\n/ /g'         myjason.ftm
! perl -pi -e 's/>/>\n/g'        myjason.ftm
! cp myjason.ftm final.txt
FILEDEF FINAL DISK final.txt
SET HTMLFORMTYPE=TEXT
-HTMLFORM BEGIN
!IBI.FIL.FINAL;
-HTMLFORM END

This message has been edited. Last edited by: Kerry,


Webfocus 7.7.03
Windows XP
Excel, PDF, HTML, APDF, AHTML, Maintain
 
Posts: 59 | Registered: July 22, 2009Report This Post
Kerry
Expert
posted Hide Post
Hi all,

FYI, Swap already has a case opened regarding this issue.

Swap, please kindly keep us posted on the final solution/answer. Thank you in advance for sharing with all.

Cheers,
Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Error while reading CLOB data

Copyright © 1996-2020 Information Builders