Re: Deletion

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(dot)klaver(at)aklaver(dot)com>
wrote:

> On 08/27/2014 11:59 AM, Ramesh T wrote:
>
>>
>> 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 ...
>>
>
> First as has been pointed out before Oracle != Postgres.
>
> 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(dot)klaver(at)aklaver(dot)com
>