8/30/2007 8:54:13 AM

Compared to any DB native language, writing stored procedures this way looks a very tedious task - you have to declare and code everything.

In PL/SQL you would just write

PROCEDURE INSERT_BOOKMARK(ATITLE IN VARCHAR..., ABOOKMARK_ID OUT NUMBER)

IS

BEGIN

 INSERT INTO BOOKMARKS(BOOKMARK_ID, TITLE...

 VALUES(SEQ_BOOKMARKS.NEXTVAL, ATITLE...)

 RETURNING BOOKMAR_ID INTO ABOOKMARK_ID;

END;

and the PL/SQL compiler/engine will take care of parameters, types, assignments... one line of code against how many??? That's probably why almost noone writes Java stored procedures - I'll stay away from .NET ones and BlackFishes too - better to use an Oracle Express instance.

http://

9/5/2007 11:12:12 AM

There probably is a method overload that lets you construct and assign a parameter in one line. Also, I think it is not so much about simple SP. It is the compfort of having .NET lib support creating queries and having logic all in the same place.

What would be even more interesting is if it is possible to construct a query in an Objectoriented  style.

Something like

Query q = new Query(DbSchema).Where(...).In(...)

El

http://