- Joined
- Jul 6, 2005
- Messages
- 36,255
- Likes received
- 2,931
- Thanks received
- 767
- Location
- .
Sounds like this project is going to hell in a handcart.
DECLARE
commentTypeId integer;
BEGIN
Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId);
END;

PLS-00103: Encountered the symbol SP_ADD_COMMENT_TYPE when expecting one of the following ......

Exec SP_ADD_COMMENT_TYPE('New comment Type', commentTypeId);
Most - C-style anyway - allow it thoughI haven't got a clue but have you tried it without the space:
Most programming languages don't have a space between a function and parameters...
Worth a try though.This is why Oracle does my f****** nut in.
Consider the following stored procedure call :
Code:DECLARE commentTypeId integer; BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
According to the examples on the web this is fine. According to the examples given on here this is fine.
According to the SQL Developer tools THIS IS NOT FINE.
I have tried it with and without EXEC. I have tried it with and without CALL. I have tried it in SQL+.
![]()
DECLARE
commentTypeId integer;
BEGIN
SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId);
END;