How to call a stored procedure using fatwire api

Hi ,
I am using fatwire jsk 7.6.0 with HSQLDB,  I have two questions :

1) How to call a stored procedure using fatwire API ? Can u provide a code snippet.
2)  I am trying to write a simple procedure in HSQLDB

CREATE PROCEDURE get_customer(IN ids INT, OUT nparentid VARCHAR(50))
  READS SQL DATA
  BEGIN ATOMIC
  
    SELECT nparentid FROM assetrelationtree WHERE id = ids;
  END

but it is giving syntax error saying  " Unexpected token: PROCEDURE in statement [CREATE PROCEDURE]". Can u help.

Thanks
Keerthi