I'm guessing a bit here, but "invalid name pattern" sounds like you are calling something using a name Oracle doesn't like. So it could be that it is an invalid name or one that that either doesn't exist or you can't see. Can you create an array type directly PL/SQL using this name?
Joined: Jul 16, 2008
My Problem is solve by writing Array name as schema.object instead just writing object name.
But now my problem is, if I am using connection pooling in JBoss, I have getting following error:
subject: java.sql.SQLException: invalid name pattern