catch Return value from storeproc

[Mark_Meng]

Can some one tell me how to catch the return value from store procedure in VB.

I have a storeproc as

create Procedure StoredProcedure2
select * from agent
return 5

I would like to catch the 5 in my VB code, can someone tell me how to do it? Thanks in advance

[GungaDin]

Is this an Oracle Stored Procedure or something else?

It it's oracle, then I can show you some sample code that should let you do it.

Otherwise, I won't bother.

[Mark_Meng]

Thanks very much, but it is sql server