1 Reply Latest reply on Oct 8, 2008 6:09 AM by 597368

    Create table in parameter

    662880
      I want to create a table inside a procedure....
      The table i want to create must be from inparameter...
      lets say ...
      ________________________________________________________________
      CREATE OR REPLACE Procedure newtable(
      P_TABLENAME      in Varchar2)
      IS
      V1 VARCHAR2(500);
      BEGIN
      V1:= 'Create table TEST_ETT AS SELECT * FROM upper(P_TABLENAME)';
      Execute immediate V1;
      END;

      ________________________________________________________________
      Is this posible? ,The procedure part works, but not when i use the inparameters:
      ________________________________________________________________

      BEGIN
      add_column('CHEF');
      END;
      ______________________________________________________