Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Error: ORA-02070: database does not support in this context

HRSysAdminJan 27 2015 — edited Jan 30 2015

Getting this error:

SQL Error: ORA-02070: database  does not support  in this context

02070. 00000 -  "database %s%s does not support %s in this context"

when running the following using DB link:

INSERT into XXCRM_ATTRIBUTE_LOOKUPS@APEXTST_XXCRM

    (

      attribute_id,

      sr_attribute_drop_down_name,

      incident_type_id,

      sr_attribute_options

      )

    SELECT

      att.sr_type_attr_map_id attribute_id,

      nvl(att.sr_attribute_list_name,'None Defined') sr_attribute_drop_down_name,

      att.incident_type_id,

      nvl(ddlu.description,'None Defined') sr_attribute_options

    FROM

      cug_sr_type_attr_maps_b att,

      fnd_lookup_values atlu,

      cs_incident_types inct,

      fnd_lookup_values ddlu

    WHERE

      att.sr_attribute_code = atlu.lookup_code

      and att.incident_type_id = inct.incident_type_id

      and ddlu.lookup_type(+) = att.sr_attribute_list_name

      and atlu.lookup_type = 'CUG_SR_TYPE_ATTRIBUTES'

      and sysdate between inct.start_date_active and nvl(inct.end_date_active,sysdate);

Any ideas! I don't know what it means or where to start.

Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2015
Added on Jan 27 2015
9 comments
2,015 views