The sql-server part of poshcodegen is nearly complete. And I'm using it in daily work.
The oracle part is a bit harder. Revisiting some old code I stumbled too often about #ToDo Comments. So its going on a little slower than expected.
Thinking that you prefer viewing at some real code, I post one of the Orcale test functions in Poshcode. Perhaps someone finds it there, just as I found the orginal http://poshcode.org/1011 from Steven Murawksi.
If your daily job is running ad hoc queries and stored procedure calls against SQL-Server Databases you may find something useful.
If you know how to access another RDBMS please join the project.
If you find a bug please send feedback. This is a complex area and it was too easy to introduce faults. We don't have automatic testing yet, but there is a rather complete set of test stored procedures for SQL-Server and for Oracle.
The second pitfall: too often the functions run perfectly too hours, but starting a fresh PowerShell I get errors. Often this is causes by the need to keep our own connection strings secret.
But now something useful, as far as you use ORCLE:
download | new post
Posts
Pure Capsaicin at Spiceworks!
vor 9 Monaten
Hello, I'm hoping you can help me out with this. I've written a script to retrive data from Oracle. Everything works so far. However i'm trying make this script portal. Problem is that the script is currently depending on the ODP for .NET. I read that you can use the Oracle instant connect which is small and doesn't require installation. Do you know how I would approach this problem?
AntwortenLöschenSorry I guess you got it wrong.
AntwortenLöschenI have ODP installed on my systems and I believe that Oracle.DataAccess refers to those components.