Hello,
I created the following stored procedure:
create procedure P_DB_MOVE_RECORDS (
TOID integer)
as
declare variable STR_J char(4);
declare variable STMTXT varchar(300);
declare variable CHKPROZ integer;
begin
for select substring(ts from 1 for 4) as tsz from t_dt where lnr
How can I commit the DDL-Procedure that the oter find my table?
Hello,
I created the following stored procedure:
create procedure P_DB_MOVE_RECORDS (
TOID integer)
as
declare variable STR_J char(4);
declare variable STMTXT varchar(300);
declare variable CHKPROZ integer;
begin
for sele
> … How can I commit the DDL-Procedure that the oter find my table?
You can't COMMIT in PSQL. What you could try is to encapsulate your
stuff in an AUTONOMOUS TRANSACTION (available in Firebird 2.5), but I
haven't tried if this works in a scenario where you create a table and
insert into that t
Hello Thomas.
If I create a stored procedure with autonomous transaction, it works fine!
But if I call these stored procedure in a table-trigger, it works not. The
trigger probably uses only one transaction. But the trigger isn't the right
place for the stored procedure-code.
Is there a possibili
> If I create a stored procedure with autonomous transaction, it works fine!
> But if I call these stored procedure in a table-trigger, it works not. The
> trigger probably uses only one transaction. But the trigger isn't the right
> place for the stored procedure-code.
>
> Is there a possibility t
I create a stored procedure with autonomous transaction, it works fine!
> But if I call these stored procedure in a table-trigger, it works not. The
> trigger probably uses only one transaction. But the trigger isn't the
right
> place for the stored procedure-code.
>
> Is there a possibility to use