tag:blogger.com,1999:blog-5215551487816981140.post4882687285415251970..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: How I hacked the Apex 4 WebsheetsMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5215551487816981140.post-16231732413947209532011-04-01T11:03:23.863-07:002011-04-01T11:03:23.863-07:00@Morten,
Note that I did not say "never"...@Morten,<br /><br />Note that I did not say "never". You asked if it was targeted for 4.1, and I said it was not.<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-6044946359453629112011-04-01T09:26:20.299-07:002011-04-01T09:26:20.299-07:00@Joel: What about providing websheets as a runtime...@Joel: What about providing websheets as a runtime option by specifying an additional parameter to the runtime installation script, so you can choose between including it or not ("runtime only" or "runtime with websheets")?<br /><br />As I said, I like the concept of Websheets and think it has potential, but I don't want to be forced to install the (less secure) full Apex environment just to use it. After all, minimizing the attack surface (and still using Websheets) was the whole point of this blog post, since at the moment the only supported option is less secure.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-13943229340627740012011-03-31T06:44:52.305-07:002011-03-31T06:44:52.305-07:00@Morten - it isn't solely about how trivial it...@Morten - it isn't solely about how trivial it is to get this working or not. The original purpose of a runtime installation is to minimize the attack surface of an APEX instance. This continues to be the goal.<br /><br />I hope this helps.<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-13020512479779865382011-03-30T23:29:26.925-07:002011-03-30T23:29:26.925-07:00@Joel: Thanks again for the info. Can I ask why yo...@Joel: Thanks again for the info. Can I ask why you don't plan on supporting it, given that the changes required to make it work seem rather trivial?<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-79359237940749230952011-03-30T11:46:55.743-07:002011-03-30T11:46:55.743-07:00Hi Morten,
Anything is possible. Right now, no, ...Hi Morten,<br /><br />Anything is possible. Right now, no, but anything can change based on sufficient customer demand.<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-9545024527215997182011-03-30T09:46:55.125-07:002011-03-30T09:46:55.125-07:00@Joel: Thanks for the feedback. I've just star...@Joel: Thanks for the feedback. I've just started exploring websheets and I think they can help in getting rid of many spreadsheets within an organization. However, they won't be of much help if they can't be deployed to a production environment...<br /><br />I guess I'm a bit disappointed that this option won't be supported in Apex 4.1. Do you have plans to support it further down the line?<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-66555681552490543692011-03-30T08:17:29.299-07:002011-03-30T08:17:29.299-07:00Hi Morten,
Interesting blog post and an excellent...Hi Morten,<br /><br />Interesting blog post and an excellent job of deduction.<br /><br />For any customers wishing to do this on their own production instances, I can assure you that not everything may work, Oracle Support won't be able to help if you have issues, and you may also encounter difficulties when upgrading.<br /><br />Websheets in a runtime environment will not be a supported option in Application Express 4.1.<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-50652763849656945772011-03-15T06:10:38.920-07:002011-03-15T06:10:38.920-07:00@Gary: We'll see...! But since the data is in ...@Gary: We'll see...! But since the data is in the APEX$ tables in my own schema, it probably is just a matter of re-importing application 4900.<br /><br />And I won't mind if my existing stuff breaks as long as the runtime deployment of Websheets becomes a supported option in Apex 4.1!<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-86310079422216034382011-03-14T15:06:51.825-07:002011-03-14T15:06:51.825-07:00Wanna bet whether it breaks when you get to upgrad...Wanna bet whether it breaks when you get to upgrade Apex ?SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.com