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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

unknown-951199

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

// *Cause: The remote database does not support the named capability in

//         the context in which it is used.

// *Action: Simplify the SQL statement.

are you 100% positive that DBLINK points to correct DB?

ddf_dba

HRSysAdmin wrote:

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.

What version is each database?

David Fitzjarrell

Cuauhtemoc Amox

I've seen that when calling a function that is not available on the remote DB. Nothing looks like that on the query, but if you are using a view, take a look at the underlying query

HRSysAdmin

What version is each database?

- 11.2.0.2.0

HRSysAdmin
Cuauhtemoc Amox -

I am not calling a function or using a view. Any other ideas?

Thank you.

HRSysAdmin

I am 100% positive that the DBlink is correct

unknown-951199

post result from following SQL

select count(*) from  XXCRM_ATTRIBUTE_LOOKUPS@APEXTST_XXCRM;

HRSysAdmin

select count(*) from  XXCRM_ATTRIBUTE_LOOKUPS@APEXTST_XXCRM;

4405

The DBLink is happy. I believe it may be something to do with the complexity of the SELECT statement.

What do you think?

Thank you for your assistance.

Richard Harrison .

Hi,

I'd try and narrow down what is acusing the issue bit by bit - for example

replace

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

with 'X'

and see if the problem goes away - try and do something similar in each section until you identify the cause - then you can try and find a workaround

Cheers,

Rich

1 - 9
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
1,879 views