Re: [Haskell-cafe] re: Oracle stored procedures

2010-09-10 Thread Peter Marks
Hi Leonel Thanks for your response. I don't know much about Oracle, but it has been suggested that this approach of calling a stored procedure via SQL won't work on a database that has security locked down to ensure all database access is via stored procedures. All our production databases are

[Haskell-cafe] re: Oracle stored procedures

2010-09-10 Thread Leonel Fonseca
Hi, Peter I did and uploaded some examples regarding Oracle and Takusen and the intended approach you would employ. Example 01: Create table and some tuples. http://hpaste.org/fastcgi/hpaste.fcgi/view?id=29883#a29883 Example 02: Create a package with procedures to mantain the table.

[Haskell-cafe] re: Oracle stored procedures

2010-09-08 Thread Leonel Fonseca
Hi Peter, Yes, from Takusen you can call Oracle stored procedures, functions, packaged stored procedures or functions, or execute an arbitrary pl/sql block. In the Takusen software release there is a directory called Database\Oracle\Test. There,  Enumerator.lhs, among other code has these