Ida Schonfeld wrote:
> Hello,
>
>
>
> I have the following problem:
>
>
>
>
>
> I have a PG function in my database which looks like this:
>
>
>
> CREATE OR REPLACE FUNCTION help_sel0(IN a int,IN b char(2),OUT
> master_fileset INT, OUT master_type CHAR(2), OUT highest_number INT)
> RETURNS RECORD AS
>
> $function$
>
> DECLARE
>
> r RECORD;
>
> BEGIN
>
> SELECT INTO r
> master_fileset,master_type,highest_number
>
> FROM gen_master
>
> WHERE master_fileset= a
>
> AND master_type= b;
>
> master_fileset:=r.master_fileset;
>
> master_type:=r.master_type;
>
> highest_number:=r.highest_number;
>
> END;
>
> $function$
>
> LANGUAGE plpgsql;
>
>
>
> When I now want to send with my ODBC-programm the following prepared
> statement to the server
>
> {SELECT * FROM gen_master_sel0(?,?);} (with the parameters 10 and ‘S2’)
The above call is wrong.
You should prepare the ODBC style procedure call
{call gen_master_sel0(?,?)}
or you can simply prepare the pg-specific procedure call
SELECT * FROM gen_master_sel0(?,?)
.
regards,
Hiroshi Inoue