these errors:
>The error_log of the apache web server >Printf() on closed filehandle JOE at insert.pl line 59. >Printf() on closed filehandle JOE at insert.pl line 61. >Printf() on closed filehandle JOE at insert.pl line 62. >Printf() on closed filehandle JOE at insert.pl line 63. >Printf() on closed filehandle JOE at insert.pl line 64. come from these lines: >open(DAN, "> postOra.txt"); >printf JOE "ssn %s is %s \n",$ssn; >printf JOE "fname %s is %s \n",$fname; >printf JOE "lname %s is %s \n",$lname; >printf JOE "city %s is %s \n",$city; >printf JOE "state %s is %s \n",$state; >printf JOE "zip %s is %s \n",$zip; >close(DAN); You open "DAN" but try to print to "JOE" >Vilolated (DBD ERROR: OCIStmtExecute at insert.pl line 77 ViLolated? where did that typo come from?? Check you column types. Try to bind the the params without a type, but quote the values: $sth->bind_param(1, $dbh->quote($ssn)); etc... Maarten.
