ORA-28267: Invalid NameSpace Value Using DB Link
Hi ,
Getting the
ORA-28267: Invalid NameSpace Value
RA-02063: preceding line from dblink12
I am trying to access the dblink through a datasource and I am using a managedBean in session scope to do it.
The code for accessing db link through managed bean is ,
Connection con = new ConnectionHandler().getConnection();
String sql = " select name from table@dblink12";
Statement stmt = null;
ResultSet rs = null;
String retValue = null;
try
{
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
SelectItem item = null;
if (rs.next()) {
retValue = rs.getString("name");
}
}
finally
{
ConnectionHandler.close(rs, stmt, con);
}
System.out.println("retValueARU: " + retValue);
It works when I am trying to run through jDeveloper but not in the standalone weblogic installation.
Any help will be appreciated.
Thanks