tag:blogger.com,1999:blog-5215551487816981140.post6898035875198390344..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Version 1.7 of Alexandria Utility Library for PL/SQLMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5215551487816981140.post-18823406532177479032013-04-18T23:07:59.177-07:002013-04-18T23:07:59.177-07:00@Martin: The link to Logger has been updated. NIce...@Martin: The link to Logger has been updated. NIce work with version 2, by the way!<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-82546751902366793452013-04-18T20:36:56.085-07:002013-04-18T20:36:56.085-07:00Hi Morten,
Can you please update the Logger URL t...Hi Morten,<br /><br />Can you please update the Logger URL to: https://github.com/tmuth/Logger---A-PL-SQL-Logging-Utility We've moved it to GitHub.<br /><br />Thanks,<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-28689582927297032602013-03-24T14:17:02.928-07:002013-03-24T14:17:02.928-07:00@Unknown: However, if the page/RSS feed you are tr...@Unknown: However, if the page/RSS feed you are trying to retrieve is protected by NTLM, you would probably get a "401 Unauthorized" error message instead of a "TNS: operation timed out" error... Try accessing the URL in a browser with network logging/debugging turned on, and you can see what headers the server is sending back.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-88101965462726610922013-03-24T14:11:33.616-07:002013-03-24T14:11:33.616-07:00@Unknown: Instead of using httpuritype().getclob()...@Unknown: Instead of using httpuritype().getclob() to retrieve the RSS contents, try using ntlm_http_pkg.get_response_clob(). If that works, then just pass the clob into the RSS parsing function.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-81462878169240950232013-03-20T22:37:45.950-07:002013-03-20T22:37:45.950-07:00I would like to use the RSS_UTIL_PKG to pull in da...I would like to use the RSS_UTIL_PKG to pull in data available in RSS feeds. However, since I am behind company firewalls I believe I need to use your NTLM_HTTP_PKG to use windows authentication to access the network. Is there a way to combine these two packages so that I can access RSS feeds through PL/SQL?<br /><br />Current error is:<br />ORA-29273: HTTP request failed<br />ORA-06512: at "SYS.UTL_HTTP", line 1819<br />ORA-12535: TNS:operation timed out<br />ORA-06512: at "SYS.HTTPURITYPE", line 34<br /><br />Great work on this collection of packages, EXTREMELY valuable!!Unknownhttps://www.blogger.com/profile/09833296925893253951noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-9689234472886061782013-02-17T23:23:23.084-08:002013-02-17T23:23:23.084-08:00I want to thank you Morten for the invaluable work...I want to thank you Morten for the invaluable work you're doing with this library. I'm impressed by the quality of your code.<br /><b>good job!</b><br />Davide Moraschihttps://www.blogger.com/profile/09241979020800080749noreply@blogger.com