<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to feature-requests</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/" rel="alternate"/><link href="https://sourceforge.net/p/ora2pg/feature-requests/feed.atom" rel="self"/><id>https://sourceforge.net/p/ora2pg/feature-requests/</id><updated>2016-05-15T10:39:32.007000Z</updated><subtitle>Recent changes to feature-requests</subtitle><entry><title>#6 PLSQL_PGSQL parameter bug</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/6/?limit=50#50f3" rel="alternate"/><published>2016-05-15T10:39:32.007000Z</published><updated>2016-05-15T10:39:32.007000Z</updated><author><name>Darold Gilles</name><uri>https://sourceforge.net/u/darold/</uri></author><id>https://sourceforge.net113a18c637b1bea907178eef0bcf099bce57493f</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;Sorry for the response delay. What is the export type used and does the INPUT_FILE directive is set ? Which version of Ora2Pg?&lt;/p&gt;
&lt;p&gt;Regards&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>PLSQL_PGSQL parameter bug</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/6/" rel="alternate"/><published>2016-05-03T08:31:30.107000Z</published><updated>2016-05-03T08:31:30.107000Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net6d7d99cb8210fa36006c2dbf8dd8536e2ec89a5e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;br/&gt;
when I ran ora2pg (with no command line options) and I set  PLSQL_PGSQL to 0, &lt;br/&gt;
I have the same result as when I set PLSQL_PGSQL to 1.&lt;br/&gt;
In other words it seems ora2pg always translate PLSQL not taking in account PLSQL_PGSQL parameter value.&lt;br/&gt;
I think it's a bug.&lt;/p&gt;
&lt;p&gt;Thank you.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#5 Enable simultaneous ORACLE_COPIES and PARALLEL_TABLES </title><link href="https://sourceforge.net/p/ora2pg/feature-requests/5/?limit=50#0caa" rel="alternate"/><published>2015-11-01T21:58:52.091000Z</published><updated>2015-11-01T21:58:52.091000Z</updated><author><name>Darold Gilles</name><uri>https://sourceforge.net/u/darold/</uri></author><id>https://sourceforge.net9790e1c30a4674622c0c99b02cd12103e2a43b26</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;Please use github (see &lt;a href="http://ora2pg.darold.net/" rel="nofollow"&gt;http://ora2pg.darold.net/&lt;/a&gt; ) to report issues or feature request. ORACLE_COPIES is used to split data export of one table over multiple Oracle connections. This require to be able to use a column as the key for query partitionning and can only be done on table with huge amount of data. The PARALLEL_TABLES directive allow you to export several tables at the same time. Being able to use both directives at the same time required that you set DEFINED_PK for all table where ORACLE_COPIES should applies. As you know this is not possible to use those directives at the same time, but I don't see any reason to not enable this feature. I will try to work on it.&lt;/p&gt;
&lt;p&gt;Best regards&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Enable simultaneous ORACLE_COPIES and PARALLEL_TABLES </title><link href="https://sourceforge.net/p/ora2pg/feature-requests/5/" rel="alternate"/><published>2015-10-21T18:51:41.587000Z</published><updated>2015-10-21T18:51:41.587000Z</updated><author><name>Tom Boden</name><uri>https://sourceforge.net/u/trbode/</uri></author><id>https://sourceforge.netf321156e01a089848b8881c83bda523fdb59b872</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;It would be awesome if both ORACLE_COPIES and PARALLEL_TABLES could be implemented to work together.  We are going to be creating an extraction job running from AWS and as such will have several CPUs available to us and it would awesome to extract multiple tables with each one running in parallel.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#4 package and its function are not migrated (correct)</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/4/?limit=50#ef2d" rel="alternate"/><published>2015-07-31T15:13:04.707000Z</published><updated>2015-07-31T15:13:04.707000Z</updated><author><name>Darold Gilles</name><uri>https://sourceforge.net/u/darold/</uri></author><id>https://sourceforge.net0b861b8a810e99bc2c4857134f4d29ce4d58409f</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;The problem comes those two subfunction, this is not supported in PostgreSQL and break the Ora2Pg parser. You must defined them as main function before using Ora2Pg.&lt;/p&gt;
&lt;p&gt;Best regards.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>package and its function are not migrated (correct)</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/4/" rel="alternate"/><published>2015-07-31T13:35:46.359000Z</published><updated>2015-07-31T13:35:46.359000Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net9da97b8142112352cc30841d45dde1e776d991ce</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Dumping package LOADER...&lt;br /&gt;
Parsing function LOADER.elapsed_time...&lt;br /&gt;
        Dumping to one file per function: ./sources/packages/loader/elapsed_time_package.sql&lt;br /&gt;
Parsing function LOADER.check_if_already_active...&lt;br /&gt;
        Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql&lt;br /&gt;
Parsing function LOADER.check_if_already_active...&lt;br /&gt;
        Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql&lt;br /&gt;
Parsing function LOADER.check_if_already_active...&lt;br /&gt;
        Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql&lt;br /&gt;
Parsing function LOADER.preload_activate...&lt;br /&gt;
        Dumping to one file per function: ./sources/packages/loader/preload_activate_package.sql&lt;/p&gt;
&lt;p&gt;but the package has 4 functions  (in 1 function  there are 2 embedded subfunctions)&lt;/p&gt;
&lt;p&gt;so I don't know why it isn't exctracting and migrating all functions&lt;/p&gt;
&lt;p&gt;above times Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql&lt;/p&gt;
&lt;p&gt;can you explain me why?&lt;/p&gt;
&lt;p&gt;the package looks like:&lt;/p&gt;
&lt;p&gt;CREATE OR REPLACE PACKAGE HOMEGATE."LOADER"&lt;br /&gt;
  IS&lt;br /&gt;
--&lt;br /&gt;
-- Purpose:&lt;br /&gt;
--&lt;br /&gt;
-- MODIFICATION HISTORY&lt;br /&gt;
-- Person      Date       Comments&lt;br /&gt;
-- ---------   ------     ------------------------------------------&lt;br /&gt;
--&lt;br /&gt;
--------------------------------------------------------------------&lt;/p&gt;
&lt;p&gt;FUNCTION new_loader(...) return number ;&lt;br /&gt;
   FUNCTION empty_valid_directories_delete(log_path varchar2) return number ;&lt;br /&gt;
   FUNCTION suspended_agencies_delete(log_path varchar2) return number ;&lt;br /&gt;
   FUNCTION preload_activate(log_path varchar2) return number ;&lt;/p&gt;
&lt;p&gt;END loader; -- Package spec&lt;br /&gt;
/&lt;/p&gt;
&lt;p&gt;HINT:&lt;br /&gt;
the function new_loader contains the to subfunction (embedded functions) elapsed_time and check_if_already_active&lt;/p&gt;
&lt;p&gt;can this be the problem ?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#2 Option --input doesnt uderstand plsql with create [or replace] [editionable] keywords</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/2/?limit=50#19dc" rel="alternate"/><published>2015-05-14T14:05:50.376000Z</published><updated>2015-05-14T14:05:50.376000Z</updated><author><name>Darold Gilles</name><uri>https://sourceforge.net/u/darold/</uri></author><id>https://sourceforge.net72bd63e1dac3b36d6e6ad5148a95d4b93449f815</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;: open --&amp;gt; closed&lt;/li&gt;
&lt;/ul&gt;&lt;/div&gt;</summary></entry><entry><title>#2 Option --input doesnt uderstand plsql with create [or replace] [editionable] keywords</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/2/?limit=50#8c02" rel="alternate"/><published>2015-05-14T14:05:38.642000Z</published><updated>2015-05-14T14:05:38.642000Z</updated><author><name>Darold Gilles</name><uri>https://sourceforge.net/u/darold/</uri></author><id>https://sourceforge.net71177b291e613b127b2eb2501b85616c2bd8c4d9</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Fixed in github commits c853bdc and 4fe636&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#3 sub read_view_from_file</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/3/?limit=50#05ac" rel="alternate"/><published>2015-05-14T14:04:45.464000Z</published><updated>2015-05-14T14:04:45.464000Z</updated><author><name>Darold Gilles</name><uri>https://sourceforge.net/u/darold/</uri></author><id>https://sourceforge.netfe107cd5914b731ad886849d120c48525eff7ee3</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;: open --&amp;gt; closed&lt;/li&gt;
&lt;/ul&gt;&lt;/div&gt;</summary></entry><entry><title>#3 sub read_view_from_file</title><link href="https://sourceforge.net/p/ora2pg/feature-requests/3/?limit=50#d2ee" rel="alternate"/><published>2015-05-14T14:04:25.410000Z</published><updated>2015-05-14T14:04:25.410000Z</updated><author><name>Darold Gilles</name><uri>https://sourceforge.net/u/darold/</uri></author><id>https://sourceforge.netff0bc5f0e874a8acccd8de477b8425427f94d007</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Fixed in github commit f1c423e&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>