Oracle package body error

2012-05-11  Source: Original Site  Category:Oracle  Views:1 

Advertisement

With the following line of code i am having problems with the following line of code ...

sql := (
' IF INSERTING THEN '||CHR(10)||
' v_operation := ''INSERT''; '||CHR(10)||
' ELSIF UPDATING THEN '||CHR(10)||
' v_operation := ''UPDATE''; '||CHR(10)||
' ELSE '||CHR(10)||
' v_operation := ''DELETE''; '||CHR(10)||
' END IF; '||CHR(13));
When I execute my package body I get an error with the above in my package ...

any ideas why ?

Related articles
  • Oracle package body error 2012-05-11

    With the following line of code i am having problems with the following line of code ... sql := ( ' IF INSERTING THEN '||CHR(10)|| ' v_operation := ''INSERT''; '||CHR(10)|| ' ELSIF UPDATING THEN '||CHR(10)|| ' v_operation := ''UPDATE''; '||CHR(10)||

  • Oracle Package Body Errors 2015-05-11

    there, could someone please explain why I'm getting this error, when TOAD confirms that the package is valid. "package body SNHLIVE.PROCESS_UPLOAD has errors ORA-06508 could not find program unit" I'd really appreciate any help on this one.

  • Oracle package body "SYS.DBMS_REFRESH_EXP_LWM" has errors 2013-11-02

    following Problem by exporting user tables: Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production With the Partitioning option JServer Release 8.1.7.3.0 - Production Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR

  • Oracle package body "SYS.PRVT_HDM" has errors 2015-04-04

    Each hour, i have this message in my alert log: "~Errors in file d:\oracle\admin\lgyp\bdump\lgyp_m001_7968.trc:~ORA-00604: error occurred at recursive SQL level 1~ORA-04063: package body "SYS.PRVT_HDM" has errors~ORA-06508: PL/SQL: could not find pro

  • Oracle package body "EXFSYS.DBMS_RLMGR_DR" has errors 2013-01-08

    I am facing this error, can someone pls help? ORA-12012: error on auto execute of job 42791 ORA-04063: ORA-04063: package body "EXFSYS.DBMS_RLMGR_DR" has errors ORA-06508: PL/SQL: could not find program unit being called: "EXFSYS.DBMS_RLMGR_DR" ORA-0

  • Oracle Package body compilation errors 2015-05-08

    After running utlrp.sql, I have been left with the following invalid objects (owner: SYS Object type: PACKAGE BODY): LT LT_CTX_PKG LTADM LTDDL LTDTRG LTUTIL OWM_DDL_PKG OWM_MIG_PKG OWM_REPUTIL UD_TRIGS WM_DDL_UTIL I have tried to compile some of them

  • Oracle Package Body in an invalid state after installing HTMLDB 1.6 on a 9.2.0.4 2012-04-27

    I'm encountering a strange situation after installing HTMLDB 1.6 on an Oracle DB 9.2.0.4 Actually I got one package body in an invalid state. It concerns the www_flow_item package body. When I tried to compile it, I got the error below Line # = 15381

  • Oracle PACKAGE BODY SYS.DBMS_AQADM_SYS is Invalid 2013-01-09

    Can any one help me with this error. I get this error when I recompile DBMS_AQADM_SYS. I am using Oracle 9i Release 2 PACKAGE BODY SYS.DBMS_AQADM_SYS On line: 1171 PLS-00302: component 'AQ$_QUEUES' must be declared

  • Oracle Package body not found during Advanced Replication 2014-05-28

    I am trying to do an advance replication between 2 machines. I am trying to replicate the contents (tables) belonging to a specific user on instance A located on machine 1 to an instance B on machine 2. I am runnig to scripts on each machine to do th

  • Oracle package body "SYSTEM.DBMS_SCHEDULER" does not exist 2013-01-24

    Having issues just getting the basics installed/working correctly. I ran .. SQL> @$ORACLE_HOME/rdbms/admin/dbmssch.sql; Package created. No errors. Package created. Synonym created. Grant succeeded. And then I just try some basic scheduler command

  • Oracle package compile error.... 2013-03-16

    This is just sample package. There are compile errors....does anyone know where or what it is? CREATE OR REPLACE PACKAGE BODY TEST_PAK2 IS FUNCTION B RETURN VARCHAR2 IS v_acpt_ymd varchar2(8); BEGIN SELECT TO_CHAR(SYSDATE,'YYYYMMDD') INTO v_acpt_ymd

  • Oracle Package creation error 2013-05-30

    I had done something like this before, but successfully, with no errors. Any idea why I'm getting the error now? It's telling me I have failed to declare the package name. Here's the code PROCEDURE insert_vote_dev(p_ctid IN NUMBER,p_busvp IN VARCHAR2

  • Oracle package and error 2013-12-08

    Hi, I have a package and error like this, could you please help me what is the problem in this. Thanks. create or replace package emp_pkg as procedure update_sal (p_empno number, p_sal in out number); end emp_pkg; create or replace package body emp_p

  • Oracle package body issue 2014-04-14

    I wrote a package body. I get following error. 1/14 PLS-00201: identifier 'WOC_DELETE_MODEL_DATA' must be declared 1/14 PLS-00304: cannot compile body of 'WOC_DELETE_MODEL_DATA' without its specification 0/0 PL/SQL: Compilation unit analysis terminat

  • Oracle package compilation error with database link 2014-08-24

    I am getting the following error while trying to compile a package. PACKAGE AMPS.MPAP2365_PKGA created. Creating PACKAGE BODY AMPS.MPAP2365_PKGA... Warning: Package Body created with compilation errors. Errors for PACKAGE BODY AMPS.MPAP2365_PKGA: LIN

  • Oracle Package body does not compile in Object Browser 2014-09-13

    I am trying to compile a package body using the Apex Object Browser. However, when I click the "Compile" button no message is displayed in the box above the package body code. I reduced the amount of code by removing comments and extra carriage retur

  • Oracle Package Body - SELECT on Table Permissions? 2014-12-09

    (Package Names and User ID's in this post have been changed for security reasons.) Here's the situation: I have a PACKAGE named PKG_ADDRESS that I have had to move from one user's schema (PETER) to another's (TOMMY). All the tables that it has to acc

  • Oracle package body dbms_network_acl_admin is invalid 2015-04-07

    package body dbms_network_acl_admin is invalid ( Error(1): PLS-00753: malformed or corrupted wrapped unit ) where can i find source for recreating it

  • Oracle Package Body from SQL Developer ? 2012-03-29

    Team I am using SQL Developer Version 2.1.1.64 But I can not able to see the package body. Right click on the package provides an option to 'Save Package Spec and Body', but when I save it .. it only store the package spec .. Is it not possible to vi

  • Oracle package body variable- is it always safe to use it? 2014-06-11

    In a package spec i have a function "function1" and in package body this functions does following: 1) it evaluate/calculate a variable/value "Flag1". 2) it calls 4 (package body) functions that needs to use value "Flag1". I have forgotten how "packag