tag:blogger.com,1999:blog-8449039.post115283668488584350..comments2024-03-28T05:59:36.577-04:00Comments on Scott Spendolini's Blog: ApEx Home Page FaceliftScotthttp://www.blogger.com/profile/01187435106015051061noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8449039.post-32252305049809620642007-09-10T08:42:00.000-04:002007-09-10T08:42:00.000-04:00Do know if it is possible to store a sql script(co...<I>Do know if it is possible to store a sql script(containing sql commands and pl/sql blocks) on a server, and then use APEX to execute it by entering a URL in a browser( like we could do with isqlplus using dynamic)?</I><BR/><BR/>Sure - you would need to convert the script to a procedure, and then you could call it from either an APEX application (more secure) or just from the URL (less secure, don't even need APEX).<BR/><BR/>- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-89435576396874523672007-09-07T19:09:00.000-04:002007-09-07T19:09:00.000-04:00Scott,Do know if it is possible to store a sql scr...Scott,<BR/><BR/>Do know if it is possible to store a sql script(containing sql commands and pl/sql blocks) on a server, and then use APEX to execute it by entering a URL in a browser( like we could do with isqlplus using dynamic)?<BR/><BR/>Thanks,<BR/>Marty Solomon<BR/>martysolom@aol.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-1157062894517038232006-08-31T18:21:00.000-04:002006-08-31T18:21:00.000-04:00Hi Scott,I'm trying to implement a simple Oracle A...Hi Scott,<BR/><BR/>I'm trying to implement a simple Oracle Application Express (HTML_DB) page into Oracle Financials App. eBussines Suite 11.5.9<BR/>We want use APEX like way to replace Oracle Forms and Reports. But, we need can run the APEX pages integrating into Financials, not like other new applications w/new SSO (user_name and user_password).<BR/><BR/>I was following your explanations (eBusiness Suite Security Model), but surely I have some mistakes.<BR/><BR/>My implementation was:<BR/><BR/>A) on ApEX Developmet Appl.<BR/><BR/>A.1) I created a simple page based on Employees table into an existing DB schema (called NXC).<BR/>A.2) "NXC" schema is an existing schema into DB that are running Oracle Financials (like PA, or GL, etc) We have Custom Forms are running in Financials.<BR/>A.3) The Employees APEX is running fine form APEX Development. This page run w/address:http://bashpapa:7778/pls/htmldb/f?p=113:1 The page is working fine.<BR/><BR/>B) on Financials: <BR/><BR/>B1) created a Function<BR/>B2) created a Menu<BR/>B3) created a Responsibility<BR/>B4) created package (apps.apex_launcher.launcher_103) and done grant execute to Public.<BR/>B5) Assigned the responsibility to my user<BR/><BR/>It was not necessary create a new Application and register a Data Group because the schema was existing (NXC).<BR/><BR/>B6) When I run the page from Oracle Financials I have a message error "No se <BR/>encontró la página" (page not found).<BR/><BR/>Financials open a new browser <BR/>(http://baslije2.nex.com.ar:8005/OA_HTML/RF.jsp?function_id=20885&resp_id=539<BR/>41&resp_appl_id=20004&security_group_id=0&lang_code=US) w/ error and the message is " page not found ".<BR/><BR/><BR/>I'm not expert in servers or internet resources, bur I thinks that I have some problem like Financials called at APEX page.<BR/><BR/>I do not sure because Financials is running w/http://baslije2.nex.com.ar:8005/....<BR/>and APEX have reference at http://bashpapa:7778/pls/htmldb....<BR/><BR/>When Financials called APEX page have to replace // baslije2.nex.com.ar:8005 TO //bashpapa:7778/pls/htmldb ????<BR/><BR/>What part of the notes I have to follow?<BR/><BR/>I will appreciate your help if it is possible.<BR/><BR/>RolandoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-1152862825183361232006-07-14T03:40:00.000-04:002006-07-14T03:40:00.000-04:00I agree, it definitely looks a lot 'cleaner' and e...I agree, it definitely looks a lot 'cleaner' and easier to navigate.Anonymousnoreply@blogger.com