Recent content by Doug Volz

Hi Marco, I figured it out ... memory issues with the Database at Go Live. I initially thought it was special characters in the Item Number Descriptions (mtl_system_items_b.description column). As when I commented out the Item Description column in my query, the SQL ran OK. But after a...

What is the cause of this error? Is it data related? Amount of SGA available for a length SQL report? Using Query Reporter version 3.3.1.350, Oracle Client 12c Enterprise Edition Release 12.1.0.2.0.

Hi Marco, I must have a local issue on my laptop ... what I'll do is install PL/SQL Developer on another laptop and see if I can reproduce this error. Thanks, Doug

Hi Marco, Don't think it matters which table ... mtl_parameters is a standard table from the Oracle EBS Applications, Release 12.x. But I reproduced this issue with the following custom table creation statement and following insert statement. (I'm thinking I have somehow screwed up a laptop...

Hi Marco, I think it is something else ... all of the numeric fields export with two decimal points, with zero values for the decimal precision. For example, in an Oracle Vision Environment, when running "SELECT * from MTL_PARAMETERS", the results for the first few columns are: ORGANIZATION_ID...

Hi Marco, for the SQL Window preferences I had the setting as "Right aligned" and was getting the two-decimal issue as described. After reading your response I changed it to "Formatted" but still get a two-decimal format for numeric fields when exporting into Excel. Any ideas? Would this be...

Not sure why, but when I open up a new Report Window, run a SQL query (such as select * from mtl_parameters) and export to Excel (xlsx), the numeric columns are fine, no unwanted decimal points. But when I open up a new SQL Window, do the same query and export to Excel, the numeric columns all...

Thanks very much for your advice! With Bind Variables I was able to use the Test Window and download the results into Excel. Excellent!

Thanks Gustavo, I guess I'll have to have two versions of everything ... rats. With and without Bind Variables (&_variable vs. :_variable formats). I write SQL and not PL/SQL so the Test Window is not much use for me (unless I am mistaken). Perhaps I'll figure out a way to quickly edit the...

I'm a newbie to PLSQL, having been using Query Reporter since 2006 but recently purchased PL/SQL Developer. One of the main reasons I'm sticking with AllAroundAutomations is the excellent ability to download into Excel for all rows and whilst doing so, maintaining the label vs. number...