Home » Developer & Programmer » JDeveloper, Java & XML » Intresting Problem ROWID APPENDED in SQL QUERY
Intresting Problem ROWID APPENDED in SQL QUERY [message #92146] Thu, 25 March 2004 04:12
Keshav Tripathy
Messages: 30
Registered: November 2001
Member
Hi

I have a typical Problem. I am Passing the Following SQL QUERY in my Java Application.

queryBuffer.append ( "Select description from Wks_VIP_Type vip , Wks_Client_Vip_status vipstatus where vip.VIP_type_CD = vipstatus.VIP_type_CD and vipstatus.client_ID = '"

+ clientId + "' AND vip.VIP_type_CD = '"

+ mwoCustomerProfileObj.getVipStatus () + "' " ) ;

But Some Time Not Always its giving Ambigious Column Error and when I see at that Point of time the Query I am finding that ROWID is appended in the Select Statement as follows and the query looked Like

select rowid, description from Wks_VIP_Type vip , Wks_Client_Vip@_status vipstatus where vip.VIP_type_CD = vipstatus.VIP_type_CD @and vipstatus.client_ID = '4000000102' AND vip.VIP_type_CD = ' '

Can any one give me some idea on why this is happening
Previous Topic: Charset #65
Next Topic: erro in jsp
Goto Forum:
  


Current Time: Tue Jul 27 15:33:17 CDT 2021