Calling stored procedure in PRO C

Dave · *nix forums Guru Joined: 19 Feb 2005 Posts: 1725

abhi147@gmail.com · *nix forums beginner Joined: 19 Jul 2006 Posts: 1

Hi ,
I am very new to Pro C . I have a stored procedure like
abc ( IN a , IN b , IN/OUT c)
I want to call this procedure but I don't know how to get the output
parameter c after the execution .
The sub program is as follows :
EXEC SQL BEGIN DECLARE SECTION;
char *a;
char *b;
varchar c[8];
EXEC SQL END DECLARE SECTION;

a = "A";
b = "B";
c = "normal";

EXEC SQL EXECUTE
BEGIN
abc(:a, :b, :c );
END;
END-EXEC;

Please tell me if i am executing the procedure correctly . And how can
i get the output argument c .

Thanks in advance

Google