OK.. i created a function for delete customer from different tables in single database.
i want rollback..
my question:
where i need to place rollback ,with in a function along with deletion statements..? or after run the function ..?
i do not need commit..
please let me know..
On Thu, Aug 28, 2014 at 1:20 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 08/27/2014 11:59 AM, Ramesh T wrote:First as has been pointed out before Oracle != Postgres.
In oracle I ran the deletion script to clean up the particular database
using custid.custid is the parameter .&&1 is used in the oracle Inthe
same way tried but $1 not possible ?but using function is possible is
their any problem with fun to Clean the database I have 100 statements
in script ...
Also as been pointed out before you have two options:
1) Pay for the EDB Postgres Advanced Sever + and get the Oracle compatibility built ins.
2) Spend the time to convert your Oracle code.
As always it comes down to that magic combination of time and/or money.
Second I do not understand what you are trying to say above. Maybe if you showed some actual code it would help.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
