问在ODBC(PostgreSQL)、C/C++中绑定BLOB值时出错

EN

CREATE TABLE BLOB_TEST
(
    id number(20),
    data BYTEA 
);

.
.
.
int retcode = 0;

SQLCHAR  sql[1024] =
        "BEGIN \n"
            "insert into BLOB_TEST "
        "values(9, ?); \n"
        "EXCEPTION \n"
            "when DUP_VAL_ON_INDEX then \n"
            "dbms_output.put_line(1); \n"
        "END; ";


char * temp_str = "this is a BLOB input TEST";

retcode = SQLPrepareA(hstmt, sql, SQL_NTS);

.
.
.

SQLBindParameter(hstmt,
        1, /* Parameter number, starting at 1 */
        SQL_PARAM_INPUT, /* in, out, inout */
        SQL_C_BINARY, /* C data type of the parameter */
        SQL_LONGVARBINARY, /* SQL data type of the parameter : char(8)*/
        0,          /* size of the column or expression, precision */
        0,          /* The decimal digits, scale */
        temp_str,        /* A pointer to a buffer for the parameter’s data */
        0,          /* Length of the ParameterValuePtr buffer in bytes */
        NULL        /* indicator */
    );

.
.
.

retcode = SQLExecute(hstmt);

if (retcode == SQL_SUCCESS)
{
    printf("Query Execute Success\n");
}
else 
{
        
    SQLGetDiagRecA(SQL_HANDLE_STMT, hstmt, ++rec, state, &native, message, sizeof(message), &length);
    printf("%s : %ld : %ld : %s\n", state, rec, native, message);

    printf("Query Execute ERROR : %d\n", retcode);
}