We need to pass large text strings (200,000+ bytes) to a procedure.
We have a web server that is receiving Gigabytes of data on a daily basis. We need a process to send this data to the database in real-time.
Right now we have a C program using OCI running on the web server that consumes the text data and sends it to the database by passing it to a procedure. However, we have found that we can not send more than about 32K at a time. (We receive on Oracle Error [OCI_ERROR - Error - ORA-01460: unimplemented or unreasonable conversion requested]
Is there a way to send 200K or more of the text data to a procedure?