ExecuteScalar()
-
hi all, this is my oracle StoredProcedure PROCEDURE PEAP_SelectActiveYear ( Cur_RCT1 OUT GLOBALPKG.RCT1 ) AS BEGIN OPEN Cur_RCT1 FOR SELECT ActiveYear FROM PeapParameters; RETURN; END; in the code am trying to fetch the value using ExecuteScalar() but not retrieving :-( Anything need to be changed to the procedure?
-
hi all, this is my oracle StoredProcedure PROCEDURE PEAP_SelectActiveYear ( Cur_RCT1 OUT GLOBALPKG.RCT1 ) AS BEGIN OPEN Cur_RCT1 FOR SELECT ActiveYear FROM PeapParameters; RETURN; END; in the code am trying to fetch the value using ExecuteScalar() but not retrieving :-( Anything need to be changed to the procedure?
I don't use Oracle but try removing the RETURN, this should then get the result set back instead of trying to RETURN any output parameters (of which there are NONE).
Never underestimate the power of human stupidity RAH