Subject Re: [Firebird-Java] Create procedure problem
Author Mark Rotteveel
On 05 Nov 2014 05:00:47 -0800, "hugo.larson@... [Firebird-Java]"
<Firebird-Java@yahoogroups.com> wrote:
> Hello,
>
> I have migrated to Firebird 2.5 from 1.5 and have problems creating
> procedures with Jaybird.
> Same SQL statements used to work fine on 1.5 but now not on 2.5.
>
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544351.
> unsuccessful metadata update
> STORE RDB$PROCEDURES failed
> null
> null
> Malformed string
>
> Any clue why the behaviour change and how to fix?
>
> Jaybird 2.3

As there is no 2.3, I assume 2.2.3?

> Java 1.7.0_55

What is you connection character set? If it is NONE (or not explicitly
specified), then I'd suggest to retry with an explicit character set. Some
changes have been made to the metadata character set of the system tables,
and you might now run into a conversion problem here (eg you have
characters with bit 8 set, which is not allowed in UNICODE_FSS).

Otherwise I'd like an example of such a stored procedure (preferably as an
executable testcase).

Mark