Re: PLS-00382 expression is of wrong type

On 11.08.2011 19:38, Tim Slattery wrote:
> joel garry<joel-garry_at_home.com> wrote:>>>> No idea about any of this stuff, but I do note maybe you have a>> scoping error (perhaps some combo of jdbc and synonyms), see MOS>> 1019403.102 for what I'm referring to. Searching on the two errors>> with&& between them on MOS may give other clues.>> I've solved it. This is a web system running under a WebLogic server.> I was using a Weblogic driver in my connection pool, when I switched> to an Oracle driver the problem vanished.

Then the reason was OracleTypes.CURSOR which is specific to Oracle.
With JBoss similar things can happen: the JEE container wraps JDBC
connections with its own wrapper class to be able to cache
PreparedStatement and handle XA logic. Whenever you need functionality
which is specific to the real driver used underneath you need to obtain
the wrapped connection and work with that.