Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22992: (oracle,9.2.0.8,window)
ORA-22992: [message #352590] Wed, 08 October 2008 08:54 Go to next message
vickey_sagar1
Messages: 77
Registered: August 2007
Location: pune
Member

Hi All,

I am trying to insert data from remote server using DBlink from but I am getting below error .

ORA-22992: cannot use LOB locators selected from remote tables
ORA-06512: at "SCOTT.MRC_MRCDASH_STAGE_LOAD", line 180
ORA-06512: at line 3




Query

INSERT INTO mrc_alliance_stg(
CASE_ID,
QUEUE_NAME,
CATEGORY_NAME,
TYPE_NAME,
ITEM_NAME,
PRIORITY,
STATUS,
AGENT_NAME,
AGENT_LOGIN,
ASSIGNEE_MANAGER_NAME,
VENDOR,
LTF1,
LTF2,
LTF3,
RCA1,
RCA2,
RCA3,
CASE_REQUESTOR_LOGIN,
CASE_REQ_FULL_NAME,
CASE_DESCRIPTION,
CASE_SUMMARY,
CASE_SOLUTION_SUMMARY,
CASE_SOLUTION_DETAILS,
CASE_CREATE_DATE,
CASE_RESOLVE_DATE,
CASE_CLOSE_DATE,
RCA_DETAILS,
LTF_DETAILS,
TOTAL_TIME_SPENT,
SHORT_TERM_FIXC)
select 
   CASE_ID_,
   NVL(ASSIGNED_TO_GROUP_,'NA'),
   NVL(CATEGORY,'NA'),
   NVL(TYPE,'NA'),
   NVL(ITEM,'NA'),
   PRIORITY,                                                            
   STATUS,  
   NVL(ASSIGNED_TO_INDIVIDUAL_,'NA'),
   NVL(ASSIGNEE_LOGIN_NAME,'NA'),
   NVL(ASSIGNEE_MANAGER_FULL_NAME,'NA'),
   NVL(X_VENDOR__,'NA'),
   NVL(X__GLOBAL__FIXED_CODE,'NA'),
   NVL(X_SUBFIX,'NA'),
   NVL(X_SUBSUBFIX,'NA'),
   NVL(X__GLOBAL__CAUSE_CODE,'NA'),
   NVL(X_SUB_CAUSE,'NA'),
   NVL(X_SUBSUBCAUSE,'NA'),
   NVL(REQUESTER_LOGIN_NAME_,'NA'),
   NVL(REQUESTER_NAME_,'NA'),
   NVL(DESCRIPTION,'NA'),
   NVL(SUMMARY,'NA'),
   NVL(SOLUTION_SUMMARY,'NA'),
   NVL(SOLUTION_DESCRIPTION,'NA'),
   NVL(to_date('01-01-1970','dd/mm/yyyy')+(CREATE_TIME/86400),to_date('1/1/1901','mm/dd/YYYY')),
    NVL(to_date('01-01-1970','dd/mm/yyyy')+(RESOLVED_TIME/86400),to_date('1/1/1901','mm/dd/YYYY')),
    NVL(to_date('01-01-1970','dd/mm/yyyy')+(AUTO_CLOSE_TIME/86400),to_date('1/1/1901','mm/dd/YYYY')),
   NVL(ROOT_CAUSE,'NA'),
   NVL(RESOLUTION_METHOD,'NA'),
   NVL(TOTAL_TIME_SPENT,0),                                                    
   NVL(X_SHORT_TERM_FIX,'NA')
   FROM HPD_HELPDESK@ALIANCEDB
   where 
   ASSIGNED_TO_GROUP_ in (select distinct QUEUE_NAME from MRC_QUEUE_D)
   AND to_date('01-01-1970','dd/mm/yyyy')+(MODIFIED_TIME/86400) < x_curr_update_process_date
   AND to_date('01-01-1970','dd/mm/yyyy')+(MODIFIED_TIME/86400) > x_last_update_process_date;


Could you suggest me what I need to do .

Thanks,
Sagar
Re: ORA-22992: [message #352592 is a reply to message #352590] Wed, 08 October 2008 09:15 Go to previous message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@vickey_sagar1,
Quote:

ORA-22992: cannot use LOB locators selected from remote tables
Cause: A remote LOB column cannot be referenced.
Action: Remove references to LOBs in remote tables.



I cannot pinpoint to a particular column because you didn't provide us with table description.
Anyways, this Link might be of some use to you.

Regards,
Jo
Previous Topic: creating a excel file data from the sql prompt
Next Topic: General questions
Goto Forum:
  


Current Time: Mon Feb 17 17:25:05 CST 2025