I use VB6.0 by use programming, save the image to the Oracle database, you need to use the Insert into statement is complete, please expert advice: how to integrate the stream flow to the Insert into statement? Thank you very much,

CodePudding user response:

 insert into talbe1 (id, pictureBlob) values (1, 414 d6a22 hextoraw ('... ')); 

Hextoraw parameters for byte stream format for 6 hexadecimal representation,

Again: why don't record set, AppendChunk?

CodePudding user response:

I tested in company with the record set is ok, but the scene cannot use the Update, can only use the Insert statement, adodb. Read the stream flow in a string, 30 k images into hexadecimal is better for a long time, ask how to put the adodb library. The stream used hextoraw? Thank you,

CodePudding user response:

There is no direct method, only one byte conversion,
Not record set should be the problem of environment, your program does not do the installation package?
No change way, which day encounter ADO cannot use also want to change?

CodePudding user response:

I'm with my laptop directly tested on site, field after AddNew one by one by the assignment, not the last Update method, using the Insert statement, so now want to how to integrate image byte stream to the Insert statement, if is one byte conversion, I also tried, 253 KB image takes 2-3 minutes, this may be related to my machine, but time really is too long, how to give you points?

CodePudding user response:

Upload the file to a server, let the Oracle himself read in Oracle Insert BLOB
Point of junction post button,

CodePudding user response:

There is a direct method, see of I BOLOG,

http://blog.csdn.net/vansoft/article/details/3667917

CodePudding user response:

Change a train of thought so very troublesome,,,,,, you use the FTP upload the file to the FTP server, and use it every time in the automatic download,,,, so convenient