Re: Q: Some questions on PL/SQL
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1996/01/22
Message-ID: <4e10i9$eic_at_bytor.lerc.nasa.gov>#1/1
Date: 1996/01/22
Message-ID: <4e10i9$eic_at_bytor.lerc.nasa.gov>#1/1
Hello, Ron:
Aside from performance, packages allow information to persist between procedure invocations. See the Oracle docs for performance considerations. Also, one may selectively hide package content (by omitting it from the specification).
You should be able to call a procedure from any venue. Try calling the procedure by its fully qualified name (schema.procedure_name), although this should not strictly be necessary.
Regards,
Gary
-- __________________________________________________________ Gary Gapinski email: gapinski_at_lerc.nasa.gov NASA Lewis Research Center voice: +1 216 433 5251Received on Mon Jan 22 1996 - 00:00:00 CET