Live ORACLE

CREATE PROCEDURE Calc_stats

     (w  NUMBER,

      x  NUMBER,

      y  NUMBER,

      z  NUMBER)

IS

BEGIN

  dbms_output.Put_line(w + x + y + z);

END;

/


DECLARE

  a            NUMBER := 4;

  b            NUMBER := 7;

  plsql_block  VARCHAR2(100);

BEGIN

  plsql_block := 'BEGIN calc_stats(:x, :x, :y, :x); END;';

 

  EXECUTE IMMEDIATE plsql_block

   USING a,b;

END;

/

Using Duplicate Placeholders With Dynamic SQL