Oracle Forms (MOSC)

MOSC Banner

Truncated where clause - Bug report 3001689

edited Apr 20, 2009 3:24AM in Oracle Forms (MOSC) 2 commentsAnswered
We have a situation, in a Oracle Forms application, where occasionally the Where clause is getting truncated;

Select column_a, column_b
  From v_whatever
 Where column_c = 1
for update of column_a nowait;

 

It comes out like

Select column_a, column_b
  From v_whatever W
for update of column_a nowait;

 

The W is being read as a table alias and causing major problems.

There is a bug report out there (# 3001689, dated sometime in 2004) but I haven't been able to determine if it has been fixed or not.

Does any one know the status of this or can give me any insight into the problem?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center