Welcome to the Oracle Analytics Community

Home› ORA-00666› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ORA-00666 Rank 3 - Community Apprentice

Comments

  • I think that error is given because of wrong date format of default parameter value {01-01-2016}. Because when I try formula with default parameter value {2016-01-01} (which should be default in my Locale) I get different error: ORA-01843: not a valid month at OCI call OCIStmtFetch.
    in Difference between dates Comment by ORA-00666 Aug 23, 2016 4:21AM
  • TIMESTAMPDIFF(SQL_TSI_YEAR , "Apdraustieji"."Gimimo data", Cast(Cast(@{p_data_iki}{01-01-2016} as Char) as Timestamp)) ORA-01847: day of month must be between 1 and last day of month at OCI call OCIStmtFetch. (HY000)
    in Difference between dates Comment by ORA-00666 Aug 23, 2016 4:08AM
  • When I want to add a pivot table view I could not do this because of error
    in Difference between dates Comment by ORA-00666 Aug 23, 2016 4:06AM
  • TIMESTAMPDIFF(SQL_TSI_YEAR , BIRTH_DATE, @{p_date_till}{01-01-2016}) --On results tab: State: HY000. Code: 22025. [nQSError: 22025] Function TimestampDiff is called with an incompatible type. (HY000 SQL Issued: {call NQSGetQueryColumnInfo('SELECT TIMESTAMPDIFF(SQL_TSI_YEAR , "BIRTH_DATE", 01-01-2016) FROM "Table"')SQL…
    in Difference between dates Comment by ORA-00666 Aug 23, 2016 4:04AM
  • case when age is null or birth_date is null or DateNumber is null then 0 else TIMESTAMPDIFF(SQL_TSI_MONTH, TIMESTAMPADD( SQL_TSI_DAY, 1 - DAYOFMONTH(birth_date), TIMESTAMPADD(SQL_TSI_YEAR, age, birth_date)) , TO_DATETIME(DateNumber,'YYYYMMDD')) end With this I get "function cast is called with an incompatible type" ifnull(…
    in trunc and months_between in obiee Comment by ORA-00666 Aug 18, 2016 4:22AM
  • DateNumber is double and birth_date is datetime and both columns can be null
    in trunc and months_between in obiee Comment by ORA-00666 Aug 18, 2016 2:29AM
  • With suggested formula i get "function cast is called with an incompatible type". I think it's something because date formats. Maybe you know what's the problem?
    in trunc and months_between in obiee Comment by ORA-00666 Aug 17, 2016 6:43AM
  • I need to calculate how many months person was old. For example, if i need to calculate my months old when date_id (DateNumber) was 20101001, my birth date is 1981.10.08 and my age was then (date_id = 20101001) 29 years, so i was 0 months old. select birth_date, date_id, age,…
    in trunc and months_between in obiee Comment by ORA-00666 Aug 17, 2016 2:13AM
  • As I understood I changed my formula: FLOOR(TIMESTAMPDIFF(SQL_TSI_MONTH , TIMESTAMPADD(SQL_TSI_MONTH , DAYOFMONTH(TO_DATETIME(DateNumber,'yyyymmdd')), TO_DATETIME(DateNumber,'yyyymmdd') + 1), BirthDay) ) - Age * 12 But I get a warning: Function cast is called with an incompatible type
    in trunc and months_between in obiee Comment by ORA-00666 Aug 16, 2016 9:03AM