Content Inside :
When would you use a stored procedure/function? – One good rule of thumb: Any time that the same task must
be performed numerous times by multiple programs Why use a stored procedure/function over a DLL (Windows system file)? – Stored routines have benefit over file based programs: Database resident Stability We already have developed stored routines – What do file based program have over stored routines? Easier to fix if a bug occurs – A fix to a stored procedure may require exclusive database access. The current production release of SQL*Net for Rdb (v1.0.2.5) does not include native interface stored routine support, Don’t have to re-code the routine in C, PL/SQL, Cobol, SQL, Fortran, etc. Oracle advanced PL/SQL tutorials. There are two methods to fetch and process information in your PL/SQL blocks.
Tags : oracle development tools, native interface, sql tutorials, routine support, dll windows, rule of thumb, pl sql, rdb, database access, cobol, windows system, fortran, oracle, benefit
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.