{"id":7340,"date":"2015-06-29T15:38:05","date_gmt":"2015-06-29T15:38:05","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=7340"},"modified":"2017-05-12T15:26:07","modified_gmt":"2017-05-12T19:26:07","slug":"ora-06550-when-performing-a-forms-upgrade-in-pitss-con","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2015\/06\/29\/ora-06550-when-performing-a-forms-upgrade-in-pitss-con\/","title":{"rendered":"ORA-06550 When Performing a Forms Upgrade in PITSS.CON"},"content":{"rendered":"<p>When running a project for upgrading forms in PITSS.CON such as the project to replace the text_io function with webutil.client_text_io, if you happen to encounter the following error:<\/p>\n<p>Search&amp;Replace Error : ORA-06550: line 1, column 7:<\/p>\n<p>PLS-00306: wrong number or types of arguments in call to &#8216;SYNCRN&#8217;<\/p>\n<p>ORA-06550: line 1, column 7:<\/p>\n<p>PL\/SQL: Statement ignored.<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2015\/06\/image1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" title=\"image\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2015\/06\/image_thumb1.png\" alt=\"image\" width=\"596\" height=\"347\" border=\"0\" \/><\/a><\/p>\n<p>There is a possibility that you might have encountered a bug with the Oracle Database especially if the database version is 11.2.0.4. It has also been noted that this error also happens when you attempt to delete a form from Module Handling. There are two solutions which can be done to fix the problem:<\/p>\n<p>1. Apply Oracle Patch 17501296 to the Oracle Database (version 11.2.0.4 only). More information is provided in Oracle Support note 1586704.1.<\/p>\n<p>2. Re-create the CTXSYS.SYNCRN procedure. The full SQL commands can be found in Oracle Support note 1586704.1.<\/p>\n<p>After applying either one of the two solutions, the problem should no longer occur.<\/p>\n<p><strong>Source: Oracle Support note 1586704.1<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When running a project for upgrading forms in PITSS.CON such as the project to replace the text_io function with webutil.client_text_io, if you happen to encounter the following error: Search&amp;Replace Error : ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to &#8216;SYNCRN&#8217; ORA-06550: line 1, column 7: PL\/SQL: Statement ignored. [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[6,14,10],"tags":[11,16,25,12,7],"class_list":["post-7340","post","type-post","status-publish","format-standard","hentry","category-pitss-con","category-resolve-issues","category-windows","tag-11g","tag-11gr2","tag-customer-support-request","tag-error","tag-pitss-con"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=7340"}],"version-history":[{"count":3,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7340\/revisions"}],"predecessor-version":[{"id":9126,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7340\/revisions\/9126"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=7340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=7340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=7340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}