wood burning stoves*
The moose likes BEA/Weblogic and the fly likes java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedtable Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedtable " Watch "java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedtable " New topic
Author

java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedtable

Raaj Pradhan
Greenhorn

Joined: Nov 02, 2001
Posts: 6
Hi all,
I am trying to insert an array in nested table to another table. I have a nested table by the name 'file_import_nestedTable'.
code for object 'file_import_obj'
CREATE OR REPLACE TYPE file_import_obj AS OBJECT
{
column_1 datatype,
column_2 datatype,
........ ........,
column_n datatype
}
and for nested table 'file_import_nestedTable'
CREATE OR REPLACE TYPE file_import_nestedTable as TABLE OF file_import_obj
I have a package in place and it is valid.
The problem started when I tried to use the weblogic pool connection to call the procedure. But this was overcome by using the Oracle connection i.e another pool and not the weblogic's own connection pool.
But now I'm facing this exception when I try to use the ArrayDescriptor.
java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedTable
Here is my code...
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection(connectionString);
// its throwing exception here.
ArrayDescriptor desc = ArrayDescriptor.createDescriptor("file_import_nestedTable",connection);
ARRAY arr1 = new ARRAY(desc,connection,strArrHeaderBodyData);
OracleCallableStatement call = (OracleCallableStatement)connection.prepareCall("{call pkg_file_import.proc_file_import(?,?)}");
call.setARRAY(1, arr1);
call.registerOutParameter(2, java.sql.Types.VARCHAR);
call.execute();
connection.commit();
and the stacktrace is ...
java.sql.SQLException: invalid name pattern: PFEP.file_import_nested
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:424)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:343)
at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1002)
at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:132)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:97)
at ImportEntity.processRecords(ImportEntity.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2456)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2039)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
invalid name pattern: PFEP.file_import_nested
any help would be highly appreciated...
Thanx.
[ December 26, 2002: Message edited by: Raaj Pradhan ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedtable