python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - clob

How to convert CLOB into NVARCHAR2 chunks as per the size of the CLOB?

We have a procedure that generates an HTML report and stores the entire value into a CLOB field. It is then sent to a different procedure which sends an email using UTL_SMTP. The email size can vary, ...
test-img

user3625561

oracle

plsql

oracle11g

clob

Votes: 0

Answers: 1

Latest Answer

I used the answer from this post with some modification as below and got what I wanted. DECLARE TYPE typ_comment IS TABLE OF varchar2 (4000); v_varchar typ_comment := typ_comment (); ...
test-img

user3625561

Web app suffers slow performance after upgrading to Oracle 19c

I have a c# MVC web application (.NET 4.52) using an older version of Devart LinqConnect to scaffold the database etc. The app has been around for 10 years with an Oracle 11g backend database without...
test-img

Sulphy

c#

oracle

clob

oracle19c

devart

Votes: 0

Answers: 1

Latest Answer

Ok, all sorted. The issue was actually the geographical location of the database vs the application server. Bearing in mind our business have offices in UK and Hong Kong, as such the database was ho...
test-img

Sulphy

Oracle Clob column export into a .msg file

I have managed to create two procedure for exporting clob data to .msg file - But for some reason all the clob data is not been exported to the file - Not sure what to do - Any help Declare Cursor...
test-img

Ramesh

file

clob

msg

Votes: 0

Answers: 1

Latest Answer

After some friends help I found the below: their is a procedure in place already in Oracle - which can convert Colb2file - This worked perfectly in Oracle 11g Clob2file procedure reference from link E...
test-img

Ramesh

Reading tags in an XML CLOB column

I've searched several posts here and tried different approaches. I don't get errors but I also don't get output. In our system we store incoming xml transactions in a CLOB column L80T2.tridata, now us...
test-img

emare

xml

oracle

clob

Votes: 0

Answers: 1

Latest Answer

Your path is missing the root MaXML_Envelope node, and the intermediate PartUpdate node. So this: /PartUpdate/DataArea/DataBaseTransaction/PartId/Id/text() should be: /MaXML_Envelope/PartUpdate/DataA...
test-img

Alex Poole

Posts

Questions

Blogs

Jobs