I am not sure about those perl modules you guys mentioned, but for Pro*c, it does have equivalent for inserting, and actually also updating and deleting. I attached some examples in C:

char emp_name[50][20];
int emp_number[50];
float salary[50];
/* populate the host arrays */
EXEC SQL INSERT INTO EMP (ENAME, EMPNO, SAL)
     VALUES (:emp_name, :emp_number, :salary);
[download]

And

int emp_number[50];
float salary[50];
/* populate the host arrays */
EXEC SQL UPDATE emp SET sal = :salary
     WHERE EMPNO = :emp_number;
[download]

Even deleting with array:

int emp_number[50];
/* populate the host array */
EXEC SQL DELETE FROM emp
     WHERE empno = :emp_number;
[download]