972731 wrote:When you start with the wrong question, no matter how good an answer you get, it won't matter very much.
I have a table with query column, in stored procedure I have to read that query from table and execute it and send the result to calling stored procedure. Clob capacity is 4 gigabytes but when I have declared clob variable in stored procedure it's not accepting more than 4 kb of data. That's why I am planning to use nclob but execution of nclob query is the problem. My query length is not that much big but why it's not stored in clob data type ?