|
1love
Starting Member
3 Posts |
 Posted - 01/23/2013 : 11:42:26
|
Hi,
here is a code:
BEGIN
begin transaction
DECLARE column_not_found
EXCEPTION FOR SQLSTATE '52003';
UPDATE PRACOWNIK
SET IDADRES=29
WHERE IDPRACOWNIK=20;
IF (SELECT IDSTANOWISKO
FROM STANOWISKO
GROUP BY IDSTANOWISKO, PENSJA
HAVING PENSJA=(SELECT MIN(X.PENSJA)
FROM (SELECT IDSTANOWISKO, PENSJA
FROM STANOWISKO
WHERE PENSJA>(SELECT S.PENSJA
FROM STANOWISKO S, PRACOWNIK P
WHERE P.IDSTANOWISKO=S.IDSTANOWISKO AND P.IDPRACOWNIK=20)) X)) IS NULL THEN
BEGIN
SIGNAL column_not_found
END
ENDIF;
commit transaction;
EXCEPTION
WHEN column_not_found THEN
begin
rollback transaction;
MESSAGE 'Column not found handling.' TO CLIENT;
end
WHEN OTHERS THEN
RESIGNAL ;
END
why im getting syntax error near 'TRANSACTION' ?
thx in advance |
Edited by - 1love on 01/23/2013 13:03:51
|
|
[sql] Syntax error, transaction problem
