tag:blogger.com,1999:blog-5215551487816981140.post6246776665906215004..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Using VS Code for PL/SQL developmentMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-5215551487816981140.post-58274697495056512272019-06-14T02:52:03.812-07:002019-06-14T02:52:03.812-07:00Hi folks,
thanks for sharing your knowledge,
i hav...Hi folks,<br />thanks for sharing your knowledge,<br />i have also Version 2.0 and changed a little bit of your Code and it runs:<br /><br />_run_sqlplus.bat:<br />rem Setup sqlplus environment for Unicode<br />rem Run this before running scripts that contain multibyte characters<br />set NLS_LANG=.AL32UTF8<br />chcp 65001<br /><br />rem show raw error messages from sqlplus<br />rem echo exit | echo show errors | sqlplus %1 %2<br /><br />rem get errors that can be parsed with problemMatcher<br />cls<br />echo exit | echo @_show_errors.sql | sqlplus -s %1 %2<br /><br /><br />task.json<br />{<br /> "version": "2.0.0",<br /><br /> // Run sqlplus via a batch file<br /> "windows": {<br /> "command": "./_run_sqlplus.bat"<br /> },<br /> "osx": {<br /> "command": "./_run_sqlplus.sh"<br /> },<br /> "linux": {<br /> "command": "./_run_sqlplus.sh"<br /> },<br /><br /> "presentation": {<br /> "reveal": "always", // never,silent,always<br /> "panel": "shared" // new,shared,dedicated<br /> },<br /><br /> // first argument is the database connection string<br /> // second argument is the file to execute (ie the current file)<br /> "args": ["scott/tiger@172.30.30.2:1521/xe.muniqsoft-training.de", "@${file}"],<br /><br /> // use this to get any database errors (from user_errors view) listed in the "Problems" pane in VS Code<br /> "problemMatcher": {<br /> "owner": "plsql",<br /> "fileLocation": ["relative", "${fileDirname}"],<br /> "pattern": [<br /> {<br /> "regexp": "(.*) (\\d*)\/(\\d*) (.*?) (.*)",<br /> "severity": 1,<br /> "line": 2,<br /> "column": 3,<br /> "file": 4,<br /> "message": 5,<br /> "loop": true<br /> }<br /> ]<br /> }<br />}<br /><br />If you have still problems with the Path, yous a full qualified path like c:\temp\test.sql<br /><br />Hope this helps!<br />MarcoMarco Patzwahlhttp://www.muniqsoft-training.denoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-42730282687376692572019-01-30T10:12:22.025-08:002019-01-30T10:12:22.025-08:00@Peter: Last time I looked into this (some months ...@Peter: Last time I looked into this (some months ago), I couldn't get it to work with the 2.0.0 version, so I switched back to the 0.1.0 version. Haven't had free time to investigate since then.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-62507761912778499042019-01-30T04:28:07.105-08:002019-01-30T04:28:07.105-08:00Could you please share the config and script for u...Could you please share the config and script for use with the 2.0.0 version?<br />It works when just using the sqlplus in the bat file , but can't get it to work with the showerrors.peterhttps://www.blogger.com/profile/14151404452279542278noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-9910033155003883962018-11-12T03:11:21.054-08:002018-11-12T03:11:21.054-08:00@Yves, I've had similar problems when I tried ...@Yves, I've had similar problems when I tried to switch from version "0.1.0" in the tasks.json file to the newer "2.0.0" version. Please check your version and see if that helps.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-22496690735144598562018-11-06T06:59:20.429-08:002018-11-06T06:59:20.429-08:00Hey @Morten Braten,
Thanks for the very detailed d...Hey @Morten Braten,<br />Thanks for the very detailed desciption of how to use Visual Code for PL/SQL Development.<br /><br />I have a big problem getting your compiling running. I did everything like you described it, but I will get the following error: <br /><i><br />_run_sqlplus.bat : Die Benennung "_run_sqlplus.bat" wurde nicht als Name eines Cmdlet, einer Funktion, einer Skriptdatei oder eines ausführbaren Programms erkannt. Überprüfen Sie die Schreibweise des Namens, oder ob<br />der Pfad korrekt ist (sofern enthalten), und wiederholen Sie den Vorgang.<br />In Zeile:1 Zeichen:1<br />+ _run_sqlplus.bat apps/apps@ebs14srv.intern.promatis.de:1521/EBS14SRV ...<br />+ ~~~~~~~~~~~~~~~~<br /> + CategoryInfo : ObjectNotFound: (_run_sqlplus.bat:String) [], CommandNotFoundException<br /> + FullyQualifiedErrorId : CommandNotFoundException<br /></i><br /><br />Do you have an idea, what I did wrong?<br /><br />Regards<br />YvesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-50731389664095005342018-06-30T05:28:04.113-07:002018-06-30T05:28:04.113-07:00@Unknown: This blog post is not about the pivot pl...@Unknown: This blog post is not about the pivot plugin. Please post your comments to the appropriate blog post.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-46862903483668165992018-06-26T22:24:58.407-07:002018-06-26T22:24:58.407-07:00I have the Pivot plug-in installed in my applicati...I have the Pivot plug-in installed in my application and the Pivot is working fine. <br />I need to generate the reports dynamically based on the selection of the Pivot parameters.<br /><br />Appreciate if you can kindly provide me any assistance related to this.Anonymoushttps://www.blogger.com/profile/12997612610296531011noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-29529617667226163992018-01-06T12:54:12.834-08:002018-01-06T12:54:12.834-08:00Hi Morten,
Big thanks for converting me to VSC.Hi Morten,<br />Big thanks for converting me to VSC.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-44327795417035065912017-10-26T08:22:53.414-07:002017-10-26T08:22:53.414-07:00Hi,
I have errors in the "OUTPUT" tab, n...Hi,<br />I have errors in the "OUTPUT" tab, not in "PROBLEMS".<br />So text is not colorized.<br />I use run task, not build, because I don't have package.json file.<br /><br />Can you help me?<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-27670442612673588112017-06-29T12:37:58.829-07:002017-06-29T12:37:58.829-07:00Thanks it's working, but not all errors are a...Thanks it's working, but not all errors are appear in problem section. I think there must be some problem with regular expression.<br /><br />for example this error wasn't appeared.<br /><br />"error 901/64 xxxxxxxxxxxxxxx.sql PLS-00103: Encountered the symbol "," when expecting one of the following:<br /><br /> . ( * % & = - + ; < / > at in is mod remainder not rem<br /> <> or != or ~= >= <= <> and or like like2<br /> like4 likec between || multiset member submultiset<br />"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-69264437613661069772017-06-28T02:39:14.664-07:002017-06-28T02:39:14.664-07:00Big thanks to this blog!
Works very well for me w...Big thanks to this blog!<br /><br />Works very well for me with latest 11gAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-46798328844241551782017-06-27T07:17:55.903-07:002017-06-27T07:17:55.903-07:00@Anonymous:
> "this outputs ALL database ...@Anonymous:<br /><br />> "this outputs ALL database errors, and we have hundreds"<br /><br />Sounds messy! I prefer a clean dev environment with as few errors as possible...<br /><br />> "The package is named "test.pkb", so it passes "test" through all those steps. But I get nothing selected. Any idea what I'm missing?"<br /><br />In step 3, I think you need single quotes before and after the &1 because that gets passed as a literal value to the script? Ie:<br /><br />and lower(name) like '%' || lower('&1') || '%'<br /><br /><br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-28805830033797797202017-06-23T15:25:28.280-07:002017-06-23T15:25:28.280-07:00This helped out a l lot. Thank you. However, thi...This helped out a l lot. Thank you. However, this outputs ALL database errors, and we have hundreds. I tried to make it only output the errors for the package I was currently compiling but I can't get it to work. I think I'm very close though. This is what I did...<br /><br />(1) I added "${fileBasenameNoExtension}" to the list of args in the tasks.json file.<br /><br />(2) I pass that new arg through to the _run_sqlplus.bat like so: echo exit | echo @_show_errors.sql %3 | sqlplus %1 %2<br /><br />(3) Then I add this to the where clause in _show_errors.sql: and lower(name) like '%'||lower(&1)||'%'<br /><br />The package is named "test.pkb", so it passes "test" through all those steps. But I get nothing selected. Any idea what I'm missing?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-82002669717703801632017-05-11T04:13:42.310-07:002017-05-11T04:13:42.310-07:00Thanks for this great blog. I'm just facing an...Thanks for this great blog. I'm just facing an error due to blanks in my path.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-34160169821222840992017-03-25T13:09:08.706-07:002017-03-25T13:09:08.706-07:00Just saying SUPER THANKS for all your great articl...Just saying SUPER THANKS for all your great articles and time invested. helped me (and I am sure others ) A LOT !.Etay Gudai - Oracle Israelhttps://www.blogger.com/profile/14316771717388275941noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-18064021300691979492017-03-24T18:06:51.366-07:002017-03-24T18:06:51.366-07:00Comparing with Atom, VS Code is a better choice fo...Comparing with Atom, VS Code is a better choice for less RAM consumption and faster response, at least on Win10. Using an old but usable software glass2k to change the <a href="https://twitter.com/iMingLei/status/845440759696281600" rel="nofollow">transparency</a> will make it nicer.Ming (Tim) Leihttps://www.blogger.com/profile/16825749044131869894noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-50374855819019263842017-03-23T15:03:21.146-07:002017-03-23T15:03:21.146-07:00Thanks for posting this. I've been thinking ab...Thanks for posting this. I've been thinking about trying it out. I love the Node.js debugging and the GitHub integration! Nice!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-26034309478121614022017-03-23T09:54:01.425-07:002017-03-23T09:54:01.425-07:00Thanks for this Morten.
I'd already started u...Thanks for this Morten. <br />I'd already started using VS Code but hadn't been able to explore this stuff due to being too busy.<br /><br />Your blog has given me the push start I needed!<br /><br />Well written, easy to follow stepsGussayhttps://www.blogger.com/profile/07778607901743695099noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-16874080351768588812017-03-21T13:39:12.369-07:002017-03-21T13:39:12.369-07:00Thanks so much for this. Really clear, easy to fol...Thanks so much for this. Really clear, easy to follow and a great little editor.<br /><br />I plan to run it alongside atom to do a compare and contrast.Anonymoushttps://www.blogger.com/profile/11987444685189123347noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-37152772454011494602017-03-21T07:37:37.554-07:002017-03-21T07:37:37.554-07:00This is awesome! By reformatting the errors I was...This is awesome! By reformatting the errors I was able to get the errors recognized on Sublime Text. Very cool...<br />Now to find some time with VCJorge Rimblashttps://www.blogger.com/profile/00974290778463044456noreply@blogger.com