Hi, please help me... IB4m trying to read TIMESTAMP column but when I call OCIStmtFetch a GPF is generate inside oracle dllB4s. Do you know how I can do it ? Thanks Best regards Cristian
ReplyOCI_ATTR_DATA_SIZE puts data size to ub2*, not ub4* as OraLib passes. This causes unrealisticly huge sizes to be returned by OCIAttrGet() on sun4_solaris due to a different byte order.
ReplyOriginally posted by: felisandria
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).
How can I get a blob into a database with oralib?
Thanks
-fel
ReplyOriginally posted by: Ivan
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.
Originally posted by: yjkim
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
..........
3 error
'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
Warning...
ReplyOriginally posted by: gbernardes
I�m having problems with rs.eod(). Sometimes when I make a select in an empty table the rs.eod() returns FALSE and rs[1].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
if(rs.eod()) //rs.eod() returns FALSE
}while(rs.next());
}
Thanks
Hi,
resultset &rs=*connection.select("select cod1 from table1");
{
cout<<"no rows selected"<<endl;
}else{
do{
if(!rs[1].is_null) //rs[1].is_null() returns FALSE
{
cout<<"row selected"<<endl;
}
gbernardes
Originally posted by: SB
In the recordset class I did not see a previous method so I assume this only supports forward scrolling cursors.
If you do not think it would be hard and if it should be able to handle it could a rs.bod and rd.previous methods be added to support bi-directional scolling?
If you think it will not be hard I will try to add and forward code for release.
Shawn
Originally posted by: wenhui
int main()
if (!rs.eod ())
return 0;
Worth that I wrote the underneath these codes, but return is a error code:
{
try
{
connection cn("server","cim","cim");
resultset &rs = *cn.select("select name from oss_operator");
oralib::column &c1 = rs[1];
do
cout << c1.as_string<< '\n';
while (++rs);
c1.release();
rs.release();
cn.close();
}
catch (oralib::error &e)
{
std::cout << e.details ();
}
}
Originally posted by: OhmegaStar
Hi,
When a Fetched Recordset contains a column that may contain NULL values if I try and read such Column (containing NULL) I get a throw in column.cpp line 141
I was expecingt to get a pointer to a NULL string or an Empty String...
Can anybody please advice ???
Thanks
Henrik
Originally posted by: OhmegaStar
I've been trying to implement your OCI rapper in a win32 (console - no mfc no atl) application..
However I get Linker Errors 2019 Unresolved External Symbol For each Method / Function I try and use in the object...
I can't even use
oralib::connection cn (....)
So I'm kind of stuck.. and Ive been trying to figure out what was wrong by myself to no avail.. (im new at C++ / Visual C++).....
I'm completely baffled as the use of the wrapper seemed so simple, as well as the configuration needed to implement it into my project... but apparantly not ..
Any Hints ?? (a step by step to Hello Oracle in VS7 would be top!)
Thanks in advance,
Henrik Ohm
Reply