Hi,

Can anyone please let me how to execute a procedure with return
values and capture the return values in the front-end (VB.NET).

If these are the procedures -
1. test()
2. test1(input_param1,input_param2)
3. test2() -> returns i integer

I can call procedures 1 and 2 directly from vb.NET
with "".executenonquery"" and passing it a command text "execute
procedure test()" or "execute procedure test1()"

But how can I catch the return of test2()

It gives me and error - message length error, expected 8, encountered
0.

Any help would be appreciated.

regards
S.