Proble in inserting the records from Navision to Oracle 10g

ajaybabuCh

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

ajaybabuCh

Hi

Sorry I got the solutin but i forget to post

For inserting or deleting or modifying the following is the statement

ADO.EXECUTE(INSERT OR DELETE OR MODIFY QUERY)

Regards
Ajay

InterFish

Hi,

I'm still confused about the connection statement.
How does the ADO-variable get the information that this is an Oracle DB?
And what is the meaning of "data source=Testclient"? How do you define "Testclient"? Is this the computer oracle runs on?

Greets

'Fish