Application Express | Forum profile

Hi, If you do not yet use jQuery, just place this to page HTML header <script src= "http://www.google.com/jsapi" type= "text/javascript" ></script> <script type= "text/javascript" > google.load( "jquery" , "1.3.2" ); // uncommet below if you like start also use jQuery UI...

It's probably best to start a new thread. I've never emailled a link that calls a stored procedure, though Andy

Hello: You could try something like this Create an application-item in the APEX application In the trigger that generates the PK, set this application-item to the value of PK generated. If the page is now re-posted after the user has used the back button, you can verify (as a validation/page process) whether a record exists in the table with a PK value equal to the value contained in the application-item and take appropriate action. varad

Not that I know of unless you perhaps use iFrames... Cheers Ben

You could add KEEP DENSE_RANK FIRST into your query and see if that helps.. Thank you, Tony Miller Webster, TX

Ahh ok. In that case I would write the crosstab query yourself and then you can create a standard report. This blog is a good explanation of how to write a crosstab query: http://thinkoracle.blogspot.com/2005/09/pivot-and-crosstab-queries.html

You've given me a great idea... someone should write an Oracle Security book covering how those concepts are Applied to everyday applications, including 2 chapters on APEX Do you have external and internal users of the same APEX instance? This is a long topic (I wrote about 100 pages on it), but I'll give it a try in a few bullet points: Put OHS in your DMZ with firewall rules to restrict traffic from the outside world to only http...

Yes !You are correct. In custom authentication scheme's Logout URL, i have the following : wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1 I had corrected it as wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:100 Thanks, Yogesh

thanks..Jari it worked.. Thanks, Deepak

Hi Engr, In the "Report Attributes" page you can hit the edit link next to any column, and it will give you options to set up links from that column. If you wanted your entire row to be one link you would have to set up each column individually like this. Hope this is helpful, Aaron