title: How to execute a stored procedure directly in postgresql?
body: <p>I have created a procedure like :</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION insert_user_ax_register(
     user_name character varying(50), 
     password character varying(300), 
     role_id character varying(10), 
     created_dt date, 
     status boolean, 
     email character varying(50), 
     join_date character varying(30), 
     phone_no bigint, 
     client_address character varying(200), 
     full_name character varying(100), 
     financial_year character varying(10)) 
  RETURNS void 
  AS $BODY$ 
  declare 
  begin 
    INSERT INTO ax_register(user_name,password,role_id,created_dt,status,email,join_date,phone_no,client_address,full_name,financial_year) 
    VALUES (user_name,password,role_id,now(),true,email,join_date,phone_no,client_address,full_name,financial_year); 
  end 
  $BODY$ 
  LANGUAGE plpgsql VOLATILE
  </code></pre>
  
  <p>and tried to execute it like this:</p>
  
  <pre><code>SELECT * from insert_user_ax_register('debasrita','debasrita','client001',now(),'t','abc@gmail.com',now(),'ctc','debasrita','2014-15',9090909090);
  </code></pre>
  
  <p>but it throws the following error :</p>
  
  <p>ERROR: function insert_user_ax_register(unknown, unknown, unknown, timestamp with time zone, unknown, unknown, timestamp with time zone, unknown, unknown, unknown, bigint) does not exist
  SQL state: 42883
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Character: 16</p>
  
  <p>Please help me out on this. I am new to pgsql and not able to find out any solution from google. I am using <code>pgsql 9.1.3</code></p>
  
  <p>May I know what is the correct way to achieve my objective?</p>