If I include just the join to the adjustments table, the query takes forever to run and I get another oracle error: “ora-01652: unable to extend temp segment by 384 in tablespace TEMP" If I include just the join to the posting table the query works. If I take the last query and comment out the lines in the WHERE clause doing the check on dates in the adjustments table, the query runs successfully. I can't understand though why these would cause this error though.I am basically just including in some joins to the asset_master table so I can group. So basically the stuff dealing with the Asset_Master table is new. SELECT sum(Asset_Monthly_Data.ACQUISITION_NEW) + sum(Asset_Level_Adjustments.ADJUSTMENT_AMOUNT)
![oracle apex sql error 01858 oracle apex sql error 01858](https://www.foxinfotech.in/wp-content/uploads/2019/03/bulk-errors.jpg)
#Oracle apex sql error 01858 code#
I've tried running this using TOAD and SQL Plus but get the same error.Īny suggestions would be greatly appreciated.I would also be happy to post or attach my entire SQL statment as well.Īndrew, on your suggestion I took my complete SQL and commented out everything except the code going to the adjustment table, then kept modifying it and added things back in one at a time.
![oracle apex sql error 01858 oracle apex sql error 01858](https://4.bp.blogspot.com/--iQp8B9L_PI/W6jQx7tEBdI/AAAAAAAABbo/tNRhVZCTm2IdS2dd1NnFWeodBzxeMh0qACLcBGAs/s1600/Img3.png)
I have also set nls_date_format in the registry on my client machine to 'mm-dd-yyyy' and the application that is passing the SQL to the Oracle database is sending an "alter session set nls_date_format = 'mm-dd-yyyy' " before the query. I have isolated the error to the following lines in the WHERE clause of my SQL, in which I am concatenating a period and year field in a table to create a date, then using >= and = trunc(to_date('12-01-2002', 'MM/DD/YYYY')))Īnd (( Trunc(last_day(to_date((lpad(Asset_Level_Adjustments.ADJUSTMENT_PERIOD,2,'0') || '/01/' || Asset_Level_Adjustments.ADJUSTMENT_FISCALYEAR), 'MM/DD/YYYY'))) ) = trunc(to_date('12-01-2002', 'MM/DD/YYYY')))Īnd (( Trunc(last_day(to_date((lpad(Asset_Monthly_Data.PERIOD, 2, '0') || '/01/' || Asset_Monthly_Data.FISCAL_YEAR), 'MM/DD/YYYY'))) ) =, I've tried using the concat() command instead of the ||, I've removed the last_day() and the trunc(), I've used '-' instead of '/' in my dates, etc. I am getting the "ORA-01858: a non-numeric character was found where a numeric was expected" in a query on my Oracle db (9.2.0.4).