clob | Simple limit order book and matching engine

I am retrieving table values by comparing against one of the elements in clob column of the table. However, my query is returning following error:

ORA-00932: inconsistent datatypes: expected CHAR got ANYDATA

1. 00000 - "inconsistent datatypes: expected %s got %s"

I have to show oracle database table data in oracle apex interactive report. This table has a clob column(mime type: text/plain).

I am able to successfully display clob data in oracle apex interactive report as guided in below post https://www.foxinfotech.in/2019/12/displaying-clob-contents-in-oracle-apex.html

Now, I should be able to edit clob column data and save the updated clob data back to database. But I am unable to do this.

Can some one help with this?

I have:

1. Oracle 19c
2. java 8 on its machine

What i did:

I write simple class with one method in Java 8.

I have a CLOB containing an XML.

While inserting data into table i was facing error string literal too long. Hence to fix this issue i used concatenation operater. For eg : values is ' || ' too big But still the issue is not solved , now facing result of string concatenation is too long. The data type of column is clob.

We have a CLOB column, in a DB2 database that contains XML. The query does not seem to like the embedded xmlns. I simplified the query down to this:

values xmlquery('$rf/Producers/FIRMS/FIRM/EIN/text()' passing xmlparse(document '27/') as "rf")

If I remove the xmlns embedded in Producers, it works. As is, it does not return anything, but does not throw an error. Like I said, this is simplified for troubleshooting. In reality, the document would be from a CLOB column in our DB. All th XML stored in the CLOBs contains the xmlns. Any suggestions on how to deal with this?

I have a query that takes start and end year for data also it takes a name of a table as procedure parameters..

the query then will create a table with that name if it doesn't exist or if exist it will drop and recreate it

I'm working with Oracle 12.2.0.1.0. We have created a procedure that sends email with UTL_SMTP package. Evrything works fine but we lost encoding specific for polish language.

NLS settings: NLS_CHARACTERSET = EE8MSWIN1250; NLS_NCHAR_CHARACTERSET = AL16UTF16;

We keep msg text in CLOB column in table.

Kindly, I am trying to substring clob value by removing the first 33 characters and the last 2 characters,

I try with the following simple code but it's returned an error: ORA-06502: PL/SQL: numeric or value error