DSXchange

ORA-24806: LOB form mismatch Cause: When reading from or writing into LOBs, the character set form of the user buffer should be same as that of the LOB. Action: Make sure that the buffer you are using to read or write has the same form as that of the LOB. I'm assuming "the user buffer" is...

Would this not just need an Aggregator? Group on Project ID, year, month and sum the amount.

What kind of "reading" are you trying to do here? And then what would your target be? Any of these special data types can't be simply selected but are accessed via 'spatial queries' or methods like Get_WKT (get well known text) to return a CLOB.

Details are here.

What detail do you need? It's not substantially different from your other recent post with the capitals. And your target will no longer be an integer of course, so first convert the source to a string and then proceed with the chopping upping.

Three sources and a Funnel come to mind.

Substring the value apart (or use Left/Right) and concatenate back together adding that character between the two pieces.

Split to your own topic.

You sure?

... and then you go back and delete the extra ones. Anyone can do that as long as they haven't been replied to. Me, I can do it anytime.

Wasn't sure exactly what was going on and chose a poor subject for the new topic. I've moved it to the proper forum and (hopefully) corrected the subject.

Sounds like you're doing all the right things for that "connection lost contact" error. Probably old news for you but just in case, some information here.

Not that I'm aware of.

(moved)

And yet the Job Type is marked as Parallel. Which is it?

Show us the warning. I'm assuming it's because you have the "Automatically handle" option enabled in your Sequence job.