Re: ORACLE 7.2

Some more things to add:

DBMS_JOB, which will you allow you to schedule stored procedures to run at a certain time (without resorting to the operating system in a cron job). I believe this is actually beta in 7.1, and is in fact shipped. Check out dbmsjob.sql in $ORACLE_HOME/rdbms/admin.

Cursor variables! You will be able to pass a cursor variable to a stored procedure, have the procedure open it for a VARIABLE query, and then fetch from it on the client. So you don't have to return lots of PL/SQL tables. (This is my favorite new feature). Useful mainly in the precompilers and OCI.

In article <D6BEsB.F2J_at_eskimo.com>, lparsons_at_eskimo.com (Lee Parsons) writes:
|> Tony Jambu <aaj_at_phantom.telecom.com.au> wrote:
|> >1. When Oracle 7.2 is due for release?
|> > I heard a rumour that it should be in the next month or so.
|>
|> Ditto. Support Sez April. but we know what is worth.
|>
|> >2. What are the new features?
|>
|> From the 7.2 Fact Sheet and my local Rep:
|>
|> Create Table as Select to do the insert in parallel
|>
|> Create Index Parrallel to use Direct Path and Unrecoverable option
|>
|> OCI 7.1 to provide non-blocking calls.
|>
|> ProC 2.1 to officially support embedded sql in C++
|>
|> PL/SQL 2.2 to support a 'binary source' format so source need not
|> be shipped with apps.
|>
|> Datafiles can be dynamically resized. Yeaaaa!
|>
|> DBA's can active tracing for a session other than her own. Yeaaa!*2
|> (I believe this implies running sessions, but the info I have is unclear)
|>
|> SQLNet to allow 'distributed authentiction mechanisms'
|> (My rep sez this means finger prints, voice/retina scans if you have
|> a 3rd party product to supply them. I'm not sure this will be in the
|> Sqlnet they ship everybody or in a seperate product)
|>
|> Secure Network Services v1 to support full network datastream encryption
|> (yet another purchasable product?)
|>
|> There are of course a fist full of others. but they seem pretty vanillia.
|> --
|> Regards,
|>
|> Lee E. Parsons
|> Systems Oracle DBA lparsons_at_world.std.com
Received on Sat Apr 01 1995 - 00:00:00 CEST