Jump to content

Write back Postgres error

Marcio Souza 2

Recommended Posts

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)


LANGUAGE 'plpgsql'

COST 100



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);


$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.



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...