How to run a stored procedure in oracle sql developer

Question

I m trying to run this stored procedure   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       But it gives me this error   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    Any one knows  what is wrong   Thanks

User · Accepted Answer

Try to execute the procedure like this   var c refcursor  execute pkg name get user  14232    15    TDWL    SA   1   c   print c

User · Answer

Consider you ve created a procedure like below   CREATE OR REPLACE PROCEDURE GET FULL NAME like     FIRST NAME IN VARCHAR2     LAST NAME IN VARCHAR2    FULL NAME OUT VARCHAR2    IS  BEGIN   FULL NAME   FIRST NAME           LAST NAME  END GET FULL NAME    In Oracle SQL Developer  you can run this procedure in two ways   1  Using SQL Worksheet  Create a SQL Worksheet and write PL SQL anonymous block like this and hit f5  DECLARE   FULL NAME Varchar2 50   BEGIN   GET FULL NAME  Foo    Bar   FULL NAME     Dbms Output Put Line  Full name is       FULL NAME   END    2  Using GUI Controls   Expand Procedures Right click on the procudure you ve created and Click Run In the pop-up window  Fill the parameters and Click OK    Cheers

User · Answer

-- If no parameters need to be passed to a procedure  simply   BEGIN    MY PACKAGE NAME MY PROCEDURE NAME END

[oracle] How to run a stored procedure in oracle sql developer?

Examples related to oracle

Examples related to stored-procedures