ASP Stored Procedure with Large Datafield

[TWillard]

I want to create an asp edit screen, so that values can be inserted into an Oracle database table. I have one memo field that has the potential to be quite long. I currently have this field set to clob in the database. I would prefer to use a stored procedure to insert values into this field.

I am aware of the appendChunck method for a ADODB.connection. This method works fine for inserting values into a field. However, I feel that a stored procedure would be a better solution to this problem. I have to worry about many different columns in many different tables and work with new sequences values and so forth. I was thinking that with a Stored Procedure, I could throw all of the values into the procedure and make all of the appropriate inserts or updates and handle the intergrity of the data there.

I can not find a data type match for a clob in the adovbs.inc file.

Does anyone know if this can be done?

Does anyone know the maximum amount of data that can be inserted with the given constants in the adovbs.inc file?

Does this sound like a good solution?

Thanks,


Tim

 

[Tarwn]

I believe that you will actually have to write a bit of code around your stored procedure to do this. As you could store up to 4gb (i think) in an oravle clob field, but only transmit 2000 characters at a time in a string. The appendChunk method takes care of that for you, but in order to do this with a stored procedure you will need to have it set up variable in the database to hold the chunks as you pass them as parameters and then piece them back together to put in the database field. I'm not 100% on this, but pretty sure. You may want to ask some people in the oracle forum, they would have more experience with it than I.

-tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
With enough resources, time, and coffee, anything is possible.