Oracle 5.0, Справочное руководство

Страница: 2239 / 3232

C API Prepared Statement Function Descriptions
2219
parameter_number
indicates which parameter to associate the data with. Parameters are numbered
beginning with 0.
data
is a pointer to a buffer containing data to be sent, and
length
indicates the
number of bytes in the buffer.
Note
The next
mysql_stmt_execute()
call ignores the bind buffer for all
parameters that have been used with
mysql_stmt_send_long_data()
since last
mysql_stmt_execute()
or
mysql_stmt_reset()
.
If you want to reset/forget the sent data, you can do it with
mysql_stmt_reset()
. See
Section 20.6.10.21, “
mysql_stmt_reset()
” .
Return Values
Zero if the data is sent successfully to server. Nonzero if an error occurred.
Errors
•
CR_INVALID_BUFFER_USE
[2944]
The parameter does not have a string or binary type.
•
CR_COMMANDS_OUT_OF_SYNC
[2942]
Commands were executed in an improper order.
•
CR_SERVER_GONE_ERROR
[2942]
The MySQL server has gone away.
•
CR_OUT_OF_MEMORY
[2942]
Out of memory.
•
CR_UNKNOWN_ERROR
[2941]
An unknown error occurred.
Example
The following example demonstrates how to send the data for a
TEXT
column in chunks. It inserts the
data value
'MySQL - The most popular Open Source database'
into the
text_column
column. The
mysql
variable is assumed to be a valid connection handle.
#define INSERT_QUERY "INSERT INTO \
test_long_data(text_column) VALUES(?)"
MYSQL_BIND bind[1];
long length;
stmt = mysql_stmt_init(mysql);
if (!stmt)
{
fprintf(stderr, " mysql_stmt_init(), out of memory\n");
exit(0);
}
if (mysql_stmt_prepare(stmt, INSERT_QUERY, strlen(INSERT_QUERY)))
{
fprintf(stderr, "\n mysql_stmt_prepare(), INSERT failed");
fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
exit(0);
}
memset(bind, 0, sizeof(bind));
bind[0].buffer_type= MYSQL_TYPE_STRING;