mdabyo
12-16-2003, 11:02 AM
Hey guys, i have what i am sure if a simple question. i am trying to call a stored function from VB using an ADO connection:
This is my function:
function F_Get_New_BNum
return number is
begin
declare
BNum number := 0;
begin
select max(batchnumber)
into BNum
from licence.batchprint;
BNum := BNum + 1;
return BNum;
end;
end F_Get_New_BNum;
how someone can give me a hand.
Thanks
-J
This is my function:
function F_Get_New_BNum
return number is
begin
declare
BNum number := 0;
begin
select max(batchnumber)
into BNum
from licence.batchprint;
BNum := BNum + 1;
return BNum;
end;
end F_Get_New_BNum;
how someone can give me a hand.
Thanks
-J