Using clob as parameter

[gulhaugen]

Does anyone have a method to test a function/procedure with a local file as clob input?

I know I can paste it in, but thats a bit rough on a big file.

Ideally a browse file system for the content of the clob/blob.

Morten

 

[Marco Kalter]

If you click on the cell button (...) for a Temporary CLOB variable, the Large Data Editor will be invoked. It allows you to read the file contents from the file system.

 

[gulhaugen]

Yes I know. And I have tried that. Loading a 17MB xml file was not an easy task.

First up the XML document tried to show it, which hogged the machine for quite a while.
I couldn't find the option for not autodetecting the content type, but I guess I havent looked hard enough.

Next I tried pasting the same contents, but with some other text at the top, so to not invoke the XML view, and it hogged my machine again. This of course is not possible for real tests.

So a third approach would be nice, hopefully with a bit more speed.

 

[Marco Kalter]

Okay, I have added this to the list of enhancement requests.