Dave Cramer said: > Can you explain what you mean by this? > > On Fri, 2004-01-02 at 20:21, Andrew Dunstan wrote: >> Will we need to address this TODO item: >> >> . Add capability to create and call PROCEDURES >> >> before proceding to do PL/Java? It would add to the usefulness >> greatly, I should think. I'm not sure how hard it would be. >>
Well, it is syntactically unclean IMNSHO to have to define a return type on an SP when you don't really need one, and to have to call it by saying "select foo(bar)" rather than "call foo(bar)". Also, IIRC PL/SQL lets you bind host language variables to OUT parameters of such SPs, which can be quite useful. (It's a year or three since I touched Oracle in anger.) I would be mildly surprised if the SQL/JRT standard didn't expect to be able to bind to static methods of type void. (The item I quoted is on the TODO list - I didn't invent it ;-) cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])