× ÏÂÝÅÍ, ÐÏËÁ ÞÔÏ Õ ÍÅÎÑ ÅÓÔØ ÓÌÅÄÕÀÝÉÊ ×ÁÒÉÁÎÔ:
CREATE PROCEDURE GET_ATTACHMENT_ID
RETURNS (
ID INTEGER,
TIME_START TIMESTAMP,
IP VARCHAR(31) CHARACTER SET NONE,
HOST VARCHAR(31) CHARACTER SET NONE,
PROCESS_ID INTEGER,
DB_USER VARCHAR(120))
AS
begin
for select s.tmp$attachment_id from TMP$STATEMENTS s
order by s.tmp$timestamp desc, s.tmp$statement_id desc
into :id do begin
select ta.tmp$timestamp,
ta.tmp$user_ip_addr,
ta.tmp$user_host,
ta.tmp$user_process,
ta.tmp$user
from tmp$attachments ta
where ta.tmp$attachment_id=:id
into :time_start, :ip, :host, :process_id, :db_user;
suspend;
exit;
end
end
ÓÕÔØ: × ÔÁÂÌÉÃÅ TMP$STATEMENTS ÂÅÒÅÔÓÑ ÐÏÓÌÅÄÎÑÑ ÚÁÐÉÓØ ÐÏ ×ÒÅÍÅÎÉ É id(ÐÏËÁ
ÎÅ ÚÎÁÀ, ÚÁÞÅÍ É ÔÏ É ÄÒÕÇÏÅ). ÐÏ ÉÄÅÅ ÐÏÓÌÅÄÎÑÑ É ÅÓÔØ ÔÅËÕÝÁÑ(ÐÏÞÅÍÕ-ÔÏ
ÍÎÅ ÔÁË ËÁÖÅÔÓÑ), ÉÂÏ ÂÏÌÅÅ ÎÏ×ÙÈ ÚÁÐÒÏÓÏ× ÎÁ ÍÏÍÅÎÔ ÓÎÁÐÛÏÔÁ ÏÎÏ ÐÏ ÉÄÅÅ ÎÅ
×ÉÄÉÔ, Á ÂÏÌÅÅ ÓÔÁÒÙÅ, ÏÐÑÔØ ÖÅ ÐÏ ÉÄÅÅ, ÉÍÅÀÔ ÍÅÎØÛÉÊ id É ÔÁÊÍÛÔÁÍÐ...
ÖÄÕ ÚÁÍÅÞÁÎÉÊ É ÐÒÅÄÌÏÖÅÎÉÊ :)
Á ÔÏ ÎÁ ÂÏÌØÛÅÅ ÉÚ×ÒÁÝÅÎÉÅ(ÂÏÌÅÅ ÎÁÄÅÖÎÏÅ × ÐÌÁÎÅ ÒÅÚÕÌØÔÁÔÁ) Ñ ÐÏËÁ ÎÅ
ÓÐÏÓÏÂÅÎ :(
