Hi All,Issue is when I am trying to convert the Oracle objects online connection to Oracle and generating the converted files for the Postgresql even after the oraface is configured it is not replacing the oracle functionalities to be used in the PG. I will have to do the change manually. Could someone point where we ware doing wrong.Below are the details of the environment that we are using Ex : "Raise application exception" is getting converted in to raise exception like this many other.
Platform Windows 7Oracle 11g XEPostgreSQL 11Oraface 3.6.2Ora2PG V19Configuration file has USE_ORAFCE 1 ( tried with 0 too)Please advise.Thanks
--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/2241c675-f27c-4b59-a6db-65fc1ef311d3%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAFj8pRAFix5wzZ%2ByKv8XZWZnPfoJ7p4tYC0xe0X7_wLYCen3Lg%40mail.gmail.com.
Thank you for your quick email Pavel.I am sorry for the confusionOracle functions like :dbms_outputSelect * from dual;Sysdate()And other oracle functions that sould support when orafce is used is not getting convertedAny pointer
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CADPrz7_-mrbDtgxWLCDeturi2Nf48U8Mn7%3Dv3qwSXG2CNvrFyA%40mail.gmail.com.
Oracle: | |
create or replace PROCEDURE TO_CHAR_TEST AS v_text varchar2(50); v_month date; v_trunc date; BEGIN select to_char(birthdate) into v_text from employees1 where firstname ='Nancy'; DBMS_OUTPUT.PUT_LINE(v_text); select ADD_MONTHS('01-Aug-03', 12) into v_month from dual; DBMS_OUTPUT.PUT_LINE(v_month); select trunc(systimestamp) into v_trunc from dual; DBMS_OUTPUT.PUT_LINE(v_trunc); END; |
Thank you.Manish
Hi
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/2241c675-f27c-4b59-a6db-65fc1ef311d3%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAFj8pRAFix5wzZ%2ByKv8XZWZnPfoJ7p4tYC0xe0X7_wLYCen3Lg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-...@googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/b972014e-453c-418f-b0ee-e813b525bd13%40googlegroups.com.
i have tested orafce 3.6.2 on windows 32 bit machine and is working fine.Now i would like to know where i can get precomplied version of Orafce for pg11 for windows 64 bit machine?
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CADPrz79cuAHfT9iwCP_%2BP1jLGQQzAVrzyHqEQwKc6K%2BjKdvcmw%40mail.gmail.com.
Please do let me know if you need any further information. \
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/b972014e-453c-418f-b0ee-e813b525bd13%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAFj8pRAKGTFkzycLhAooFw4qm8hqLW64XN5AnNk0iUtw8cOCBA%40mail.gmail.com.
Thank you for your email Pavel.1. My Oracle Code which has oracel functions such as add_month(), add_year(), date_trunc() and to_char() is getting converted in to PG relevant but not all other.
2. Could you please share the path for ora2pg v19 precompiled binary for pg 11 version. This is for windows 64 bit
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CADPrz79EkZE8C%3Dn5OOoPFAx9r0wnbfRAS18HzSVQNyVOy0jnqQ%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAFj8pRBniK0w_Uoe4Qyz_6JG2rMVzRydVCFvaf3Mt7PUzw4Jvw%40mail.gmail.com.
Thank you for your email and helpful information on this conversion.Thanks again for your help
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CADPrz7-2wPCngeC%3DK5Xx0JrvXbHU%3D6aXEz%3D%3DjFsPMAMFOSPy9g%40mail.gmail.com.