Method find_variable

sql/sql_lex.cc:6964–6986

Find a local or a package body variable by name. @param IN name - the variable name @param OUT ctx - NULL, if the variable was not found, or LEX::spcont (if a local variable was found) or the package top level context (if a package variable was found) @param OUT handler - NULL, if the variable was not found,

  @retval            - the variable (if found), or NULL otherwise.
*/
sp_variable *
LEX::find_variable(const LEX_CSTRING *name,
                   sp_pcontext **ctx,
                   const Sp_rcontext_handler **rh) const
{
  sp_variable *spv;
  if (spcont && (spv= spcont->find_variable(name, false)))
  {
    *ctx= spcont;
    *rh= &sp_rcontext_handler_local;
    return spv;
  }
  sp_package *pkg= sphead ? sphead->m_parent : NULL;
  if (pkg && (spv= pkg->find_package_variable(name)))
  {
    *ctx= pkg->get_parse_context()->child_context(0);
    *rh= &sp_rcontext_handler_package_body;
    return spv;
  }
  *ctx= NULL;
  *rh= NULL;
  return NULL;
}


bool LEX::check_variable_is_refcursor(const LEX_CSTRING &verb_clause,