Parameter "p_cols" (getRows and getCursor) as CLOB

[krischmaster]

Hi there,

thank you very much for this really useful program!
I'd like to suggest an enhancement: transforing the datatype of "p_cols" to CLOB.
Long lists of columns with somewhat long names hit the VARCHAR2 length limit.

Best wishes
Christian

[mbleron]

Hi Christian,

Thanks for your interest in ExcelTable :)
I'll consider your enhancement request, but remember the column specs must be passed as a literal, so in order to pass a CLOB literal, we'll have to use something like :
to_clob(' ... ') || to_clob(' ... ') || ...
not so pretty in my opinion, but why not?

I'll do it as an overload though, and keep the VARCHAR2 parameter as is, since it is sufficient in most situations.

And on 12c, we can also use extended VARCHAR2 (32k).