Newbie HELP: Executing stored proc. from a C program

From: <mll2454_at_tam2000.tamu.edu>
Date: 1995/11/01
Message-ID: <478k2t$mcs_at_news.tamu.edu>#1/1


I created a stored procedure AddUser, which has two IN parameters: id and passwd. I have tested the procedure by executing it from SQLPlus with:

         execute adduser('sqlplus', 'test');

and it successfully inserted the user into the table.

However, I would like to call this procedure from a C program, and I have attempted to do so with the following code:

        userid = "Test";
        password = "tester";
        EXEC SQL EXECUTE ADDUSER USING :userid, :password;

When I execute the program I get the following error:

        ORA-01001: invalid cursor

I have looked in several references (C and Oracle), but they don't show how to execute a procedure.

Thank you for your help...Michael Lewis Received on Wed Nov 01 1995 - 00:00:00 CET

Original text of this message