I'm an admitted total Oracle newbie with very little SQL for that matter, but I'm having to do an interface, so please bear with me. Your library has been extremely helpful, but I'm having trouble getting the single blob field we have into the database. It crashes. I'm trying to dump it in as a string, but it's up to 2 gig in size. I set MAX_OUTPUT_TEXT_BYTES large enough, and I'm using the statement bind, but when I execute it asserts in execute_prepared due to OCIStmtExecute returning -1 (which seems to map to SQL_ERROR, but I've checked with typing in random values for everything on the command prompt and that executed just fine).
First, thanks, Bobi. OraLib - enough simple and very useful. But I've got a problem using it in multithreaded application and can't find answer in OCI manuals. For example, two threads - parent and child. You can define multiple oralib::connection in one of them and they all work fine, but if you open a connection in parent and then try to open a connection in child, the later won't open (OCIServerAttach fails). I tried to open them with OCI_THREADED - the same result. Can you help me?
Thanks in andance.
error C2664: 'strcmp' : cannot convert parameter 1 from 'const unsigned short *' to 'const char *'
Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast
'pair,class std::allocator > const ,class oralib::column *>' : assignment operator could not be generated
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\xtree(28) : see reference to class template instantiation 'std::pair,class std::allocator > const ,class oralib::column *>' being compiled
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\map(46) : see reference to class template instantiation 'std::_Tree,class std::allocator >,struct std::pair,class std::allocator > const ,class oralib::column *>,struct std::map,class std::allocator >,class oralib::column *,struct std::less,class std::allocator > >,class std::allocator >::_Kfn,struct std::less,class std::allocator > >,class std::allocator >' being compiled
I�m having problems with rs.eod(). Sometimes when I make a select in an empty table the rs.eod() returns FALSE and rs.is_null() returns FALSE also. I don�t know what is happening. If somebody had found this problem or knows what is going on please help me.
Here�s an example:
//table1 is an empty table
resultset &rs=*connection.select("select cod1 from table1");