oopilix
asked on
ODBC Oracle with CString Probelm
hello.
I am using oracle database ,and
mfc,odbc method to
execute my command.
I want to insert into mytable
,the field is LONG type data_type .
I want to insert a CString.
when the CString length <4000,
it's ok.
but when It's length come to >4000.
It won't work.
how can I resovle ,thx.
I am using oracle database ,and
mfc,odbc method to
execute my command.
I want to insert into mytable
,the field is LONG type data_type .
I want to insert a CString.
when the CString length <4000,
it's ok.
but when It's length come to >4000.
It won't work.
how can I resovle ,thx.
Hello,
we use OCI and when we want to save string that are greater than 4000 bytes, we use a piecewise operation. That
means, that Oracle will save the long string in 4000 bytes blocks. Is there a aquivalent operation in ODBC ?
Best regards
Manfred Peter
we use OCI and when we want to save string that are greater than 4000 bytes, we use a piecewise operation. That
means, that Oracle will save the long string in 4000 bytes blocks. Is there a aquivalent operation in ODBC ?
Best regards
Manfred Peter
ASKER
thx,
but I din't use OCI before,
and
how do you use it in OCI,
I can't imagine I can't insert into one
field with different data;
as u see:
Insert into xxx(x) values(...
Insert into xxx(x) values(...
what will it become..
but I din't use OCI before,
and
how do you use it in OCI,
I can't imagine I can't insert into one
field with different data;
as u see:
Insert into xxx(x) values(...
Insert into xxx(x) values(...
what will it become..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh,thank you
I will find the OdBC method ,and
try it.
I will find the OdBC method ,and
try it.
ASKER