title: How to run a stored procedure in oracle sql developer?
body: <p>I'm trying to run this stored procedure </p>
  
  <pre><code>DECLARE
    P_TICKER_SERIAL VARCHAR2(200);
    P_SECTOR_CODE   VARCHAR2(200);
    P_SOURCE_ID     VARCHAR2(200);
    P_COUNTRY_CODE  VARCHAR2(200);
    P_FILTER_TYPE   NUMBER;
    CUR_OUT         SYS_REFCURSOR;
    dbUserTable     DBUSER%ROWTYPE;
  BEGIN
    P_TICKER_SERIAL :='14232';
    P_SECTOR_CODE   := '15';
    P_SOURCE_ID     := 'TDWL';
    P_COUNTRY_CODE  := 'SA';
    P_FILTER_TYPE   := 1;
  
    PKG_name.GET_user(
      P_TICKER_SERIAL =&gt; P_TICKER_SERIAL,
      P_SECTOR_CODE   =&gt; P_SECTOR_CODE,
      P_SOURCE_ID     =&gt; P_SOURCE_ID,
      P_COUNTRY_CODE  =&gt; P_COUNTRY_CODE,
      P_FILTER_TYPE   =&gt; P_FILTER_TYPE,
      CUR_OUT         =&gt; CUR_OUT
    );
    open CUR_OUT;
    LOOP
      FETCH CUR_OUT INTO dbUserTable;
      dbms_output.put_line(dbUserTable.email);
    END LOOP;
    CLOSE CUR_OUT;
  END;
   /
  </code></pre>
  
  <p>But it gives me this error </p>
  
  <pre><code>Error report:
  ORA-06550: line 8, column 15:
  PLS-00201: identifier 'DBUSER' must be declared
  ORA-06550: line 8, column 15:
  PL/SQL: Item ignored
  ORA-06550: line 24, column 2:
  PLS-00382: expression is of wrong type
  ORA-06550: line 24, column 2:
  PL/SQL: SQL Statement ignored
  ORA-06550: line 26, column 24:
  PLS-00320: the declaration of the type of this expression is incomplete or malformed
  ORA-06550: line 26, column 5:
  PL/SQL: SQL Statement ignored
  ORA-06550: line 27, column 28:
  PLS-00320: the declaration of the type of this expression is incomplete or malformed
  ORA-06550: line 27, column 7:
  PL/SQL: Statement ignored
  06550. 00000 -  "line %s, column %s:\n%s"
  *Cause:    Usually a PL/SQL compilation error.
  *Action:
  </code></pre>
  
  <p>Any one knows  what is wrong ?
  Thanks.</p>