Originally posted by suityou01
View Post
EXEC is a SQL*Plus command to execute the procedure from the command line.
The following works fine for me in APEX, so should be fine in any other version of the database from 8i onwards (all I did was remove the word exec from your example):
Code:
create or replace procedure sp_add_comment_type ( p_comment IN VARCHAR2, p_commentID OUT PLS_INTEGER ) AS BEGIN p_commentID := -1; END; / Procedure created. 0.11 seconds DECLARE commentTypeId integer; BEGIN SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END; / Statement processed. 0.00 seconds
Comment