Pull data from SQL source to HFM

-EHello All,

I'm attempting to pull data from a SQL source through open interface adapter with a SQL script and I'm getting an error that says the script failed to execute. Below is the SQL script and error log.

import java.sql as sql

DECLARE

  l_period_name VARCHAR2(20);

  l_batch VARCHAR2(30);

BEGIN

/*Prompting for period. This needs to be replaced by the

query to the period selected by the user in FDMEE*/

l_period_name := 'AUG-15';

/*generating batch id with current date timestamp*/

SELECT to_char(SYSDATE,'YYYYMMDD_HH24MISS') dtime

INTO l_batch

FROM dual;

/*deleting all data from interafce table in case there is any unprocessed record