Calling stored procedure in PRO C
From: <abhi147_at_gmail.com>
Date: 18 Jul 2006 22:07:57 -0700
Message-ID: <1153285677.178933.16530_at_m73g2000cwd.googlegroups.com>
Hi ,
Date: 18 Jul 2006 22:07:57 -0700
Message-ID: <1153285677.178933.16530_at_m73g2000cwd.googlegroups.com>
Hi ,
[Quoted] 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"; [Quoted] 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 Received on Wed Jul 19 2006 - 07:07:57 CEST