Proble in inserting the records from Navision to Oracle 10g

Hi

I am ajay. When I am trying to inserting the records from navision to Oracle10g I am getting the following error.

This message is for C/AL programmers :

The Call to member open failed. Microsoft OLE DB provider for ODBC drivers returned the following message:
[Oracle][ODBC][Ora]ORA-00984: column not allowed here.

Please see the following code :

See the following variables that i used in this case :

1)ADO(automation variable)--'Microsoft ActiveX Data Objects 2.7 Library'.Connection

2)RsReceiveData(Automation)-- Unknown Automation Server.Recordset

3)RsFReceiveData( Automation)-- 'Microsoft ActiveX Data Objects 2.7 Library'.Fields

4)FieldReceiveData( Automation)-- Unknown Automation Server.Field

automation server for the unknow automation is :
{00000300-0000-0010-8000-00AA006D2EA4} 2.7 and select the field or recordset.


see the code below for connection :(its working)


IF ISCLEAR(ADO) THEN
CREATE(ADO);
ADO.Open('data source=' + 'Testclient' + ';' + 'user id=' + 'sir' + ';' + 'password=' + 'sir');
ADO.CommandTimeout(600);
MESSAGE('connection established...');

See the code for inserting the records into Oracle table :(its not working )

//BATCHTRANS is the oracle table.

VendorLedgerEntry.RESET;
VendorLedgerEntry.SETFILTER("Document Date",'>%1',020306D);

IF VendorLedgerEntry.FIND('-') THEN BEGIN
CreateConnection;

CREATE(RsReceiveData);
RsReceiveData.Open('INSERT INTO SIR.BATCHTRANS (SIR.BATCHTRANS,SIR.TRANSTYPE) VALUES('+ FORMAT(VendorLedgerEntry."Entry No.")+','+
FORMAT(VendorLedgerEntry."Document Type")+')',ADO);
END;
RsReceiveData.Close;


could anybody give me the code to insert the records from navision to Oracle10g

Regards
ajay