<span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">Здравствуйте, Alex Krasov, Вы писали: А>>Hello, А>>Does BLT support Oracle stored procedures.</span> Hello, Alex Krasov, you wrote: A>> Hello, A>> Does BLT support Oracle stored procedures.</span> <span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">I've tried numerous methods, described below to get it to work but no luck.</span> I've tried numerous methods, described below to get it to work but no luck.</span> <span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">The stored procedure updates a table with several values.</span> The stored procedure updates a table with several values.</span> <span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">This is the stored procedure, a small test procedure.</span> This is the stored procedure, a small test procedure.</span> <span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">AK>have you tried the tests supplied with the BLT?</span> AK> have you tried the tests supplied with the BLT?</span> <span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">I personally didn't used the Oracle ones, but tests for the MSSQL were helpful for me.</span> I personally didn't used the Oracle ones, but tests for the MSSQL were helpful for me.</span> <span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">You can find the DB creation scripts for each supported database under the "Data\Create Scripts" folder.</span> You can find the DB creation scripts for each supported database under the "Data \ Create Scripts" folder.</span>
Yes, I've tried the unit test and no joy. I took the single stored procedure test sql, created the SP in Oracle and tried the various method described before hand with SP name, and it didn't work. Then finally I took the BLT.4 codebase and added a console app and debugged stepped through codebase, watching it prepare the params and calling the SP, and it didn't work.
The last thing I did was created and old style ADO.NET OracleConnection with OracleCommand and adding OracleParameter's method of calling an SP and that worked fine, on XE and 11g. It did the update. I've tried the BLT.4 on 10.2 XE and 11g Enterprise and complete fail. I suspect is sending null params, but I don't know for sure.
It works flawlessly in SQL Server 2008/2005. Its works pefectly.
It's really starting to get me down. It needs to work.
