On my system your code works fine.. But just with version 8.1.2!
There was only a minor problem with "OUT info". Don't know exactly
why (maybe a it's a keyword) but it didn't like the name info..
Regards,
Remo
--
Tuesday, February 7, 2006, 4:20:44 PM, you wrote:
FFJ> --- Remo Laubacher <[EMAIL PROTECTED]> escreveu:
>>
>> Saturday, February 4, 2006, 6:57:43 PM, you wrote:
>>
>> mfnp> Hello npgsql-general!
>>
>> mfnp> I have a problem with Postgres functions and IN/OUT Parameters. I have
>> mfnp> the following function:
>>
>> mfnp> create function test(IN main_id integer, OUT new_id integer, OUT info
>> mfnp> varchar) ....
>>
>> mfnp> .. and I want to get the return values in npgsql.
>>
>> mfnp> Postgres creates this function as having:
>> mfnp> Argument data types: integer
>> mfnp> and
>> mfnp> Result data type: record
>>
FFJ> Can you try calling it like that:
FFJ> NpgsqlCommand cmd1 = new NpgsqlCommand("test",_conn);
FFJ> Npgsql will check if function returns record and put the proper sintax for
FFJ> calling function.
FFJ> Also, do you have the exactly error postgresql returns?
FFJ> I hope it helps.
FFJ> --
FFJ> Regards,
FFJ> Francisco Figueiredo Jr.
FFJ>
FFJ> _______________________________________________________
FFJ> Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora!
FFJ> http://br.acesso.yahoo.com
_______________________________________________
Npgsql-general mailing list
Npgsql-general@gborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/npgsql-general
