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!

How to call a Javascript from a report

RoyHOct 9 2008 — edited Oct 9 2008
Hi.
I have a report in an application where 2 of the columns are link’s that is supposed to show information from a different table. When I click on the link, I what to display a notification/popup based on a select statement.

My first problem is to call a javascript from this link. Whatever I try, an empty IE window appears and tells me that it can’t display this webpage. This “javascript:callNotification(&ID); is placed in: column attributes -> Column Link -> URL field with target = URL. Why does this not work?

My second problem is: how to write the select statement in the javascript, and display the result in a notification window:

function callNotification(Value1)
{
select infofield into ??? from my_table where id = Value1;
.......
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2008
Added on Oct 9 2008
3 comments
988 views