Getting the return value from a Function into a Visual Basic program
469520Jan 25 2008 — edited Jan 29 2008I have written a function (see below) and i want to be able to get the result from the function into visual basic after passing it the initial value. I have looked on the MSDN site but all they give is examples in C# which is completely useless for me.
CREATE OR REPLACE FUNCTION GET_COMP_PROD (
p_mouldno NUMBER
)
RETURN VARCHAR2
IS p_compprod VARCHAR2(50);
BEGIN
SELECT COMPONENTPRODUCT INTO p_compprod FROM MOULDS
WHERE MOULDNO = p_mouldno;
RETURN p_compprod;
END GET_COMP_PROD;
/