RE: Stored Procedures Question

2001-10-31 Thread Long . Nguyen
I am not familiar with these suffixes (PKS, FNC etc). Are these store procedure files created by some software like Oracle Designer? Long -Original Message- Sent: Thursday, 1 November 2001 3:56 AM To: Multiple recipients of list ORACLE-L Ken, To see exactly how the stored procedure f

Re: Stored Procedures Question

2001-10-31 Thread Connor McDonald
Stored procedures will most typically be used by an application that uses the database. If the application does not use them explicitly, then there is most likely implicit use via triggers (ie triggers call procedure etc) hth connor --- Ken Janusz <[EMAIL PROTECTED]> wrote: > I received the DD

RE: Stored Procedures Question

2001-10-31 Thread Jack C. Applewhite
Ken, To see exactly how the stored procedure files will be used, you'll need to examine the DDL script to find out how they're called. That might tell you which directory in which to put them. If you have to run them manually, do it after the DDL script finishes. Execute (from SQL*Plus) all the