SQL > create table range (order_date date) partition by range (order_date) (partition p1 values less than (to_date('0','DD-MM-YYYY'))) I am trying to create a partition of the range and getting ORA-01858: a non-digit character was found here where was waiting for a digital the DATE or TIMESTAMP data type columns), why are they not? ROUND (MONTHS_BETWEEN (C22_LASTPAYDUEDATE, C23_FACGRANTDATE)) If C22_FACGRANTDATE and C23_LASTPAYDUEDATE are indeed 'two date columns', why are you doing a TO_DATE() on them? And why do you do a TO_NUMBER() to a value that will already be a number? Why not just do this: Like the im getting the error ORA-01858: a non-digit character was found here where was waiting for a digital. TO_NUMBER (ROUND (MONTHS_BETWEEN (TO_DATE (C22_LASTPAYDUEDATE, "YYYY-MM-DD HH24:MI:SS), TO_DATE (C23_FACGRANTDATE," YYYY-MM-DD HH24:MI:SS))))))) I have the data in the table that consist of two columns of date below
#Oracle apex sql error 01858 code
If you run your code in Eclipse before you deploy I'd print our your insertStmt SQL and then try to run in SQLDeveloper.īefore posting inturn I have goggled on the question above, but looking forward for you suggestions. I guess it's the column YEAR or PERIOD_NUM giving you seizures If you're not on current patch.100 then you should look at the data types for the OpenInterface table.
#Oracle apex sql error 01858 Patch
the latest Patch is now universal data adapter that allows for a direct import of the tables and views without the need to use the Interface open to scene data table : : ORA - 01858: a nonnumeric character where waiting a digital. When I checked the ODI journal for this, I found that it is said: stmtRS = stmt.executeQuery () and display and error code problem: Params = [batchName, stmtRS.getString("PERIOD_YEAR"),įdmAPI.executeDML (insertStmt, params, False)īut my DLR gets failed. Stmt = sourceConn.prepareStatement (selectStmt) "SEGMENT4) AS SEGMENTX, TEMP_VIEW.SEGMENT5, TEMP_VIEW.SEGMENT6, TEMP_VIEW.SEGMENT7, TEMP_VIEW.SEGMENT8, TEMP_VIEW.NETBAL FROM TEMP_VIEW WHERE THE QUAD IS NOT NULL. # Limiting the number of rows to 5 during the test runs.
DriverManager.getConnection "pppp", "nnnnn") To do this, I wrote script below:īatchName = "Batch_" + str (fdmContext )
I'm trying to load some data from the views created in EBS to HFM using FDMEE with the help of the BefImport Script. GROUP BY TRUNC(TRANSDATE),CALLEDHOMECODE,CALLTYPE Any idea?ĭata load rule for BefImport script getting failed due to the error Code ORA-01858 GROUP BY TRANSDATE, SUBNO, B_SUBNO, CHARGINGTIME, CALLTYPE, CHARGINGTYPE, CALLDURATION, BILLAMOUNT, PREBALANCE, POSTBALANCE, CHARGINGPARTYNO) (SELECT MIN(ROWID) FROM TABSBGR.ROAMING_PREP_CALLS WHERE CALLTYPE IN ('001','031') (SELECT DESTINATION_DESC FROM dbm.DBM_DESTINATION WHERE DESTINATION_CODE =A.CALLEDHOMECODE AND ROWNUM '965' SELECT TRUNC(TRANSDATE), CALLEDHOMECODE DESTINATION, ORA-01858: a non-digit character was found here where was waiting for a digital When running this Toad sqlplus query, it works fine.