title: Create a parameterless procedure
body: <p>I am trying to create a parameterless procedure that is used to take columns from a table and do some modifications to it and paste it into another table. But I am getting the following errors:
  Procedure DEMO compiled</p>
  <pre><code>LINE/COL  ERROR
  --------- -------------------------------------------------------------
  4/2       PL/SQL: SQL Statement ignored
  8/10      PLS-00403: expression 'NET.NETSALARY' cannot be used as an INTO-target of a SELECT/FETCH statement
  8/24      PL/SQL: ORA-00904: : invalid identifier
  </code></pre>
  <p>Errors: check compiler log<br />
  My code used for this in sql is :</p>
  <pre><code>    create or replace procedure &quot;DEMO&quot; 
      as 
      begin 
          case when comm is null then 0.9*grosssalary 
          when comm&lt;500 then 0.85*grosssalary 
          else 0.8*grosssalary end 
          into net.netsalary from (select salary+comm as grossSalary,comm from 
          employee) ;
  
           end ;
            /
  </code></pre>
  <p>I am trying to insert the data into column netsalary of table net.
  Please mention where did I go wrong?
  Thanking you in advance.</p>