| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Query Error |
« View previous topic :: View next topic » |
| Author |
Message
|
| venuprsd |
 Posted: Tue Oct 26, 2010 9:49 pm Post subject: Query Error |
 |
|
Apprentice
Joined: 15 Aug 2010
Posts: 44
|
Hello fnrds,
I am trying to execute following query by using ESQL
DECLARE sSQLInsert CHARACTER;
SET sSQLInsert = 'INSERT INTO EMPLOYEE.EMP ( ENO, ENAME, SAL ) VALUES( 527 , PRASAD , 12000) ' ;
PASSTHRU(sSQLInsert);
I am getting the error "Text:CHARACTER:[IBM][ODBC Oracle driver][Oracle]ORA-00984: column not allowed here "
Plz help me in this regard
Thank you. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Tue Oct 26, 2010 10:41 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
look at what the oracle error means.
| Code: |
oerr <oracle error number>
|
Is a good starting point.
There will also be other messages generated from the ExceptionList. Look in the eventlog for them all. They can often give a pointer to the actual column that is causing grief
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Oct 27, 2010 5:30 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you tried:
| Code: |
| SET sSQLInsert = 'INSERT INTO EMPLOYEE.EMP ( ENO, ENAME, SAL ) VALUES( 527 , "PRASAD" , 12000) ' ; |
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Wed Oct 27, 2010 9:13 pm Post subject: Re: Query Error |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
| venuprsd wrote: |
SET sSQLInsert = 'INSERT INTO EMPLOYEE.EMP ( ENO, ENAME, SAL ) VALUES( 527 , PRASAD , 12000) ' ;
I am getting the error "Text:CHARACTER:[IBM][ODBC Oracle driver][Oracle]ORA-00984: column not allowed here "
|
Hi Venu,
you have to enclose the character values in Single Quotes..
That meanss mention the ENAME as 'PRASAD' in VALUES |
|
| 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
|
|
|
|
