Generating DAO code for Oracle Stored Procedures
FireStorm/DAO 2.3 will add full support for stored procedures but it is possible to call stored procedures using the current Custom DAO support. There are some restrictions using this approach (most notably the lack of support for INOUT or OUT parameters and support for REFCURSOR types).
If you want to call stored procedures that return no results you can use this syntax within the Custom DAO definition:
BEGIN ADD_JOB_HISTORY(:empId, :startDate, :endDate, :jobId, :deptId); END;