OCI & Dates

Hello,

I'm writing a C program that needs to execute simple SQL INSERT statements on a remote Oracle database. Let me first preface by saying I haven't done anything like this with Oracle before. Basically my understanding is that I need to create an SQL statement containing a series of placeholders, such as :EMP_NUM or :CURRENT_SALARY, then execute a series of OCIBindByName() calls to 'fill in the blanks.' So my first question is, is this the 'correct' way to build an INSERT statement? Secondly, if this is correct, how to I build and insert a date/time value, given a (struct tm *) value, and bind it into an associated value?

Thanks,
John Received on Fri Jan 08 1999 - 15:07:10 CST