Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stem Operator ($) does not work

user10753959May 27 2010 — edited May 28 2010
Hello:

We are on Oracle 10g and I cannot seem to get this operator to work. (I am following the documentation at http://download-west.oracle.com/docs/cd/B10501_01/text.920/a96518/cqoper.htm#14499).

I get the following:


select count(*) FROM local_appls WHERE CONTAINS(project_title, 'isoflavone') > 0;

COUNT(*)
----------
54


select count(*) FROM local_appls WHERE CONTAINS(project_title, 'isoflavones') > 0;

COUNT(*)
----------
139


select count(*) FROM local_appls WHERE CONTAINS(project_title, '$isoflavone') > 0;

COUNT(*)
----------
54


Shouldnt the final query return something between 139 and 193?

thank you in advance for any advice.

Regards,
Harvey
This post has been answered by Roger Ford-Oracle on May 27 2010
Jump to Answer

Comments

InoL

I am currently also working on a Forms to Apex conversion and encounter the same problems. Alas, you do have to make Ajax calls and confirm dialogs before actually submitting the page.

This (in my case anyway) means a redesign of Forms processing.  All the necessary checks need to be done before submitting the page. So, a Form proces like this:

<do something>

<confirm?>

<do something>

<confirm?>

<final commit>

has to be redesigned to

<do some checks via an Ajax call without committing data>

<confirm?>

<post and commit>

This usually means you first get all the confirmation messages back in one message instead of multiple confirms (as was usually the case in Forms).

If this kind of redesign is not possible, you should hold temporary results in a collection before actually committing the data.

BTW: it gets worse when you have Forms with a POST-FORMS-COMMIT trigger!

Niels IH

Thanks for your reply

Perhaps collections are the way to go. I would rather not offcourse.

I think it will mean that i have to rewrite the standard save action of the interactive grids to process the row(s) through ajax and handle the user interaction before they are actually submitted by the grid.

Perhaps i can come up with some plugin design to do this in a more general way..

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 25 2010
Added on May 27 2010
4 comments
1,415 views