I am trying to return the variable value of Insured in the attached ORACLE stored procedure code to my VB6 application. I have been moving around the code I have and trying to incorporate a fetch statement into the mix, but I just can't seem to assign the value of CLIENT_NAME in the select statement to the variable Insured. Excuse me if I am mixing up terminology, I am a newbie to both Oracle and VB6. Can someone please show me the code of how this would work within my ORACLE stored procedure that I have attached?
PROCEDURE spBCT_BPOFileIndexLookup(PolicyNumber IN varchar2, rs_Agency_Info OUT rs_Info_Type) is
OPEN rs_Agency_Info for Select CLIENT_NAME into Insured from CLIENT_NAMES where CLIENT_NUMBER = PolicyNumber;