tag:blogger.com,1999:blog-5215551487816981140.post2183981251119700403..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: APEX Plugin: Execute PL/SQL code and return content to page (updated)Morten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5215551487816981140.post-86244954832652666162020-08-16T04:29:28.387-07:002020-08-16T04:29:28.387-07:00@Yuri: I just tested the plugin (v1.1) on apex.ora...@Yuri: I just tested the plugin (v1.1) on apex.oracle.com, it works as expected. If you can make a test case on apex.oracle.com to show that it doesn't work, I can take a look.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-22802499714162713892020-05-19T02:26:54.422-07:002020-05-19T02:26:54.422-07:00Hi Morten,
I just tried to use the plugin on the ...Hi Morten,<br /><br />I just tried to use the plugin on the newest APES 20.1.0.00.13, it somehow does not work. Although, it works on 18.1.0.00.45 for me. <br /><br />Do you have any plans to fix the plugin for APEX 20?<br />Thank you in advance.YuriAPhttps://www.blogger.com/profile/14781383870484872725noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-2723444365985981752019-02-14T09:32:08.034-08:002019-02-14T09:32:08.034-08:00@Fahd: It depends. The built-ins expect you to ret...@Fahd: It depends. The built-ins expect you to return everything as a single string (probably with a 32k limit?), whereas the plugin lets you construct HTML of any length and complexity with one or more htp.p calls. Depending on the usage scenario, that may be a significant difference.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-26612616211068657482019-02-05T09:53:25.352-08:002019-02-05T09:53:25.352-08:00If i understand correctly we don't need plugin...If i understand correctly we don't need plugin to achieve said functionality in apex 5.1.4. <br /> <br />We can Execute PLSQL code in dynamic action to both execute PLSQL on server side as well as return data to client using property "Items to Return" .<br /><br />Fahdhttps://www.blogger.com/profile/07830276367604018761noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-79279023570042080132019-01-30T23:28:01.427-08:002019-01-30T23:28:01.427-08:00@Juergen: The apex.world catalog of plugins is gre...@Juergen: The apex.world catalog of plugins is great. The reason I haven't published my plugins there is because I am lazy and keep all my plugins in a single GitHub repository. To publish them on apex.world I would have to split them into a separate repository for each plugin. Not a big deal but still a hassle.<br /><br />A suggestion from me to make your catalog more flexible would be to also allow for an "apexplugins.json" (note plural) file in the GitHub repo root, which could then be an array of plugins (with the same structure as apexplugin.json) that could then contain multiple plugins published from a single repo. A small enhancement that could be useful for more than me? :-)<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-21851905250025810632019-01-30T13:25:22.720-08:002019-01-30T13:25:22.720-08:00Hi Morten, why don't you publish your Plug-in ...Hi Morten, why don't you publish your Plug-in on apex.world along with the other 180 Plug-ins, this is the place people look for Plug-ins, since you are on Github it's very easy for you just check the section Github for Plug-ins / Github for Contributors for a detailed explanation. Juergen Schusterhttps://www.blogger.com/profile/12979566632464799037noreply@blogger.com