Error - ORA-01861: literal does not match format string
I modified my OCIBindPos test program a bit to execise some cases.
I'm doing a
drop table arraytest; create table arraytest (field1 varchar2(20), D FLOAT, L LONG, T DATE ,M INTEGER) ; select * from arraytest; quit;
and when running the following code on it, I'm getting:
#include <fcntl.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <io.h>
#include <stdio.h>
#include <string.h>
#include <oci.h>
#include <ocidfn.h>
#define BIGBUF 100000
char bigdata[BIGBUF];
void checkerr (OCIError * errhp, sword status);
const char insertSQL[] = "insert into arraytest values ( :1, :2 ,:3, :4,:5)";
char *strColVal[] = { "ABC", "111.1", bigdata, "2009-07-17-16.05.31", "56"};
#define MAXBINDS 5
#define NITERS 1
int
main (int argc, char **argv)
{
int rc = 0,i;
int status = 0;
int rowsProcessed = 0;
int fd;
struct _stat fstatus;
char *sid = NULL;
char *user = NULL;
char *pwd = NULL;
char *table = NULL;
OCIEnv *pEnv = NULL;
OCIError *pError = NULL;
OCISvcCtx *pSvc = NULL;
OCIStmt *pStmt = NULL;
//OCIBind *pBind = NULL;
OCIBind 0