firebird-net-provider

[Firebird-net-provider] Stored Procedure (receiving binary data in output param)

[olegmad <ol...@ya...>]

I have a problem:

When i use SP and receive output parameters (i'm using
fbCommand.ExecuteNonQuery() method), i can't get parameter if he has type
'bynary'. it contains int64 !!! why???

And when i use SP with DataReader - all ok.
I receive him and he has type 'byte[]'

Can anybody help me?!
Can i recieve binary data in output parameter???

Thanks. And sorry for my bas english :)

Re: [Firebird-net-provider] Stored Procedure (receiving binary data in output param)

[Carlos G. A. <car...@te...>]

Hello:

> When i use SP and receive output parameters (i'm using
> fbCommand.ExecuteNonQuery() method), i can't get parameter if he has type
> 'bynary'. it contains int64 !!! why???

Ok this can be the blob id :) i need to read blob data in this case, i'm 
going to see this later today and add an nunit test for this if it's needed.


> Thanks. 

Thanks to you :)

> And sorry for my bas english :)

No problem, my english is very poor :)


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] Stored Procedure (receiving binary data in output param)

[Carlos G. A. <car...@te...>]

Hello:

> Can anybody help me?!
> Can i recieve binary data in output parameter???

I have the change done but it needs testing, it's a big change and it's 
not definitive ( i'm thinking in better ways of make this ), it will 
allow to return correct values for output parameters and ExecuteScalar 
method.

I'm going to tag actual CVS sources (NP_1_5_Pre_Beta_3) and then commit 
this change.


All comments arround this change are wellcome!!




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.