Actullay there is no transaction support in internal PG routines.
So the code you posted is not translatable in PG PL/SQL because it
involve a transaction inside the process.
A +
Le 30/01/2012 07:42, Rehan Saleem a écrit :
hi , how i can convert this store procedure to PostgreSQL function,
especially I really dont know how to set type to readonly in PostgreSQL.
thanks
ALTERPROCEDURE [dbo].[sp_DeleteUserData]
@ACDetailsID dbo.ACdetailsID_type READONLY
AS
DECLARE@ID int
begintry
begintransaction
DECLARE c_ACDetailsID CURSOR FOR SELECT id FROM @ACDetailsID
OPEN c_ACDetailsID
FETCH NEXT FROM c_ACDetailsID INTO @ID
WHILE (@@FETCH_STATUS = 0) BEGIN
delete from UserAccountDetails where UserDataAcountId=@ID
delete from UserAC where UserDataAcountId=@ID
FETCH NEXT FROM c_ACDetailsID INTO @ID
End--end of while loop
committransaction
CLOSEc_ACDetailsID
DEALLOCATEc_ACDetailsID
endtry
begincatch
rollback transaction;
print error_message(
--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
