[Oledb-dev] Invalid

[Debjit Kar]

I apologize. I was not complaining. Regarding output parameters when i am executing the same function with one input and one ouput parameter with pgODBC the functions is executing properly and thus it establushes the fact that PostgresSQL does support Output parameters. I have even tried executing the following two functions with odbc and it exactly works as expected.the 2 functions signatures are:1.    CREATE FUNCTION sp_test_func1(IN param1 varchar(100), OUT param2 bigint) ....2.    CREATE FUNCTION sp_test_func2(IN param1 varchar(100), OUT param2 varchar(100), OUT param3 varchar(100)) ....Regards,Debjit Kar> Date: Fri, 18 May 2007 23:55:07 +0300> From: shachar at shemesh.biz> To: debjitk at hotmail.com> CC: oledb-devel at pgfoundry.org> Subject: Re: [Oledb-dev] Invalid> > Debjit Kar wrote:> > With all due respect i still could'nt figure it out how is it taking> > me soooo long to find a simple answer. What am i doing wrong in my> > code. And what are the call syntaxes for PgOleDb. I mean 72 hours to> > get an answer wether PgOleDb would work with Functions containing> > inoput and ouput paramters or not. Though in the release it is> > mentioned that you can add Parameters with ADODB.> I am sorry to hear that the support you received is not up to your> standards. As a small token of I'm sending you a check with complete> refund for both the money you spent on the support AND the money you> payed for the actual driver.> > Seriously!> Indeed.> > Regards,> >> > Debjit Kar> Just so you do not claim your questions are left unanswered, postgresql> does not support output parameters per se. It uses output parameters as> aliases for a complex return type.> > One way or the other, PgOleDb does not support output parameters at the> moment, in whatever form.> > Glad to be of service,> Shachar
_________________________________________________________________
Download Messenger. Start an i’m conversation. Support a cause. Join now.
http://im.live.com/messenger/im/home/?source=TAGWL_MAY07
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/oledb-devel/attachments/20070519/38d2b8c3/attachment.html