Sergei Kuchin

Jose, You can email me directly. My email address can be found on OTL Web pages. Cheers, Sergei

I put together the following quick test code to test timestamp: include <iostream></iostream> using namespace std; define OTL_ORA18C include "otlv4.h" int main(int argc,char* argv[]) { try{ otl_connect db; db.rlogon("system/oracle@myora_tns"); db.direct_exec("drop table test_tab",0); db<<"create table test_tab(update_flag varchar2(1), ipodate timestamp(6), f1 CLOB, f2 CLOB) "; otl_stream o; o.open(1, "INSERT INTO test_tab VALUES( " " :UPDATEFLAG_<char<span>[3]>, " " to_timestamp(:IPODATE<char<span>[27]>,'yyyy-mm-dd...

Jose, Can you put together a self-contained code example that reproduces the problem and email it to me? I need a code example that creates a similar table and tries to insert a row into it. BTW, did you enable #define OTL_ORA_TIMESTAMP: https://otl.sourceforge.net/otl3_compile.htm#OTL_ORA_TIMESTAMP Sergei

Jose, I'm not sure where / what the problem is. You can always use a char[XXX] variable bind variable + a conversion function call to convert strings into timestamps for passing in timestamp values if nothing else works. It may take weeks to track down the actual issue, and it may take hours to implement a char[XXX] workaround. Sergei

Natalia, I looked at that a long time ago but I found that there wasn't enough demand for it at that point in time. At this point in time I don't have "the bandwidth" (too much stuff to do at work and C++ compiler development being "agile" these days doesn't help) to implement anything as complex as bulk insert. I'd suggest you to take a closer look at bulk copy utility (BCP) or T-SQL bulk insert command. Sorry to disappoint you, Sergei

Juergen, If it works for you, why not? No actual DB APIs calls are different. I'd run some tests, because my philosophy is that when you change even a comma in the code, you need to re-run your test suites. Sergei

Juergen, Did you try the latest OTL 4.0.469? OTL 4.0.360 is out of date. Sergei

Paul, No, OTL as it stands right now, doesn't support connecting to the database using Oracle Wallets. However, otl_connect class has a constructor / logon function that accept raw OCI resources allocated externally. So, you can implement an Oracle Wallet based connector / extender and use it with OTL without touching the rest of your OTL based code. Sergei