1 Reply Latest reply: Apr 22, 2013 4:23 AM by jeneesh RSS

    Error while accessing a Table on Oracle Database 10.2

    RaviR
      Hi Experts,

      We have a table that contains a CLOB datatype in one of its column. However when i tried to access the table i get the below error.

      <b>Table Name:</b> discrete_jobs
      <b>Error:</b>
      (Error starting at line 1 in command:
      select * from stg.discrete_jobs@TEST.YODA
      Error report:
      SQL Error: ORA-22992: cannot use LOB locators selected from remote tables
      22992. 00000 - "cannot use LOB locators selected from remote tables"
      *Cause:    A remote LOB column cannot be referenced.
      *Action:   Remove references to LOBs in remote tables.)

      Pleas Help!

      Regards,
      Ravi R