WebAug 7, 2009 · My package spec and body looks like: CREATE OR REPLACE package testing as type t_cursor is ref cursor; procedure proc_test(v_deptno number,v_out_cur out t_cursor); end; / CREATE OR REPLACE package body testing as procedure proc_test(v_deptno number,v_out_cur out t_cursor) as begin open v_out_cur for select empno,ename,sal from … WebQuestion: How do I recompile a set of PL/SQL packages? Answer: The DBA will have to recompile a PL/SQL packages whenever there are changes to tables, views, sequences, and so on that the package procedures and functions reference.This is accomplished through the use of the CREATE OR REPLACE PACKAGE [BODY] form of the CREATE PACKAGE …
CREATE PACKAGE BODY Statement - docs.oracle.com
WebMay 16, 2013 · As one can grant execute privilege on a package specification as follows. SQL > grant execute on . to ; How to grant execute privilege on … WebJul 26, 2012 · I would like to know if anyone has a query to search a package body for a particular word and then return all of the procedure names where that word (or words) are … boxwoods turning red
Query to get the contents of the package body - Oracle Forums
WebApr 10, 2024 · In Oracle iSupplier Portal, Release 12.1.3, after performing the EBS CPU patching, there is an invalid package body POS_SPM_WF_PKG1. It is known to occur with … WebJan 28, 2024 · Symptoms. Invalid SYS objects cannot be recompiled. ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLTUNE". When the DBA tried to recompile this package body (as sysdba), it complained that a number of sys views were invalid. When DBA checked, it was found that many SYS views were invalid, particularly … WebJul 13, 2009 · I would like to keep an eye on a PACKAGE BODY that's being modified which invalidates usage. I realize I can do this using: SELECT owner, object_name, object_type, status, last_ddl_time FROM dba_objects WHERE object_name = 'GOLF_CONTEST_PKG' AND owner = 'GOLF_OWNER' AND object_type = 'PACKAGE BODY' / However, I need to know … boxwood subdivision lynchburg va