title: MySQL Error pls-00103
body: <p>I am making a MySQLand getting an error I dont know how to fix it. What the function should be doing is asking the user for input, this input should be stored in the corresponding variables and return a variable. But when i try run the function I am getting errors on the lines that store the variables. I am quite new to mySQL so i might be doing something stupid. Any help will be great thank you</p>
  
  <p>This is is the mysql function</p>
  
  <pre><code>create or replace FUNCTION AD_AGENCY_INFO(agency_id in agency_id%type)
  RETURN agency_id
  
  DECLARE
  
    v_no_of_runs AD_AGENCY.NO_OF_AD_RUNS%TYPE = '&amp;enter_number_of_Runs';
    v_credit_worthy AD_AGENCY.CREDIT_WORTHY%TYPE = '&amp;enter_credit_worthy';
    v_available_slots AD_AGENCY.AVAILABLE_SLOTS%TYPE = '&amp;enter_available_slots';
    v_status AD_AGENCY.STATUS%TYPE = '&amp;enter_status';
  
  BEGIN
  
    insert into ad_agency values (agency_id, v_no_of_runs, v_credit_worthy,v_available_slots, v_status);
    insert into ad (agency_id) values (agency_id);
  
   commit;
  
  RETURN (agency_id));
   END AD_AGENCY_INFO;
  </code></pre>
  
  <p>The error that i am getting is the following and is the same for lines 7,8,9</p>
  
  <pre><code>Error(6,45): PLS-00103: Encountered the symbol "=" when expecting one of the following:     := ( ; not null range default character The symbol ":= was inserted before "=" to continue. 
  </code></pre>