Using ESQL for C to call a stored procedure with output variables 
Author Message
 Using ESQL for C to call a stored procedure with output variables

I'm using ESQL for C 4.22 to call a stored procedure on a SQL Server 4.2
database.

The stored procedure is declared as:


I'm trying to figure out how to write the ESQL in a C program to call
the stored procedure and have the output variable work "correctly".  If
I do not use output variables, I can call the procedure fine.  When
using output variables, I get the message stating that an output variable
cannot be used when a constant is passed in.  The ESQL code looks like
this:

        BEGIN DECLARE SECTION;
        int _qid;
        int _uid;
        int _rid;
        END DECLARE SECTION;

        _qid = 1;
        _uid = 10;

        EXEC SQL EXEC GETNEXTCASE :_qid, :_uid, :_rid out;

I'd appreciate any info you could throw my way on this.

Thanks,

        --kevin
--
Kevin W. Hammond



Sat, 24 May 1997 01:09:27 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Retrieving OUTPUT parameters after a call to a stored procedure in C module with ESQL

2. Calling a stored procedure from VC++ using CRecordset::Open using output paramet

3. Error at obtaining output parameters of the stored procedure, calling other stored procedure

4. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

5. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

6. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

7. Using OUTPUT Parameters in SQLServer Stored Procedures Called From VB

8. How to: Get an output variable from a stored procedure in a variable on my ASPpage

9. Calling Stored Procedures Using Variables

10. Calling Stored Procedure that calls Stored Procedure in ASP

11. Using ODBC call rather than TSQL execute to call a stored procedure


 
Powered by phpBB® Forum Software