tag:blogger.com,1999:blog-21169145.post8695654090430193220..comments2023-04-29T14:41:38.880+02:00Comments on Jornica: APEX 3.0 on XE part 2Jornicahttp://www.blogger.com/profile/15492511382521784329noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-21169145.post-80427527211662740062008-02-07T00:12:00.000+01:002008-02-07T00:12:00.000+01:00Log on using the user FLOWS_030000 rather than set...Log on using the user FLOWS_030000 rather than setting the current_schema. It worked for me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21169145.post-91247560336109994632007-06-08T21:13:00.000+02:002007-06-08T21:13:00.000+02:00Jornica,Thanks for your suggestion.I did as you pr...Jornica,<BR/><BR/>Thanks for your suggestion.<BR/><BR/>I did as you proposed and keep getting the same problems. In fact, the scripts never "run", in that they get kicked out from the g_security_group_id must be set error.<BR/><BR/>I executed this:<BR/><BR/>exec wwv_flow_api.set_security_group_id(p_security_group_id=>10);<BR/><BR/>commit;<BR/><BR/>and it worked.<BR/><BR/>I didn't know what this means:<BR/><BR/>"ins SQL+"<BR/><BR/>Anyway, the above two lines executed successfully, then I ran the two scripts and got the same error.<BR/><BR/>Anything else you can think of that might be causing this?<BR/><BR/>Thanks again.<BR/><BR/><BR/><BR/>And have a look for the comments in the scripts.<BR/><BR/>With kind regards,<BR/><BR/>Jornica <BR/><BR/>21:50Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21169145.post-21101783787836792532007-06-06T12:19:00.000+02:002007-06-06T12:19:00.000+02:00Jornica,Thanks for your post... i'm using version ...Jornica,<BR/><BR/>Thanks for your post... i'm using version 3.0.0.00.20. Maybe this verification code is a change comparing to 3.0.0.00.17 that you mentioned.<BR/><BR/>Well, if you try one day this version, and understand why this problem occurs, let us know here in the blog :)<BR/><BR/>Best regards<BR/> Carlos V.Unknownhttps://www.blogger.com/profile/14961031587485843821noreply@blogger.comtag:blogger.com,1999:blog-21169145.post-63552147289800379482007-06-05T22:01:00.000+02:002007-06-05T22:01:00.000+02:00Carlos,I tried to reproduce your problem, but I do...Carlos,<BR/><BR/>I tried to reproduce your problem, but I don't see any verification code at all (version 3.0.0.00.17).<BR/><BR/>With kind regards,<BR/><BR/>JornicaJornicahttps://www.blogger.com/profile/15492511382521784329noreply@blogger.comtag:blogger.com,1999:blog-21169145.post-28404627542587964302007-06-05T21:50:00.000+02:002007-06-05T21:50:00.000+02:00Ted,Yes, run the scripts f4700.sql f4050.sql again...Ted,<BR/><BR/>Yes, run the scripts f4700.sql f4050.sql again and login as FLOWS_030000 and execute <BR/>wwv_flow_api.set_security_group_id(p_security_group_id=>10);<BR/>ins SQL+<BR/><BR/>And have a look for the comments in the scripts.<BR/><BR/>With kind regards,<BR/><BR/>JornicaJornicahttps://www.blogger.com/profile/15492511382521784329noreply@blogger.comtag:blogger.com,1999:blog-21169145.post-12390704053649943282007-06-05T18:32:00.000+02:002007-06-05T18:32:00.000+02:00Hi,I installed APEX 3 in Oracle Express Edition wi...Hi,<BR/><BR/>I installed APEX 3 in Oracle Express Edition with success (applications 4050 and 4700 too), using the information in your posts (thx ;)).<BR/><BR/>I'm having a problem now with application 4700. I'm creating a new workspace, and in the last step, is asked for me to put the verification code (generated images). The problem is that the 5 images doesn't appear... is necessary to complete another step on the installation to become complete?<BR/><BR/>Anyone can help, please<BR/>Thx in advance :)<BR/><BR/> Carlos V.Unknownhttps://www.blogger.com/profile/14961031587485843821noreply@blogger.comtag:blogger.com,1999:blog-21169145.post-23907413969093390462007-06-02T02:15:00.000+02:002007-06-02T02:15:00.000+02:00Trying to figure out how to find that security IDs...Trying to figure out how to find that security ID<BR/><BR/>select security_group_id from wwv_flows<BR/>/<BR/><BR/>Doesn't work...even after I've altered the session <BR/><BR/>ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030000Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21169145.post-26209199926927457692007-06-01T22:19:00.000+02:002007-06-01T22:19:00.000+02:00I followed the procedure, but on running the scrip...I followed the procedure, but on running the script, I got the error:<BR/><BR/>g_security_group_id must be set.<BR/><BR/>I altered the session as described. I saw in the previous post you had encountered this - did you just end up starting from scratch at that point?<BR/><BR/>Thanks.<BR/><BR/>--TedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21169145.post-9903788691280905962007-05-31T15:40:00.000+02:002007-05-31T15:40:00.000+02:00Hello,I was wondering where the tablespace (Usage)...Hello,<BR/><BR/>I was wondering where the tablespace (Usage) monitor is hidden in APEX 3.0.<BR/>In Oracle Database Express, you have this easy Storage administrator, where you have an overview of the Tablespaces and Datafiles used.<BR/><BR/>Thanks.<BR/><BR/>SebastianAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21169145.post-14937129321086353552007-05-23T23:08:00.000+02:002007-05-23T23:08:00.000+02:00Philip,Thanks for the feedback, concering item 1 I...Philip,<BR/><BR/>Thanks for the feedback, concering item 1 I don't have any clue. And item 2 is corrected. <BR/><BR/>Thanks,<BR/><BR/>JornicaJornicahttps://www.blogger.com/profile/15492511382521784329noreply@blogger.comtag:blogger.com,1999:blog-21169145.post-62014794032508991792007-05-23T22:48:00.000+02:002007-05-23T22:48:00.000+02:00Hello,Tested your workaround to install Apex 3.0 o...Hello,<BR/><BR/>Tested your workaround to install Apex 3.0 on XE and experienced some difficulties.<BR/><BR/>1. Did not succeed to run the scripts to install "the administrative interface" (4050) and "the request for workspace interface" (4700) in sqlplus via cmd.exe<BR/>There was no problem to run these scripts in toad with user FLOWS_030000 (after unlocking)<BR/><BR/>2. Scripts where renamed? <BR/>- @script\4050.sql => @builder\f4050.sql <BR/>- @script\4700.sql => @builder\f4700.sql <BR/><BR/><BR/>Regards,<BR/>PhilipAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21169145.post-54024664089737987572007-04-10T15:59:00.000+02:002007-04-10T15:59:00.000+02:00HI,i tested the apex 3.0 installation, on XE, if i...HI,<BR/><BR/>i tested the apex 3.0 installation, on XE, if i modify the coreins.sql as mentioned in the script it could'nt install APEX correctly, but if i do the standard installation, all works fine.<BR/><BR/>Setfpport to upload all images,<BR/>stop and start xe db,<BR/>apxxepwd.sql to set admin password.<BR/><BR/>Regards <BR/><BR/>PhilippePhilipitohttps://www.blogger.com/profile/07205400253124423407noreply@blogger.com