stored procedures

From: P. Singleton <csa09_at_seq1.keele.ac.uk>
Date: 13 May 92 20:12:19 GMT
Message-ID: <2718_at_keele.keele.ac.uk>


Can I save compiled, optimised SQL or PL/SQL commands/blocks in my Oracle (V6) kernel, to avoid the overheads each time I call them?

Can I parameterise the constants in comparisons?

Is this a reasonable wish?


  __   __    Paul Singleton (Mr)           JANET: paul_at_uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul_at_cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 621111 x7355
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082
Received on Wed May 13 1992 - 22:12:19 CEST

Original text of this message