OraFAQ Forum: JDeveloper, Java & XML » Intresting Problem ROWID APPENDED in SQL QUERY

Home » Developer & Programmer » JDeveloper, Java & XML » Intresting Problem ROWID APPENDED in SQL QUERY

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	Charset #65
Next Topic:	erro in jsp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 15:22:31 CST 2024