U++ forum: Welcome to the forum

Re: Oracle8: Insert a long RAW Value [message #26761 is a reply to message #26748]

Wed, 26 May 2010 13:52

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

luzr wrote on Tue, 25 May 2010 17:49

tojocky wrote on Tue, 25 May 2010 09:00

luzr wrote on Tue, 25 May 2010 15:24

		SQL.Execute("update TABLE set DATA = ? where ID = ?", SqlRaw(data), q);

You cannot use SqlExp for this. That is why I usually split the process into two parts: I use SqlExp to do the insert, then update to set longraw value.

Mirek

in oracle8 you use SqlRaw?
I see only in Oracle7 it is processed!

Yes, I am using Oracle7 Smile

(It works all the way up).

"7" is minimal requirement. They have changed C api in Oracle 8 and it does not support LONGRAW anymore (if I remember well), replacing it with BLOBs.

Mirek

Mirek,

I tried Oracle7 but without success:

It remain on execution command: oci7.oexec(&cda); from bool OCI7Connection::Execute() on second(last) call.
Can you help me with this? Maybe i did something wrong!

I uploaded image from file direct from file like this:

String v_img_data(LoadFile(p_image_location));
	curr_st.SetParam(1, SqlRaw(v_img_data));

is it correct?

according by this documentation The method OCIDefineByPos support long raw type (SQLT_LBI).

Thank you in advance

[Updated on: Wed, 26 May 2010 15:27]

Report message to a moderator