| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
