Jani Hur
Jani Hur
This is a great pattern but I struggle a bit how this could be a "general purpose" ? I have used the similar kind of pattern too (but making the...
Please have a look to oos_transform in https://github.com/janihur/oos-utils-sandbox That's my initial generalization of refcursor to xml conversion. As you can see there is no much code when XSLT/XQuery is excluded.
I added two different draft versions of refcursor to csv to oos_transform https://github.com/janihur/oos-utils-sandbox
> how difficult would it be to include the column names on the first line? Trivial. I know how to do it in dbms_sql based implementation, but I'm not sure...
Thanks @zhudock - I'll apply your comments soon. Meanwhile please keep working with xquery :)
I checked the logger. Yes - the feature is essentially the same. I use these functions to feed data to my super simple logging "framework" that eats strings only (varchar2...
An example of the usage scope of `kv` and `kvn` functions is now available in https://github.com/janihur/oos-utils-sandbox/blob/master/oos_issue_91_example.sql
Yes, I checked that subprogram too but I think the intended use is very different. `oos_string_util.truncate_string` is fine when you have two clearly different strings with incompatible length restrictions: ```...
``` plsql declare procedure append( p_buf in out nocopy varchar2 ,p_str in varchar2 ,p_buf_max_len in number default 32767 ) is numeric_or_value_ex exception; pragma exception_init(numeric_or_value_ex, -6502); begin p_buf := p_buf ||...
Thank you ! This contribution is welcome, but unfortunately @martindsouza has not have time for the project recently. Please be patient !