Re: Can a procedure contain only a SELECT statement?

From: Serge Rielau <>
Date: Tue, 23 Mar 2010 08:49:19 -0400
Message-ID: <>

Half of the uses of autonomous transactions I see when enabling Oracle applications wrap DDL statements.

If Oracle programmers don't need local temp tables then what is BULK COLLECT, FORALL and INDEX BY all about?
They are everywhere!

Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
Received on Tue Mar 23 2010 - 07:49:19 CDT

Original text of this message