10-12-2017, Saat: 16:27
[Ars=sql]SET TERM ^ ;
CREATE PROCEDURE COPY_FOLDER(
FOLDER_ID BIGINT NOT NULL,
NEW_PARENT_ID BIGINT NOT NULL)
AS
DECLARE VARIABLE fID BIGINT;
DECLARE VARIABLE FNAME VARCHAR(255) COLLATE PXW_TURK;
DECLARE VARIABLE NEW_ID BIGINT;
BEGIN
SELECT coalesce(ID,0),F_NAME FROM FOLDER where ID =:FOLDER_ID into :FID, :FNAME;
if (FID <> 0) then
begin
EXECUTE PROCEDURE C_FOLDER1( :NEW_PARENT_ID, :FNAME) returning_values( :NEW_ID );
EXECUTE PROCEDURE COPY_FILE_ALL( :FOLDER_ID, :NEW_ID);
COMMIT
for SELECT ID,F_NAME FROM FOLDER where PRN_ID =:FOLDER_ID into :FID, :FNAME do
begin
EXECUTE PROCEDURE COPY_FOLDER( :FID, :NEW_ID);
end
end
END^
SET TERM ; ^[/ars]
DB de bulunan klasör yapısını kopyalamak için bir procedure yazmaya çalışıyorum fakat
Too many concurrent executions of the same request.
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At proce...
SQL Code: -693
IB Error Number: 335544663
Procedure çalıştırdığım zaman
hatası ile karşılaşıyorum.
Bilgisi olan varmı acaba ?
CREATE PROCEDURE COPY_FOLDER(
FOLDER_ID BIGINT NOT NULL,
NEW_PARENT_ID BIGINT NOT NULL)
AS
DECLARE VARIABLE fID BIGINT;
DECLARE VARIABLE FNAME VARCHAR(255) COLLATE PXW_TURK;
DECLARE VARIABLE NEW_ID BIGINT;
BEGIN
SELECT coalesce(ID,0),F_NAME FROM FOLDER where ID =:FOLDER_ID into :FID, :FNAME;
if (FID <> 0) then
begin
EXECUTE PROCEDURE C_FOLDER1( :NEW_PARENT_ID, :FNAME) returning_values( :NEW_ID );
EXECUTE PROCEDURE COPY_FILE_ALL( :FOLDER_ID, :NEW_ID);
COMMIT
for SELECT ID,F_NAME FROM FOLDER where PRN_ID =:FOLDER_ID into :FID, :FNAME do
begin
EXECUTE PROCEDURE COPY_FOLDER( :FID, :NEW_ID);
end
end
END^
SET TERM ; ^[/ars]
DB de bulunan klasör yapısını kopyalamak için bir procedure yazmaya çalışıyorum fakat
Too many concurrent executions of the same request.
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At procedure 'COPY_FOLDER' line: 18, col: 5
At proce...
SQL Code: -693
IB Error Number: 335544663
Procedure çalıştırdığım zaman
hatası ile karşılaşıyorum.
Bilgisi olan varmı acaba ?