DSXchange

You may be out of luck. How much actual data is in the CLOB? Does your version of Oracle have the DBMS_LOB package? Have you tried casting or substringing the CLOB in your SQL?

Yes, it's from the CLOB which is an unsupported data type. What data type/size did you use for that field in your job? Does it help if you set the Array Size to 1?

Right - what we still refer to as 'transaction size' is properly the 'Rows per transaction' setting on the Transaction Handling tab. Any value in the old field is ignored. So, you set it to zero or it was already set to zero? When will you know if the change (assuming one) made things any better for...

Search is your friend! Try an exact search for "This job contains one or more unattached links".

Understood. Suggestion was to use the current time, not a Job Parameter. A script called "after job" could easily do this.

First thought? Patience. How long did you wait before you declared it "effectively hung"?

Array size = 1500 transaction size =1000 Bad combination sending 1500 records at a time but committing every 1000. What I've found works best is where Transaction Size is an even multiple of Array Size. So, for example: Array size = 1500 Transaction size =3000 But then again that is a pretty small ...

Suggest you don't really need a proc for that.

As to what your particular proc / stage issue is... sorry, no clue.

I have no idea why it would take so long to export, but then I haven't had the pleasure of making 8.x's acquaintance.

Both the Package Installer and Version Control have been deprecated so not really worth explaining either one.

D'oh. I was trying to come up with a simple way to include the path, since it more than likely was a job parameter, but couldn't for the life of me figure out where to combine that with the filename in the XML Input or External Source world. Transformer, bah. [face palm]

ray.wurlod wrote:Most find commands have an option to limit the number of levels of search.

One would think so, but I couldn't find one that worked for me. Perhaps I just need to look more better.

That just gets the filename, we need to supply the full path to the stage.

Nice.

Yuck.

Do you have any idea what the max size of the CLOB data is? I've had good luck using the built-in DBMS_LOB package to process ours but they're not mongo huge like Arnd's were.