Home » Open Source » Programming Interfaces » Odbc driver returned an error (SQLExecDirectW (OBIEE, Windows Xp.)
icon1.gif  Odbc driver returned an error (SQLExecDirectW [message #445423] Mon, 01 March 2010 14:38 Go to next message
SatishkGoud
Messages: 6
Registered: March 2010
Location: USA
Junior Member

Hi Experts

anyone came across this error...plz help..


View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1480, message: ORA-01480: trailing null missing from STR bind value at OCI call OCIStmtExecute: select T905625.ENRL_CAP as c1, T905625.RSRV_CAP_NBR as c2, T905625.START_DT as c3, T905924.DESCR as c4, T905635.ENRL_TOT as c5, T905625.CRSE_ID as c6, T905625.CRSE_OFFER_NBR as c7, T905625.STRM as c8, T905625.SESSION_CODE as c9, T905625.CLASS_SECTION as c10 from SYSADM.PS_CLASS_RSRV_CAP T905625, SYSADM.PS_CLASS_RSRV_GRP T905635, SYSADM.PS_RQ_GRP_ENR_VW T905924 where ( T905625.SESSION_CODE = T905635.SESSION_CODE and T905625.STRM = T905635.STRM and T905625.CRSE_ID = T905635.CRSE_ID and T905625.CRSE_OFFER_NBR = T905635.CRSE_OFFER_NBR and T905625.CLASS_SECTION = T905635.CLASS_SECTION and T905625.RSRV_CAP_NBR = T905635.RSRV_CAP_NBR and T905625.RQRMNT_GROUP = T905924.RQRMNT_GROUP and (T905625.CRSE_ID = :PARAM1 and T905625.CRSE_OFFER_NBR = :PARAM2 and T905625.STRM = :PARAM3 and T905625.SESSION_CODE = :PARAM4 and T905625.CLASS_SECTION = :PARAM5 or T905625.CRSE_ID = :PARAM6 and T905625.CRSE_OFFER_NBR = :PARAM7 and T905625.STRM = :PARAM8 and T905625.SESSION_CODE = :PARAM9 and T905625.CLASS_SECTION = :PARAM10 or T905625.CRSE_ID = :PARAM11 and T905625.CRSE_OFFER_NBR = :PARAM12 and T905625.STRM = :PARAM13 and T905625.SESSION_CODE = :PARAM14 and T905625.CLASS_SECTION = :PARAM15 or T905625.CRSE_ID = :PARAM16 and T905625.CRSE_OFFER_NBR = :PARAM17 and T905625.STRM = :PARAM18 and T905625.SESSION_CODE = :PARAM19 and T905625.CLASS_SECTION = :PARAM20) ) order by c6, c7, c8, c9, c10. [nQSError: 17011] SQL statement execution failed. (HY000)
SQL Issued: SELECT Class."Subject Code" saw_0, Class."Catalog Number" saw_1, Class."Class Section" saw_2, Class."Class Type" saw_3, "Reservation Capacity"."Enrollment Capacity" saw_4, "Reservation Capacity"."Reservation Capacity Number" saw_5, "Reservation Capacity"."Start Date" saw_6, "Reservation Capacity"."Requirement Group Description" saw_7, "Reservation Capacity"."Enrollment Total" saw_8 FROM "CSW - LIVE - Class Enrollment" WHERE (Class."Term Description" = 'Fall 2010') AND (Class."Class Type" = 'E') ORDER BY saw_0, saw_1, saw_2, saw_3, saw_4, saw_5, saw_6, saw_7, saw_8



Re: Odbc driver returned an error (SQLExecDirectW [message #445437 is a reply to message #445423] Mon, 01 March 2010 21:48 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ORA-01480: trailing null missing from STR bind value
 
Cause: A bind variable of type 5 (null-terminated string) 
does not contain the terminating null in its buffer.
 
Action: Terminate the string with a null character 
Previous Topic: Problem on connecting with DBD to Oracle DB with ORA-03135
Next Topic: ole2 in oracle 9i pl/sql
Goto Forum:
  


Current Time: Thu Nov 14 04:50:38 CST 2024