Write back Postgres error

[Marcio Souza 2]

Hi everyone!

I'm trying to save Spotfire user login information back to a table in postresql using an information link. The Postgres Function is shown below:

CREATE OR REPLACE FUNCTION ae_board.func_loginsert(

nm_funci character varying,

cd_mtc_funci integer,

cd_comiss integer,

nm_comiss character varying,

prf_depe integer,

log_time timestamp without time zone)

RETURNS void

LANGUAGE 'plpgsql'

COST 100

VOLATILE

AS $BODY$ BEGIN

INSERT INTO ae_board.log_aeboard(nm_funci, cd_mtc_funci, cd_comiss, nm_comiss, prf_depe, log_time)

VALUES($1, $2, $3, $4, $5, $6);

END;

$BODY$;For purpose test, I'm opening the Information Link and filling all the fields manually. As soon as I finish to fill all the fields I'm getting the following error message:

Failed to execute query: Unsupported JDBC data type in query result: void (HRESULT: 80131500)I suspect that is supposed to be related to the Function return type, but I haven't found any paper or information about how types of returns would be accepted in a situarion like that.

Regards,

Marcio

[Marcio Souza 2]

I've found one solution. Thanks

[Manoj Singh]

It would be great Marcio if you can share the solution here so that it would be useful for other user(s) as well..