"ORA-00917: missing comma" when using ODBC Importer

[Patrick Holmes]

When using the ODBC Importer, I am getting an "ORA-00917: missing comma" error. It is because the insert statement is being generated with datatypes in parentheses. e.g.:

INSERT INTO CASEM.LOAD_NEW_REGION_PATIENTS (PCP_HEALTH_PROF_ID (NUMBER), PLACE_OF_SERVICE_CD (VARCHAR2), PT_LAST_NAME (VARCHAR2), PT_FIRST_NAME (VARCHAR2), PT_DATE_OF_BIRTH (DATE), PT_SEX (VARCHAR2), PT_SSN (NUMBER), PT_PHONE (NUMBER), ADMIT_DATE (DATE), HOSPITAL_ID (NUMBER), CARRIER_ID (NUMBER)) VALUES PCP_HEALTH_PROF_ID, LACE_OF_SERVICE_CD, T_LAST_NAME, T_FIRST_NAME, T_DATE_OF_BIRTH, T_SEX,

but that statement won't work with my 9i (9.2.0.7) database. I can't have the field types in parentheses. How can I fix this so it will work with a 9i database?

thanks,

pat

 

[Patrick Holmes]

P.S. This is not a problem with the Text Importer (which I used instead), only the ODBC Importer that I know of.
thanks
pat

 

[Marco Kalter]

Can you let me know your exact PL/SQL Developer version?

 

[Marco Kalter]

Hello Patrick,

Can you try with this version: plsqldev80a3.exe

This issue should be fixed.