Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Implicit Statement Results in Oracle Database 12c Release 1 (12.1) (DBMS_SQL.RETURN_RESULT and DBMS_SQL.GET_NEXT_RESULT) - Implicit statement results will simplify the migration of stored procedures from other database engines to Oracle 12c onward.



Mark said...

Thanks for the article. I can't help thinking that this dilutes the formality of the language and routine specification. Personally I hate side effects and if the code was wrapped, it wouldn't be obvious that a record set was being returned. Return values from a procedure? That should be a function!

Tim... said...

Hi.

I tend to agree with you. If you are an Oracle person you will probably never use it. If you are working on a migration project from SQL Server to Oracle, you will love this because it will save you refactoring all your client code that relies on this feature of T-SQL.

Cheers

Tim...

Mark said...

Agreed.... Thanks for the reply.

Mark said...

Hi Tim,

A little controversial perhaps but I suspect a lot of people won't be using this feature. There seems to be a new design paradigm where the middle-tier is responsible for business logic to promote database independence. Any ideas where this comes from? Do you have any opinions on the subject?

Tim... said...

Hi.

If you speak to a .NET or Java person, they will say middle tier. If you speak to a database person, they will say database. They all have their +/- points. :)

The answer is database. :)

Cheers

Tim...

Mark said...

Good call Sir!

We just need to convince the thousands of middle tier developers.

Tim... said...

That is going to take some doing. :)

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired