Hi. I've followed the example titles "Example: Reading a set of records from an Oracle stored procedure." found in the file dtl/docs/sql_iterator.htm to call...
Ronen, You are indeed doing something wrong. sql_iterator will use prepare/execute - but it can't prepare if you recreate the iterator every time! You want ...
Another problem I encountered: I have the following stored procedure: TYPE result_set IS REF CURSOR; PROCEDURE my_proc_out (a_name NUMBER, a_value VARCHAR,...
There is a requirement in ODBC that variable length strings have to be the last parameter. Here your last parameter is instead the result_set which may be the...
I looked in dtl\docs\BoundIO.htm and saw that the ETI_Map is supposed to support tcstring, but it didn't work. I changed the line params[1] << row._string(); ...
Hi Ronen, I fact you are correct we don't support fixed strings in variant_row due to the fact that I didn't get around to writing code to figure out the size...
... variant_row due to the fact that I didn't get around to writing code to figure out the size of the fixed string and dyanamically resize the buffer as...
Now that I hope I solved the string problem, I'm trying this, and it doesn't work as I expected. I'm using the exact code and still there's no SQLPrepare, only...
Hi Ronen, It could be that once you assign params we force a re-execute out of caution? One way to check would be to examine the it.stmt variable. This should...
Hi Yuval, I'd have to trace the code to check, but try just overriding it to set bPrepare to true for your iterator. (Or just set bPrepare to true in the...
Hi, I have tried to convert/use the DTL in VS2005 (using UNICODE) and have found the following issues (so far): * Line 448 in BoundIO.h need to be commented...
I also get the following error: 'type cast' : conversion from 'SDWORD' to 'SQLPOINTER' of greater size at SQLSetStmtAttr(hstmt, Attribute, (SQLPOINTER)...
OK. Please send me a zip of the changed files when you are done, I will take a look and check into cvs. I'm a bit surprised you are getting this many since I...
I added the line it.GetStmt().SetPrepare(true); after the line DBView<variant_row, variant_row>::sql_iterator it = view.begin(), last = view.end(); and it...
Hi. When Oracle's stored procedure throws an exception, there's an integer error code, and a string description. It looks as if dtl::RootExcpetion holds only...
It seems that I can't call a stored procedure that doesn't have a ref- cursor. The DTL code has a 'if (this->boundIOs.NumColumns() < 1)' check in method...
You can call a sql_iterator that doesn't return a cursor. Just assign to the iterator or increment it to force an execution. (The skipped statment there is...
Since this is a C++ crowd list, I thought people might be interested to learn about a great C++ general purpose library that just went free (under Boost...
Hello, I hope this is a trivial question to answer - but it's driving me nuts! I have the small example program quoted below. It does what it is supposed to do...
Hi, I can think of a few things to try here. 1. Add a Commit() call after your inserts. By default DTL does not force a commit to let you control exceptions....
Hmm. Maybe I wasn't clear enough. You would need to have something like typedef DBView<variant_row, variant_row> View; View view("{CALL my_package.my_proc(?,...
ODBC has some issues with variable length strings in that they have to be the last arguments passed as parameters. Two ways to fix this: 1. Use fixed length...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
