title: not able to call procedure within procedure in HANA Studio
body: <p>I am trying to call a procedure I made earlier in new procedure. I am getting error in same line no matter what I try. 
  My original line was :</p>
  
  <pre><code>CALL "PAYROLLDBTEST"."ABS_GetEmployeeHistoryDetail"(:EmpID)
  </code></pre>
  
  <p>on this I got error "invalid name of function or procedure: ABS_GETEMPLOYEEHISTORYDETAILS: "</p>
  
  <p>then I tried 
      CALL "PAYROLLDBTEST/ABS_GetEmployeeHistoryDetail"(EmpID)
  on this I got error "sql syntax error: incorrect syntax near "(":"</p>
  
  <p>So please let me know whats wrong.</p>
  
  <p>EDIT:
  Heres the whole procedure :</p>
  
  <pre><code>CREATE PROCEDURE "PAYROLLDBTEST".GetEmploymentHistoryFunction 
  (IN EmpID integer, IN StartDate timestamp, IN EndDate timestamp,OUT RETURNVALUE   NVARCHAR) 
  LANGUAGE SQLSCRIPT 
  AS 
  
  BEGIN 
  SELECT *, DAYS_BETWEEN("FromDate", "ToDate") + 1 AS "DaysCount" 
   FROM (SELECT "Code", "Name", "U_LineID", "U_empID", "U_Status", 
          CASE 
              WHEN ("ToDate" &lt; :StartDate) THEN NULL 
              WHEN ("FromDate" &gt; :EndDate) THEN NULL 
              WHEN ("FromDate" &lt; :StartDate AND ("ToDate" BETWEEN :StartDate AND :EndDate)) THEN :StartDate 
              WHEN ("FromDate" &lt; :StartDate AND "ToDate" &gt; :EndDate) THEN :StartDate 
              WHEN (("FromDate" BETWEEN :StartDate AND :EndDate) AND
               ("ToDate" BETWEEN :StartDate AND :EndDate)) THEN "FromDate" 
              WHEN (("FromDate" BETWEEN :StartDate AND :EndDate) AND "ToDate" &gt; :EndDate) THEN "FromDate" 
              WHEN ("ToDate" IS NULL AND "FromDate" &lt; :StartDate) THEN :StartDate 
              WHEN ("ToDate" IS NULL AND ("FromDate" BETWEEN :StartDate AND :EndDate)) THEN "FromDate" 
          END AS "FromDate", 
          CASE 
              WHEN ("ToDate" &lt; :StartDate) THEN NULL 
              WHEN ("FromDate" &gt; :EndDate) THEN NULL 
              WHEN ("FromDate" &lt; :StartDate AND ("ToDate" BETWEEN :StartDate AND :EndDate)) THEN "ToDate" 
              WHEN (("FromDate" BETWEEN :StartDate AND :EndDate) AND
               ("ToDate" BETWEEN :StartDate AND :EndDate)) THEN "ToDate" 
              WHEN ("FromDate" &lt; :StartDate AND "ToDate" &gt; :EndDate) THEN :EndDate 
              WHEN (("FromDate" BETWEEN :StartDate AND :EndDate) AND "ToDate" &gt; :EndDate) THEN :EndDate 
              WHEN ("ToDate" IS NULL AND "FromDate" &lt; :StartDate) THEN :EndDate 
              WHEN ("ToDate" IS NULL AND ("FromDate" BETWEEN :StartDate AND :EndDate)) THEN :EndDate 
          END AS "ToDate", "U_Position", "U_Project", "U_Sponsorship" 
      FROM (
      --select * from ABS_GetEmployeeHistoryDetails WHERE ("EmpID" IN (:EmpID))
    --select * from "PAYROLLDBTEST"."ABS_GetEmployeeHistoryDetails" WHERE ("EmpID" IN (:EmpID))
    CALL "PAYROLLDBTEST"."ABS_GetEmployeeHistoryDetails"(:EmpID,:RETURNVALUE);
  
   ) InnerQuery
   ) OuterQuery
   WHERE ("FromDate" between :StartDate and :EndDate OR "ToDate" between :StartDate and    :EndDate);
  
  
  END;
  </code></pre>
  
  <p>Thanks</p>