on 11-22-2010 4:21 AM
I have a condition with following syntax. When i parse, it say
Parse failed: Exception: DBD, ORA-00933: SQL command not properly ended State: N/A
@Select(Hotel Contact\Hotel Contact Fax Primary Ind Y/N) () = 'Y' and @Select(Hotel Contact\Hotel Contact Fax Type Code) () = 'PFAX'.
There is any mistake in the prompt.
object defination is
Hotel Contact Fax Primary Ind Y/N ---object name with following defination.
"htl_cont_INDVL_fax_alias".PRIM_IND
and
Hotel Contact Fax Type Code--object defination
"htl_cont_INDVL_fax_alias".PHONE_TYP_CD
I have tried option by changing ANSI also. Does not help.
help me please
Just a few thoughts to share;
The is there because you don't want to inner an outer join?
If the join is defined as outer you can also use the syntax
(@Select(Hotel Contact\Hotel Contact Fax Primary Ind Y/N) = 'Y' or
@Select(Hotel Contact\Hotel Contact Fax Primary Ind Y/N) IS NULL)
and (@Select(Hotel Contact\Hotel Contact Fax Type Code) = 'PFAX'
or @Select(Hotel Contact\Hotel Contact Fax Type Code) IS NULL)
This will work in ANSI, whereas the will not, that is typical Oracle syntax.
Another thing check that the table is associated with the condition.
if it isn't associated, the full query will only work if you select some other object that is associated with the table,
or the table will not be put in the from clause.
Please not that this condition is not really a restriction,
since you will allow records without a Hotel Contact record associated too.
If you are actually trying to limit the hotel contacts to the primary fax contact.
I would create an alias on this table with a self join, or a derived table.
outer join it and use an object from that table if I wanted the the primary fax contact information.
Hope this helps,
Marianne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure there's no space between the column name or object name and the (+).
I saw another developer with this problem where I worked and when he deleted the space right before the it worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In fact,
this is universe level prompt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.