Results 1 to 2 of 2

Thread: I cant create a stored procedure on DBeaver

  1. #1
    Join Date
    Dec 2020
    Posts
    2

    Lightbulb I cant create a stored procedure on DBeaver

    Hi, How a package can be created in Dbeaver?

    I want to put a stored procedure inside...

    Im getting the error:

    the object JHON_HERNANDEZ doesnt exist

    ON declaration:
    CREATE OR REPLACE PACKAGE JHON_HERNANDEZ AS

    elim_art (numero in char)

    END JHON_HERNANDEZ;


    Body:
    CREATE OR REPLACE PACKAGE BODY JHON_HERNANDEZ AS

    create or replace procedure elim_art (numero in char) is begin

    dbms_output.put_line(numero);
    end; /

    END JHON_HERNANDEZ;

    Is there something wrong with the structure? its a Dbeaver bug? I have this: enter image description here

    I give secundary click and create a new package, this appears: CREATE OR REPLACE PACKAGE BODY JHON_HERNANDEZ AS -- Package body END JHON_HERNANDEZ;

    When I try to compile it: The object JHON_HERNANDEZ doesnt exist Sql=Alter package JHON_HERNANDEZ compile, OriginalSql= Alter package JHON_HERNANDEZ compile, Error Msg= ORA-04043: the object doesnt exist

    Please help me... i have several days on this

  2. #2
    Join Date
    Dec 2020
    Posts
    2
    The solution was:
    close the tab ... it asks if you want to persist and you say yes

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •