Re: Fwd: exception in plsql - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: Fwd: exception in plsql
Date
Msg-id 4B824FB4020000250002F46B@gw.wicourts.gov
Whole thread Raw
In response to Fwd: exception in plsql  (Ravi <nm.ravi2005@gmail.com>)
List pgsql-bugs
Ravi <nm.ravi2005@gmail.com> wrote:

> when I tried to use the toArray method to extract exception raised
> saying
>
> org.postgresql.util.PSQLException: Cannot cast an instance of
> [Ljava.lang.Object; to type Types.ARRAY

OK, that looks like an array, so I'm now a bit lost.

Could you put together a self-contained example of how to create the
problem?  (Self-contained meaning that I can take what you provide
and run it, without writing any Java or plpgsql code or inventing
table or type definitions -- which might or might not match what you
did well enough to show the problem.)  It's most helpful if you keep
removing things until you have the *smallest* example which still
shows the problem.

-Kevin

pgsql-bugs by date:

Previous
From: Tim Bunce
Date:
Subject: Re: BUG #5334: Version 2.22 of Perl Safe module breaks UTF8 PostgreSQL 8.4
Next
From: "Toni Helenius"
Date:
Subject: BUG #5338: PG_DUMP fails due to invalid adnum value