Re: PLS-00382 expression is of wrong type
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 13 Aug 2011 11:56:24 +0200
Message-ID: <9an02fFqcmU1_at_mid.individual.net>
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.
Date: Sat, 13 Aug 2011 11:56:24 +0200
Message-ID: <9an02fFqcmU1_at_mid.individual.net>
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.
Kind regards
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sat Aug 13 2011 - 04:56:24 CDT