output parameter of stored procedure 
Author Message
 output parameter of stored procedure
Dear there,

    Can an output parameter of a stored procedure function be the array
of strings?  As far as I know, it seems to me that data types of
parameters of stored procedure functions do not have the support of
having the output as the array of strings.

    Thank you.

-Kanda



Mon, 28 Apr 2003 03:00:00 GMT
 output parameter of stored procedure

Hi Kanda,
The output parameter data has to be shipped, on the wire, to the client. If
you want to send nonDB2 data back to the client (which is OK), then your
client has to be able to unpack it. Use null padded char for bit data or
blob as the sqltype, and define a struct for both client and sp to read and
write the data with.

For example, build a blob containing many strings using structs like:

struct aString
{
    int stringLength;
    char string[1];    // expand this to stringLength

Quote:
};

struct manyStrings
{
    int numStrings;
    struct aString strings[1]; // expand this to numStrings

Quote:
};

Hope this helps,
David.
Quote:

> Dear there,

>     Can an output parameter of a stored procedure function be the array
> of strings?  As far as I know, it seems to me that data types of
> parameters of stored procedure functions do not have the support of
> having the output as the array of strings.

>     Thank you.

> -Kanda



Tue, 29 Apr 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Using OUTPUT parameters in stored procedures

2. text data type support for output parameter for stored procedure

3. ODBC and output parameter of stored procedure

4. retrieve value of output parameter from Stored Procedure

5. ntext output parameter of Stored Procedure

6. Problem getting an output parameter from stored procedure

7. text/image output parameters from stored procedures

8. Output parameter frm Stored Procedure via jdbc-odbc

9. output parameter in stored procedure

10. ADO output parameters when stored procedure raises error?

11. retrive output parameter from Stored Procedure under Query Analizer

12. Returning output parameter from Stored Procedure


 
Powered by phpBB® Forum Software