Código SQL [-] SET TERM ^; CREATE OR ALTER PROCEDURE PR_POSITION( SUBSTR VARCHAR(255), STR VARCHAR(255)) RETURNS ( RESULT SMALLINT) AS BEGIN RESULT = POSITION(SUBSTR, STR); SUSPEND; END^ SET TERM ;^
SET TERM ^; CREATE OR ALTER PROCEDURE PR_POSITION( SUBSTR VARCHAR(255), STR VARCHAR(255)) RETURNS ( RESULT SMALLINT) AS BEGIN RESULT = POSITION(SUBSTR, STR); SUSPEND; END^ SET TERM ;^
Código SQL [-] SET TERM ^; CREATE OR ALTER PROCEDURE PR_TEST_PR_POSITION( SUBSTR VARCHAR(255), STR VARCHAR(255)) RETURNS ( RESULT SMALLINT) AS BEGIN EXECUTE PROCEDURE PR_POSITION(SUBSTR, STR) RETURNING_VALUES(RESULT); SUSPEND; END^ SET TERM ;^
SET TERM ^; CREATE OR ALTER PROCEDURE PR_TEST_PR_POSITION( SUBSTR VARCHAR(255), STR VARCHAR(255)) RETURNS ( RESULT SMALLINT) AS BEGIN EXECUTE PROCEDURE PR_POSITION(SUBSTR, STR) RETURNING_VALUES(RESULT); SUSPEND; END^ SET TERM ;^