Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> java.sql.SQLException: ORA-24777: use of non-migratable database link not allowed

java.sql.SQLException: ORA-24777: use of non-migratable database link not allowed

From: Prasad <p4cldba_at_gmail.com>
Date: Mon, 10 Dec 2007 15:52:53 -0800
Message-ID: <666b99c70712101552q53a18865u8051adf4661cb7e5@mail.gmail.com> 





All,




when I try to update or insert a remote db from sqlplus with db link it
works fine . but the web application which runs on the JBOSS server it
complains



java.sql.SQLException: ORA-24777: use of non-migratable database link not
allowed


ORA-06512: at "ACTIONLIST.TRG_PRODUCT_ACTIONLIST", line 39
ORA-04088: error during execution of trigger '
ACTIONLIST.TRG_PRODUCT_ACTIONLIST'


    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)



Appreciate any idea.



Thanks


-Prasad




--



http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 10 2007 - 17:52:53 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US