APEX

Now that I have your attention I must first say, thank you thank you thank you for being here. This forum has saved me tons of frustration but with each save my boss finds one more to add...

Here's the situation. He's used WWV_FLOW_FILES to store attachment data and I know the "Best Practice" is to use a custom table.

What I've now been tasked to do is move all this data from WWV_FLOW_FILES into a custom table then clean up the application so that it will pull the information from the custom table instead of FLOW_FILES...

I know how to do the later part of this as I already have a ton of custom tables to store differning documents depending on the application I'm working on. What I need to know is this...

Is there a way to physically move all the data (or copy all the data) from WWV_FLOW_FILES into a custom table? Again, this is a one time MOVE of ALL DATA and not the copy / delete procedure that is used to upload a document into a custom table.

I thought about doing something like:

CREATE TABLE SCRIPT_FILES
SELECT * FROM WWV_FLOW_FILES

however; I know that this will give me the error "Expected text got BLOB" error, or something to that effect...

I will be forever in your debt if someone can help me with this

Thanks,

Mike Long