No go. I keep getting the Oracle error 00936, "Missing Expression", which means the SQL command sent to Oracle is:
INSERT INTO testtable (c1, ta_name, ta_number) VALUES('test4', , 569)
Notice the blank where the value held by @in_name should be inserted into the statement...