View previous topic :: View next topic
|
Author |
Message |
Vaniv
New User
Joined: 01 Apr 2005 Posts: 1
|
|
|
|
What are the possible causes for getting an SQLCODE of -804.
We are executing a query repeatedly. First time it is working fine. When it comes for the Second time SQLCODE -804 is coming. |
|
Back to top |
|
|
mcmillan
Site Admin
Joined: 18 May 2003 Posts: 1210 Location: India
|
|
Back to top |
|
|
sivatechdrive
Active User
Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
|
|
|
|
Hi vani
plz read the explination it may help you
qw -804 ,gives the detailed information of the error code as below :
804 AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT, REASON reason
Explanation: The call parameter list or the SQLDA is invalid.
o The call parameter list, which is created by the precompiler, might be
invalid if the application programmer has modified the output of the
precompiler, used a variable name beginning with 'SQL' in the
application program, or overwritten the call parameter list in some otherway.
o The SQLDA, which is created by the application program, has an invalid
data type or data length.
o The value of SQLDABC is not consistent with the value of SQLD.
01 Open issued for non-cursor.
02 Close issued for non-cursor.
03 Prepare of EXECUTE IMMEDIATE.
04 Statement is not recognized.
05 No statement string present.
06 Bad SQLDA format in parameter list.
07 SQLDA length is invalid.
08 Unrecognized input data type.
09 Invalid length for input variable.
10 Invalid data length for output variable.
11 The value of SQLDABC is not consistent with the value of SQLD.
12 Invalid input data pointer 13 Invalid output data pointer.
14 SQLN has too many items for SQLDABC.
15 Input RDI pointer is invalid.
16 Unrecognized output data type.
17
The value of the 7th byte of SQLDAID is not consistent with the
data types contained in the SQLDA. The SQLDA contains a LOB type host variable, but the 7th byte of SQLDAID is not set to '2' or
greater to indicate that the extended SQLVARs have been
allocated.
System Action: The statement cannot be executed.
System Programmer Response:
Examine the application program for any of the errors noted under the explanation above. In general, the application programmer should not attempt to modify the output of the precompiler.
thanks
siva |
|
Back to top |
|
|
Karthikeyan J
New User
Joined: 19 Dec 2006 Posts: 16 Location: Mumbai
|
|
|
|
I am facing a similar issue. An update query executes fine for umpteen number of times but at one point abends wiith SQL -804 error. Please throw light on how the issue addressed before. |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Karthikeyan J
How did you solve this I am in same well ? |
|
Back to top |
|
|
|