cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC-->RFC(Mappins issue)

Former Member
0 Kudos

Hi

Can any one let me know your ideas , where i'm failing to insert data into JDBC..following error i'm getting insert into one column, but i'm able to insert the same column via sql query analyzer(MS-SQL)..and i tried with constant value for mapping , then its working fine..its able to inserted.

Unable to execute statement for table or stored procedure. 'SAP_PaymentReceiptFromSAP' (Structure 'StatementName') due to

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The name

'LN4717410' is not permitted in this context. Only constants, expressions,

or variables allowed here. Column names are not permitted.

>

Thank you,

reards..rambarki

Accepted Solutions (1)

Accepted Solutions (1)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Rambarki,

I think the error is because your database table is expecting some kind of input and the input you are passing has some error in it.Just cross check the table using <b>DESCRIBE <tablename></b> with the data you are trying to enter.

It would be helpful, if you could give us your destination Data Type ( along with the content you are trying to indert )and your table structure.

Regards,

Bhavesh

Answers (1)

Answers (1)

Former Member
0 Kudos

Sorry..

my scenrio is rfc to jdbc..

regards..rambarki