What is the Difference between Select and Run in a Procedure?

Question

There is some difference between making a Select to call the Procedure and giving a Execute in the Procedure, for example, in select a Procedure is in Read-Only mode and in execute no?

Answer 1

The select is intended to return data, so it must perform something that has a return, in the case of procedures there must be a suspend to be executed with select.

Already the execute stored procedure is intended to perform data change/data storage actions that do not require a return. However it can contain return if used next to it the RETURNING_VALUES.

Example:

EXECUTE PROCEDURE MakeFullName
  :FirstName, :MiddleName, :LastName
  RETURNING_VALUES :FullName;

As to the question of Read-Only or not, this is independent of the command chosen for execution, is defined in the connection transaction.