tag:blogger.com,1999:blog-5215551487816981140.post8763802797709351003..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: jQGrid Integration Kit for PL/SQL and ApexMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-5215551487816981140.post-8231625311301560032012-05-05T00:03:54.487-07:002012-05-05T00:03:54.487-07:00Hi, Morten.
Well, hopefully, someone from the Ape...Hi, Morten.<br /><br />Well, hopefully, someone from the Apex team will take notice of your work and approach you about integrtaing your jQGrid with Apex.<br /><br />I look forward to your next release.<br /><br />Thanks so much for doing this. It's greatly appreciated.<br /><br />ElieEliehttps://www.blogger.com/profile/04759590911714369865noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-3733323302345933412012-05-04T02:55:29.687-07:002012-05-04T02:55:29.687-07:00@Elie:
1) No, but they are welcome to use anythin...@Elie:<br /><br />1) No, but they are welcome to use anything from the integration kit should they find it useful.<br /><br />2) I had not heard about jQTree before you mentioned it. Looks nice. Somebody should make an Apex plugin based on it... :-)<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-56996648789873507122012-04-29T14:50:21.461-07:002012-04-29T14:50:21.461-07:00Hello Morten.
Thanks very much for your quick res...Hello Morten.<br /><br />Thanks very much for your quick response.<br /><br />I, and from the comments I've seen in Google searching, many others as well, appreciate all you are doing, especially at your own time/expense.<br /><br />I will be checking this blog for any further updates.<br /><br />I do have two other questions.<br /><br />1) What you've done, integrating jQGrid with Apex, adds much value to the Apex IDE. As already mentioned, even the newest Apex 4.1.1 release doesn't have this functionality built-in. And so, I'm wondering if Oracle has approached you for permission to add your code into the default Apex release.<br /><br />2) Have you done, or, perhaps, planning to do, an integration of jQTree with Apex?<br /><br />Thanks, again, for all your fine work.<br /><br />ElieEliehttps://www.blogger.com/profile/04759590911714369865noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-80611701153095078292012-04-29T00:39:55.760-07:002012-04-29T00:39:55.760-07:00@Elie: Yes, I have made some rather important enha...@Elie: Yes, I have made some rather important enhancements since version 1.0, such as adding popup LOVs that support Apex bind variables and arbitrary column names. I'm actually at version 1.2 by my own count.<br /><br />I just need to do a final QA review and package it all up, hopefully I'll get that done in the not-to-distant future (yeah, I know I've said "soon" before...!).<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-24701563018879001922012-04-28T23:57:32.438-07:002012-04-28T23:57:32.438-07:00Hi, Morten.
I just now (April 2012) discovered yo...Hi, Morten.<br /><br />I just now (April 2012) discovered your "jQGrid Integration Kit for PL-SQL and Apex". Is there a version of this more recent than 1.0.0 (March 2010)? I saw a comment you made on the Apex Forum back in 2011 saying that an update would be forthcoming "soon".<br /><br />I really like what you've done, integrating the jQGrid plugin with Apex. As far as I can tell, even the most recent Apex version (4.1.1) doesn't support the features you've implemented in your package. And so, I'm hoping an updated version (with bug fixes, etc.) might be around the corner.<br /><br />Thank you very much.<br /><br />ElieEliehttps://www.blogger.com/profile/04759590911714369865noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-62198183366665022992010-11-10T06:38:53.969-08:002010-11-10T06:38:53.969-08:00@Tobin: Did you create the types, such as T_DICTIO...@Tobin: Did you create the types, such as T_DICTIONARY, before compiling the packages?<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-34835429615398603192010-11-09T06:01:56.651-08:002010-11-09T06:01:56.651-08:00Hi Morten,
I download the package and install it ...Hi Morten,<br /><br />I download the package and install it today. But I have many errors when running the install.sql script.<br />Example:<br />**************<br />When compiling "jqgrid_pkg.pkb"<br />Error(104,7): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(104,7): PL/SQL: Statement ignored<br />Error(169,5): PL/SQL: Statement ignored<br />Error(169,22): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(257,5): PL/SQL: Statement ignored<br />Error(257,22): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(302,3): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(302,3): PL/SQL: Statement ignored<br />Error(373,3): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(373,3): PL/SQL: Statement ignored<br />Error(409,3): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(409,3): PL/SQL: Statement ignored<br />Error(450,5): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(450,5): PL/SQL: Statement ignored<br />Error(561,3): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(561,3): PL/SQL: Statement ignored<br />Error(562,3): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(562,3): PL/SQL: Statement ignored<br />Error(564,3): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(564,3): PL/SQL: Statement ignored<br />**************<br />compiling "jqgrid_util_pkg.pks"<br />Error(52,3): PL/SQL: Declaration ignored<br />Error(53,40): PLS-00201: identifier 'T_DICTIONARY' must be declared<br />****************<br />compiling "jqgrid_util_pkg.pkb"<br />Error: PL/SQL: Compilation unit analysis terminated<br />Error(1,14): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(1,14): PLS-00304: cannot compile body of 'JQGRID_UTIL_PKG' without its specification<br />****************<br />Compiling "jqgrid_public_pkg.pkb"<br />Error(51,5): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(51,5): PL/SQL: Statement ignored<br />Error(117,5): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(117,5): PL/SQL: Statement ignored<br />Error(134,5): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(134,5): PL/SQL: Statement ignored<br />Error(160,3): PL/SQL: Statement ignored<br />Error(160,12): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(173,22): PLS-00201: identifier 'T_DICTIONARY' must be declared<br />Error(173,22): PL/SQL: Item ignored<br />Error(201,5): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(201,5): PL/SQL: Statement ignored<br />Error(210,3): PL/SQL: Statement ignored<br />Error(210,11): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(213,5): PLS-00320: the declaration of the type of this expression is incomplete or malformed<br />Error(213,5): PL/SQL: Statement ignored<br />Error(214,5): PLS-00320: the declaration of the type of this expression is incomplete or malformed<br />Error(214,5): PL/SQL: Statement ignored<br />Error(225,7): PLS-00905: object EPDDEV.JQGRID_UTIL_PKG is invalid<br />Error(225,7): PL/SQL: Statement ignoredUnknownhttps://www.blogger.com/profile/00793205439427886936noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-84854380858522687002010-04-10T05:08:50.440-07:002010-04-10T05:08:50.440-07:00Hello
I do exactly equal, but dont data load in t...Hello<br /><br />I do exactly equal, but dont data load in the grid. <br />There are data in array but not show in the grid.<br /><br />what i can do to resolve this?Unknownhttps://www.blogger.com/profile/01203978194863276270noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-2816192568666429322010-04-10T05:06:05.673-07:002010-04-10T05:06:05.673-07:00@Vinicius: To use the integration kit without Apex...@Vinicius: To use the integration kit without Apex, you use the same code but put it in a stand-alone PL/SQL procedure (invoked via mod_plsql) instead of a PL/SQL page region in Apex.<br /><br />See the example code under "Basic example" on the project page: http://code.google.com/p/jqgrid-for-plsql/Morten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-58229909586006010042010-04-08T09:28:47.114-07:002010-04-08T09:28:47.114-07:00hello
How i use without apex?
Do you have some e...hello<br /><br />How i use without apex?<br /><br />Do you have some example?<br /><br /><br />Thank youUnknownhttps://www.blogger.com/profile/01203978194863276270noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-32897744883570985272010-03-09T09:04:54.590-08:002010-03-09T09:04:54.590-08:00This comment has been removed by the author.mnolanhttps://www.blogger.com/profile/03589368399513500774noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-9057462158405398552010-03-08T21:11:05.954-08:002010-03-08T21:11:05.954-08:00I have downloaded your JQgrid application. It'...I have downloaded your JQgrid application. It's amazing.<br /><br />Thanks for your good work.SATHEESH KUMARhttps://www.blogger.com/profile/10804277613487164342noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-69976919180900275362010-03-08T06:00:46.931-08:002010-03-08T06:00:46.931-08:00Moten,
Many thanks for sorting out the issue.
T...Moten,<br /><br />Many thanks for sorting out the issue. <br /><br />Thanks & Regards,<br />BhavinBhavin Adhvaryuhttps://www.blogger.com/profile/02159997681508106430noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-9013311240927241252010-03-08T05:26:49.133-08:002010-03-08T05:26:49.133-08:00@Bhavin: I logged into your workspace and looked a...@Bhavin: I logged into your workspace and looked at the demo application. You had mis-spelled #WORKSPACE_IMAGES# (as #WORSPACE_IMAGES#, missing the "K") in the page template, I corrected this.<br /><br />Page 2 is working and displays three grids now (but as noted they are read-only since we can't call URL procedures on apex.oracle.com).Morten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-64052170614688229252010-03-08T05:13:59.024-08:002010-03-08T05:13:59.024-08:00This comment has been removed by the author.Bhavin Adhvaryuhttps://www.blogger.com/profile/02159997681508106430noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-75254744641923486922010-03-08T05:07:07.359-08:002010-03-08T05:07:07.359-08:00@Bhavin: The configuration for the grid on page 3 ...@Bhavin: The configuration for the grid on page 3 is missing from the demo files (as Dimitri pointed out), will fix this in next release.<br /><br />If you want to send me your email address (or the Apex login credentials), you can put it in a comment on this blog article, and then delete the comment immediately afterwards. I will get your email in the comment notification, but it will not be visible to anyone else.Morten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-36890747325135916292010-03-08T05:04:48.124-08:002010-03-08T05:04:48.124-08:00@Prabahar: I tried this on my own 11.1.0.6 databas...@Prabahar: I tried this on my own 11.1.0.6 database, and it works.<br /><br />I think the XSL stylesheet is missing a few characters in your installation (see line 196 of JSON_UTIL_PKG in your database and compare it to the source on disk).<br /><br />Please try to recompile the package body from SqlPlus, but run the "SET SCAN OFF" command first, to make sure the special characters in the XSLT string are not being misinterpreted. (Will add this to my installation script for the next release.)Morten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-74700904009165787162010-03-08T04:53:18.617-08:002010-03-08T04:53:18.617-08:00Hi Morton,
Many thanks for your prompt reply.
I...Hi Morton,<br /><br />Many thanks for your prompt reply. <br /><br />I have downloaded the demo application and all the necessary objects (pkg, tables, types, js, css, img etc.).<br /><br />I am not getting any output for page 2 and page 3 giving error as configuration for ord detail is missing.<br /><br />I have put the js/css file on page template so not running the jqgrid_pkg.include_static_files region.<br /><br />Please send me your email id so I can send my login credentials to look at. Your help would be appreciated. <br /><br />Thanks & Regards,<br />BhavinBhavin Adhvaryuhttps://www.blogger.com/profile/02159997681508106430noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-91195217622904424712010-03-08T04:28:16.179-08:002010-03-08T04:28:16.179-08:00@Bhavin: This should work on apex.oracle.com (assu...@Bhavin: This should work on apex.oracle.com (assuming the JSON generation works as expected there).<br /><br />However, due to security (we are not allowed to call our own procedures directly from the URL at apex.oracle.com), the jqgrid_public_pkg cannot be called, so insert/update/delete will not work (so the grids will in effect be read-only at apex.oracle.com).Morten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-33761800290757581902010-03-08T03:49:39.457-08:002010-03-08T03:49:39.457-08:00Very good work Morten!
As Dimitri pointed earlier...Very good work Morten!<br /><br />As Dimitri pointed earlier it would be nice to use Supporting Objects to import & test.<br /><br />I am looking forward to install Demo Application but before I install and do any testing, would this demo application work on Oracle APEX hosted site? (www.apex.oracle.com). If so what changes do I have to make.<br /><br />Please do reply. Also looking forward to your updated version.<br /><br />Very good work Morten.<br /><br />Thanks & Regards,<br />BhavinBhavin Adhvaryuhttps://www.blogger.com/profile/02159997681508106430noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-45671220913961703062010-03-08T03:40:00.362-08:002010-03-08T03:40:00.362-08:00Morten
I am using 11.1.0.6Morten<br />I am using 11.1.0.6Prabaharhttps://www.blogger.com/profile/16124656852154184013noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-2230377784694984042010-03-08T03:38:50.878-08:002010-03-08T03:38:50.878-08:00@Prabahar: What version of Oracle are you using?
...@Prabahar: What version of Oracle are you using?<br /><br />@Dimitri: I am using Oracle XE (10gR2) to develop and test. Do you have an XE (or 10gR2) instance you can try it on?Morten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-40729810644939920642010-03-08T02:46:23.453-08:002010-03-08T02:46:23.453-08:00Hi Morten,
Are you on 11g? I tested this on a 10g...Hi Morten,<br /><br />Are you on 11g? I tested this on a 10gR1 db... I've seen before 10gR1 isn't great for XML.<br /><br />Thanks,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-24023822555368258322010-03-08T02:05:14.125-08:002010-03-08T02:05:14.125-08:00Morten very nice indeed
I got same error message ...Morten very nice indeed<br /><br />I got same error message like Dimitri menstioned. I have <br />tested JSON_UTIL_PKG.REF_CURSOR_TO_JSON like you said and i am getting below error msg in TOAD<br /><br />and this is what i am executing<br />select json_util_pkg.ref_cursor_to_json(cursor(select * from emp))<br />from dual<br /><br />Error<br />ORA-31011: XML parsing failed<br />ORA-19202: Error occurred in XML processing<br />LPX-00601: Invalid token in: '*[count(../*[name(../*)=name(.)])=count(../*) and count(../*);1]'<br />ORA-06512: at "SYS.XMLTYPE", line 187<br />ORA-06512: at "APEX_APP.JSON_UTIL_PKG", line 269<br />ORA-06512: at line 1<br /><br />Thanks for good work<br />PrabaharPrabaharhttps://www.blogger.com/profile/16124656852154184013noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-3969470311657570972010-03-08T01:29:14.863-08:002010-03-08T01:29:14.863-08:00@Dimitri: Great feedback, thanks for testing this ...@Dimitri: Great feedback, thanks for testing this out!<br /><br />I'll work on improving the packaging of the demo application.<br /><br />With regard to the JSON error you get, it seems that for some reason, the dates (HIREDATE, etc.) are not quoted in the output (although they are on my development machine, and you seem to use the same date format...). Can you try running the JSON_UTIL_PKG.REF_CURSOR_TO_JSON function directly (from SqlPlus or TOAD) and see what the output looks like? Refer to my previous post (http://ora-00001.blogspot.com/2010/02/ref-cursor-to-json.html) for some examples of the output you should see.Morten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.com