Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Location
    Croatia, Zagreb
    Posts
    12

    Unanswered: Procedure compiled with errors

    I need little help with my procedure. Procedure is compiling with errors. What could be a problem? Many thx in advance.
    I submit here full documentation of my procedure:

    Code:
    create or replace
    PROCEDURE PROMJENA_CIJENA(MODELPOST_V_ID NUMBER) AS
    LAGER_KOL NUMBER;
    
    BEGIN
     SELECT STANJE_LAGERA
     INTO LAGER_KOL
     FROM MODEL_VOZILA
     WHERE ID_MODEL_V = MODELPOST_V_ID;
     
     IF LAGER_KOL <= 5
     THEN
     UPDATE MODEL_VOZILA
     SET CIJENA_MODELA = CIJENA_MODELA * 0.2
     WHERE ID_MODEL_V = MODELPOST_V_ID;
     
     COMMIT;
     
     DBMS_OUTPUT.PUT_LINE('Izvršeno je umanjenje cijene vozila u visini 20% za model'||MODELPOST_V_ID);
     
     ELSE
     
     DBMS_OUTPUT.PUT_LINE('Cijena vozila je ostala nepromijenjena za model'||MODELPOST_V_ID);
     
     END IF;
     
     EXCEPTION
      WHEN NO_DATA_FOUND
      THEN DBMS_OUTPUT.PUT_LINE('Ne postoji takav model vozila.');
     
     END PROMJENA_CIJENA;
    Last edited by Pat Phelan; 05-25-10 at 19:10. Reason: Corrected minor netiquette problem
    Noli turbare circulos meos.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    And the real error message is?

  3. #3
    Join Date
    Jun 2009
    Location
    Croatia, Zagreb
    Posts
    12
    There are no real message error. Compiling finishes, in details says information about compiling with error end when i run procedure, nothing happens. Surely, refresh tables, data content, etc. and still nothing.
    Update simple isn´t happening. Tryed with SQL Developer, and also, try to run that scrypt in NAVICAT and genious(relative, maybe simply my mistake) asks me for MODELPOST_V_ID value.
    Noli turbare circulos meos.

  4. #4
    Join Date
    Jun 2009
    Location
    Croatia, Zagreb
    Posts
    12
    Sry, I missed info, there are error when i want to run statement.
    o.d.r.utils.DBObject Could not get schema Object:java.SQLException:ORA-04063: view "SYS.ALL_QUEUE_TABLES" has errors
    Noli turbare circulos meos.

  5. #5
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    FiZor,

    the error message you posted is related to the queuing system (very serious, but not related to your problem, unless you try to start something as a job)

    Recreate your procedure and look for the error code

    Example:
    Code:
    SQL> create or replace procedure p_test as begin dbms_out.put_line('just a test'); end;
      2  /
    
    Warning: Procedure created with compilation errors.
    
    SQL> show error procedure p_test
    Errors for PROCEDURE P_TEST:
    
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    1/27     PL/SQL: Statement ignored
    1/27     PLS-00201: identifier 'DBMS_OUT.PUT_LINE' must be declared
    
    SQL> create or replace procedure p_test as begin dbms_output.put_line('just a test'); end;
      2  /
    
    Procedure created.
    
    SQL> show error procedure p_test
    No errors.
    
    SQL>
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •