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

Asked

Viewed 148 times

0

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?

sql firebird stored-procedures firebird-2.5

1 answer

0


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.

Browser other questions tagged sql firebird stored-procedures firebird-2.5

You are not signed in. Login or sign up in order to post.