Is it possible to define sql parameter as INOUT

[Question123]

Hi

In storedprocedure Is it possible to define sql parameter as INOUT??

plz help me

Thanks

[balame2004]

Hi,

If you declare a parameter as OUTPUT it acts as input as well as output parameter. So you can pass input value as well.

Please see:
http://fabioscagliola. spaces.live.com/blog/cns!919F8FCDE3D C9AC4!121.entry

Regards,
Balaji U

[Question123]

Hi,

If you declare a parameter as OUTPUT it acts as input as well as output parameter. So you can pass input value as well.

Please see:
http://fabioscagliola. spaces.live.com/blog/cns!919F8FCDE3D C9AC4!121.entry

Regards,
Balaji U

Hi Balaji

Thanks for reply.And its working fine.

Thanks Once again