| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| PASSTHRU INSERT Statement |
« View previous topic :: View next topic » |
| Author |
Message
|
| nukalas2010 |
 Posted: Tue Jul 10, 2012 2:41 am Post subject: PASSTHRU INSERT Statement |
 |
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
Hi All,
Can any one let me know wat's wrong in the below statement.
When I am using below statement
| Code: |
| PASSTHRU('INSERT INTO Database.T1(N) VALUES(?)', 12); |
I am getting error as
| Quote: |
| ORA-00942: table or view does not exist |
But When I am using the below statement it's working fine.
| Code: |
| INSERT INTO Database.T1 (N) VALUES(12); |
Thanks in Advance. |
|
| Back to top |
|
 |
| mgk |
| Posted: Tue Jul 10, 2012 3:37 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
| Code: |
| PASSTHRU('INSERT INTO Database.T1(N) VALUES(?)', 12); |
The error is using the word "Database." in the string given to the DB. Passthru sends the string unchanged to the DB, so you need to remove the "Database." first...
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Wed Jul 11, 2012 10:30 pm Post subject: |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
[quote="mgk you need to remove the "Database." first...
[/quote]
Yes mgk, now its working fine.. Thanku.  |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
