I'm using a dbms_output call to extract data from my Oracle db into an .xml file. The sql script works fine and I've got a KSH shell script to call the sql. Everything is working, but I'm hitting the 1,000,000 buffer limit imposed by the dbms_output.
From the research I've been doing, it looks like there's no work around for this, 1 million characters is the limit with dbms_output and that's that.
I need an alternative, or if there is a workaround, to make this work. Any help appreciated.
From the research I've been doing, it looks like there's no work around for this, 1 million characters is the limit with dbms_output and that's that.
I need an alternative, or if there is a workaround, to make this work. Any help appreciated.