Skip to Main Content

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to call stored procedure from javascript? (about Google Suggest, AJAX)

704520Aug 11 2009 — edited Aug 14 2009
Hi I want to implement a text field so that it behaves like [Google Suggest|http://www.google.com/webhp?complete=1&hl=en] .

I read this post .

Now I've setup everything according to that document. But it just doesn't work. And I don't know why.

I think problems may fall into the following three categories:
1. Does the text field and the page invoke the proper javascript?
2. Does the javascript successfully call the stored procedure?
3. Can the stored procedure correctly return the formatted result?

I am affirmative for 1 and 3, but I'm not sure about 2. Because I don't know how to tell if a stored procedure has been called? Is there a PL/SQL statement that I can query in SQL*Plus?

Also, I would to know how to debug AJAX in APEX. It involves many things.

Last, I used APEX 3.2 and Oracle XE. I cannot find either dads.conf or marvel.conf file. Is "/apex/" the virtual directory for APEX?

Thanks a lot!
This post has been answered by MatthiasHoys on Aug 13 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2009
Added on Aug 11 2009
16 comments
13,045 views