Re: Reports & "Uncompiled Procedures" error

From: Louise Miller <miller_at_louise.ucsd.edu>
Date: 1995/09/12
Message-ID: <1995Sep12.211444.9352_at_nosc.mil>#1/1


Try running a script that recompiles all of the procedures right before they run. It's ugly, but it works. We have a similar setup in forms and some scritps that call database procedures. We drop synonyms every day, and we've found that we need to recompile the database procedures explicitly, rather than letting them "automatically" (HAH!) compile when they are called.

in your SQL script.....

ALTER PROCEDURE name_of_procedure COMPILE;

By the way...if you grant on the tables used by a database procedure via a role rather than explicitly, you will have problems. I don't know why. You need to grant the table name, not the role.

Louise Miller Received on Tue Sep 12 1995 - 00:00:00 CEST

Original text of this message