Results 1 to 2 of 2

Thread: Procedures

  1. #1
    Join Date
    Feb 2005
    Location
    Barcelona
    Posts
    42

    Question Unanswered: Procedures



    CREATE OR REPLACE PROCEDURE suma (a IN integer)
    AS
    BEGIN
    a := a + 1;
    IF a = 5 THEN
    RAISE_APPLICATION_ERROR (-20000, 'Se ha iterado 5 veces');
    END IF;
    suma(a);
    END;
    .
    run

    17110 Warning: la ejecución ha terminado con advertencias

    Which is the problem?


  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    SQL> SHOW ERROR

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    4/1 PLS-00363: expression 'A' cannot be used as an assignment target
    4/1 PL/SQL: Statement ignored

Posting Permissions

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