Recent content by -=David=-

  1. D

    INSERT CLOB = ORA-01036: illegal variable name/number

    Hi Marco, First off I should add we are running Oracle 10.1.0.3 on the server. The DBA has found the dump file and the problem appears to be internal to Oracle... ksedmp: internal or fatal error ORA-07445: exception encountered They are going to send it off to Oracle for analysis so I will...
  2. D

    INSERT CLOB = ORA-01036: illegal variable name/number

    Hi Marco, Yes I passed in EMPTY_CLOB() for both columns. I will be back in the office tomorrow so I will speak to the DBA's to see what we can find. Regards David
  3. D

    INSERT CLOB = ORA-01036: illegal variable name/number

    Well I found it at last, but that error message is not even remotely helpful. Basically I had included some columns in the list that shouldn't have been there (long story). Anyway, I have removed them and now the "InsertRecord.Execute" produces this :- ORA-03113: end-of-file on communication...
  4. D

    INSERT CLOB = ORA-01036: illegal variable name/number

    Hi All, I am trying to INSERT a record into a table that contains two CLOBs. The TOracleQuery contains :- BEGIN INSERT INTO [TABLE] ( , ... ) VALUES ( :V_COL1, ... :V_COL84 ) RETURNING , INTO :V_COL75, :V_COL76; END...
Back
Top