This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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 Introducing JavaFX 8 Programming this week in the JavaFX 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

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

Raaj Pradhan

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'
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...
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);
and the stacktrace is ...
java.sql.SQLException: invalid name pattern: PFEP.file_import_nested
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(
at oracle.jdbc.oracore.OracleTypeADT.init(
at oracle.sql.ArrayDescriptor.initPickler(
at oracle.sql.ArrayDescriptor.<init>(
at oracle.sql.ArrayDescriptor.createDescriptor(
at ImportEntity.processRecords(
at javax.servlet.http.HttpServlet.service(
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(
at weblogic.servlet.internal.ServletRequestImpl.execute(
at weblogic.kernel.ExecuteThread.execute(
invalid name pattern: PFEP.file_import_nested
any help would be highly appreciated...
[ December 26, 2002: Message edited by: Raaj Pradhan ]
I agree. Here's the link:
subject: java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedtable
It's not a secret anymore!