Originally posted by darmstadt
View Post
It's clever like that
DECLARE commentTypeId integer; BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
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
DECLARE commentTypeId integer; BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
DECLARE commentTypeId integer; BEGIN SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
DECLARE commentTypeId integer; IS BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
DECLARE commentTypeId integer; BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
Leave a comment: