-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello all,

Can anyone point me in the right direction. I am using this through
interclient and ic responds with InvalidOperationException. What have I
missed.

Thanks in advance.

java:

CallableStatement stmt = dbConnection.prepareCall("{call
insert_person(?,?,?,?,?)}");
stmt.setString(1, "jj");
..

ResultSet rs = stmt.executeQuery();
rs.next();
this.uid = rs.getInt(1);


SQL:

SET TERM ^ ;

CREATE GENERATOR gen_person ^

CREATE PROCEDURE "insert_person" (title VARCHAR(15))
RETURNS (UID INTEGER)
AS
BEGIN
UID = GEN_ID(gen_person, 1);
INSERT INTO tbl_person(UID, TITLE) VALUES (:UID, :TABLE);
END ^

SET TERM ; ^


Regards,


Stephen.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE6gumnPmm0AnNwb5MRAhEDAJ0aCW36G+wppKXQuaoSm51iLyfQQgCeKgNz
V2X2XY4osCYhR3VPitL/2oo=
=ejGJ
-----END PGP SIGNATURE-----