OCI+OCL下BLOB

1)

INSERT INTO TABLE(ColumnName) VALUES (EMPTY_BLOB()) RETURNING ColumnName INTO :ColumnName

 

OraQuery *query;

OraLob *blob;

query.param("ColumnName").setDirection(pdInput);

blob = &(query.param("ColumnName").getBlob());

blob ->write(0, strlen(ColumnName), ColumnName);

 

 

 

2)

UPDATE ColumnName SET ColumnName=EMPTY_BLOB() RETURNING ColumnName INTO :ColumnName

 

OraQuery *query;

OraLob *blob;

 

query.param("ColumnName").setDirection(pdInput);

blob = &(query.param("ColumnName").getBlob());

blob ->write(0, strlen(ColumnName), ColumnName);

 

 

 

 

3)

SELECT ColumnName FROM TABLE

 

char *blobchar;

char *selectblob;

char *column;

blobchar = (*dvnquery).field("ColumnName ").getBlob().getChars(selectblob);

column = new char[strlen(blobchar)+1];

strcpy(column, blobchar);