{"id":867,"date":"2006-02-05T12:00:00","date_gmt":"2006-02-05T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=867"},"modified":"2006-02-05T12:00:00","modified_gmt":"2006-02-05T12:00:00","slug":"faq-for-oracle-plsql-gateway-security-issue-released-by-david-litchfield","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/02\/05\/faq-for-oracle-plsql-gateway-security-issue-released-by-david-litchfield\/","title":{"rendered":"FAQ For Oracle PL\/SQL Gateway Security Issue Released by David Litchfield"},"content":{"rendered":"<p>I noticed on <a href=\"http:\/\/www.freelists.org\/archives\/oracle-l\/02-2006\/msg00178.html\">Oracle-L <\/a>that Oracle have a response to the David Litchfield Oracle PL\/SQL Gateway Security Issue workaround.<br \/><a href=\"http:\/\/www.freelists.org\/archives\/oracle-l\/02-2006\/msg00178.html\"> <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I noticed on Oracle-L that Oracle have a response to the David Litchfield Oracle PL\/SQL Gateway Security Issue workaround.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-867","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1637,"url":"http:\/\/orcldoug.com\/blog\/2013\/05\/15\/statistics-on-partitioned-tables-part-6e-copy_table_stats-bug\/","url_meta":{"origin":867,"position":0},"title":"Statistics on Partitioned Tables &#8211; Part 6e &#8211; COPY_TABLE_STATS &#8211; Bug","date":"May 15, 2013","format":false,"excerpt":"I'd bet regular readers might have guessed I'd never get back to the stats series, particularly given my extremely limited output this year Well, here goes ... The theme of this post is already covered in the paper and the presentation, so if you've read either of those, then you\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1320,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/23\/parallel-query-and-11g-part-2\/","url_meta":{"origin":867,"position":1},"title":"Parallel Query and 11g &#8211; Part 2","date":"September 23, 2007","format":false,"excerpt":"Now, that's weird. A little surprising might be more accurate and maybe I'm missing something.During the various tests with and without parallel hints and different parallel_io_cap_enabled settings, I expected the runs that didn't use parallelism to show up \"db file scattered read\" events in the trace files. For example, here's\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1056,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/19\/ausougoaug-2006-conference-announcement\/","url_meta":{"origin":867,"position":2},"title":"AUSOUG\/OAUG 2006 Conference Announcement","date":"August 19, 2006","format":false,"excerpt":"The AUSOUG and OAUG committees are very excited to announce the Australian 2006 conference series is less than three months away. While our American neighbours are focusing on Oracle OpenWorld in October, and our UKOUG friends on their (extended!) November conference, Australians will not miss out with the largest Oracle\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1264,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/06\/re-linking-oracle\/","url_meta":{"origin":867,"position":3},"title":"Re-linking oracle","date":"May 6, 2007","format":false,"excerpt":"Hooray! Something vaguely technical - at last.My new client is hot on software licence compliance and what seemed a minor issue to me reared it's slightly ugly head this week. When connecting to our 10.2.0.2 database instances using sqlplus, the version banner displays options that we aren't using, for example\u2026","rel":"","context":"With 21 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1691,"url":"http:\/\/orcldoug.com\/blog\/2012\/10\/14\/parallel-dml-and-odp-net\/","url_meta":{"origin":867,"position":4},"title":"Parallel DML and ODP.Net","date":"October 14, 2012","format":false,"excerpt":"I've been doing a lot of work around large volume data loads into an Oracle 11.2 database recently using External Tables and Parallelism and, despite the fact it's all used well-known techniques, I think it's probably worth a couple of posts to re-emphasise how successful using the right tools for\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1044,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/04\/tracing-session-activity-over-a-remote-database-link\/","url_meta":{"origin":867,"position":5},"title":"Tracing session activity over a remote database link","date":"August 4, 2006","format":false,"excerpt":"Yesterday someone asked me how to trace a session that selects from a view in a remote database via a link. If they activated the trace on the local instance, they wouldn't see the bulk of the work which was happening on the remote instance - just a bunch of\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=867"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/867\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=867"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}