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 ,

[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

Original text of this message