Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Stored Procedure Parameters

Theory

Call the procedure

Report a typo

We have a stored procedure named ReturnURL that returns the profile page URL by the user's id. It has two parameters:

  • IN-parameter input_id.
  • OUT-parameter return_url.

Call the procedure for the user with an id 578 and the record that returns value into the @url session variable.

Enter a short text
___

Create a free account to access the full topic