Procedure - Oracle

Gostaria de saber como compilar e executar uma procedure assim:

create or replace procedure SP_MON_CrudPrazosEntrega
() as
lTxSql clob;
begin
lTxSql := 'Select sysdate from dual';

Open lCrsReturn for lTxSql;
DBMS_SQL.RETURN_RESULT(lCrsReturn);
end SP_MON_CrudPrazosEntrega;

 

Execute:

begin SP_MON_CrudPrazosEntrega(); end;

 

Não consigo ver o resultado usando o DataGrip.

0
1 comment

Hi,

Are you sure that your psql is correct?
Thank you.

0

Please sign in to leave a comment.