zzotnik wrote:

> Hi guys,
>
> I keep getting the error in the subject line with my stored
> procedure. Here is the code, hope you guys can help me work out
> something :-)
>
> CREATE TABLE INVOICES (
> INVOICEID INTEGER NOT NULL,
> CUSTOMERNAME BLOB SUB_TYPE 1 CHARACTER SET ISO8859_2 NOT NULL
> COLLATE ISO8859_2,
> CUSTOMERPCODE BLOB SUB_TYPE 1 CHARACTER SET ISO8859_2 NOT NULL
> COLLATE ISO8859_2,
> CUSTOMERCITY BLOB SUB_TYPE 1 CHARACTER SET ISO8859_2 NOT NULL
> COLLATE ISO8859_2,
> CUSTOMERADDRESS BLOB SUB_TYPE 1 CHARACTER SET ISO8859_2 NOT NULL
> COLLATE ISO8859_2);
>
>
> CREATE PROCEDURE LOAD_INVOICE_LIST
> RETURNS(
> INVOICEID INTEGER,
> CUSTOMERNAME BLOB SUB_TYPE 1 SEGMENT SIZE 1 CHARACTER SET
> ISO8859_2,
> CUSTOMERPCODE BLOB SUB_TYPE 1 SEGMENT SIZE 1 CHARACTER SET
> ISO8859_2,
> CUSTOMERCITY BLOB SUB_TYPE 1 SEGMENT SIZE 1 CHARACTER SET
> ISO8859_2,
> CUSTOMERADDRESS BLOB SUB_TYPE 1 SEGMENT SIZE 1 CHARACTER SET
> ISO8859_2,
>

Why are you specifying a segment size? Not sure if that is the actual
problem but I would get rid of those designations since you don't
declare the fields using those sizes.

Woody (TMW)