PL/SQL Expert for RTF Extraction from BLOB and to be transferred to HTML with ctx_doc
- or -
Post a project like this1943
€250(approx. $266)
- Posted:
- Proposals: 2
- Remote
- #2219447
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
This is something we can easily do in TSQL on SQL Server but for which we don't have the PL/SQL on Oracle RAC expertise.
The challenge:
- A unicode table contains a BLOB field (not a CLOB) with encoded RTF text
- We can get the RTF text by casting it to a varchar2 character but the problem this is that this variable is limited to 2000 characters in unicode
- This would be a sample select that perfectly extracts the rtf string from the blob into multiple 2000 character varchar2 variables: select utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,1)) as DESCMF01,
utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,2001)) as DESCMF02
from F00165 where GDTXKY = '128374|MN'
- The idea would be to have a stored procedure that can extract the RTF in one go and transform it in HTML using the embedded ctx_doc library and would provide a full string with the HTML data. The RTF formatting is really basic only (2000 standard) so ctx_doc should be able to do this without a problem.
So the deliverable should be the code to extract the full RTF data and do the transformation to HTML and return a full string with the html data.
Please provide an estimate for this development.
The challenge:
- A unicode table contains a BLOB field (not a CLOB) with encoded RTF text
- We can get the RTF text by casting it to a varchar2 character but the problem this is that this variable is limited to 2000 characters in unicode
- This would be a sample select that perfectly extracts the rtf string from the blob into multiple 2000 character varchar2 variables: select utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,1)) as DESCMF01,
utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,2001)) as DESCMF02
from F00165 where GDTXKY = '128374|MN'
- The idea would be to have a stored procedure that can extract the RTF in one go and transform it in HTML using the embedded ctx_doc library and would provide a full string with the HTML data. The RTF formatting is really basic only (2000 standard) so ctx_doc should be able to do this without a problem.
So the deliverable should be the code to extract the full RTF data and do the transformation to HTML and return a full string with the html data.
Please provide an estimate for this development.
Peter H.
100% (1)Projects Completed
2
Freelancers worked with
1
Projects awarded
100%
Last project
8 Jan 2019
Belgium
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Peter,
Can you please send me some sample data export using data pump so that I can test it and let you know how quickly i can do it for you.
Thanks and Regards
Raja Naveed
739017
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies