{"id":257,"date":"2018-10-25T17:37:08","date_gmt":"2018-10-25T16:37:08","guid":{"rendered":"http:\/\/wp.bizoir.dk\/?p=257"},"modified":"2018-12-23T11:08:41","modified_gmt":"2018-12-23T10:08:41","slug":"why-does-sqlplus-not-execute-my-command-file","status":"publish","type":"post","link":"https:\/\/wp.bizoir.dk\/?p=257","title":{"rendered":"Why does SQLPlus not execute my command-file"},"content":{"rendered":"

Oracle SQLPlus is an effective tool, but sometimes it has some hard-to-explain behavior.<\/p>\n

Like when you try to get it to replace an existing view, and all that happens, is that it very patiently does – nothing at all.<\/p>\n

There are several possible reasons – where SQLPlus has requirements that other SQL tools (like Toad) does not have.<\/p>\n

http:\/\/www.vertabelo.com\/blog\/notes-from-the-lab\/blank-lines-in-sql-plus<\/a><\/p>\n

    \n
  1. Blank lines prevent the execution of a command in SQL*PlusA blank line in a SQL statement or script tells SQL*Plus that you have finished entering the command, but do not want to run it yet.If you\u2019re writing or generating SQL scripts for SQL*Plus, make sure there are no blank lines in your SQL commands or the statements will not be executed.\n

    This only seems to be required for views. Packages are executed even if they contain some blank lines<\/li>\n

  2. Package replace script must end with a “\/”<\/li>\n<\/ol>\n

    [srs_total_visitors]<\/p>\n","protected":false},"excerpt":{"rendered":"

    Oracle SQLPlus is an effective tool, but sometimes it has some hard-to-explain behavior. Like when you try to get it to replace an existing view, and all that happens, is that it very patiently does – nothing at all. There are several possible reasons – where SQLPlus has requirements that other SQL tools (like Toad) … Continue reading “Why does SQLPlus not execute my command-file”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[25],"class_list":["post-257","post","type-post","status-publish","format-standard","hentry","category-diverse","tag-oracle"],"_links":{"self":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=257"}],"version-history":[{"count":4,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/257\/revisions"}],"predecessor-version":[{"id":342,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/257\/revisions\/342"}],"wp:attachment":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}