this is php script, in php script i call stored procedure
------------------php script begin------------
$ibase_connection=ibase_connect($ibase_path,$ibase_login,$ibase_passw);
$transactions=ibase_trans(IBASE_NOWAIT+IBASE_CONSISTENCY);
$SQL_s1=ibase_query($transactions,"SELECT * FROM OBIAVLENIE_ADD_TMP_1('$key','$razdel','$rubrika','$podrubrika','$grupa','$grupa_new')");
ibase_commit($tr);
------------------php script end------------------
------------------stored procedure OBIAVLENIE_ADD_TMP_1 BEGIN--
INSERT INTO DOSKA_OBIAVLENIA_TMP (ID,RAZDEL_ID,RUBRIKA_ID,PODRUBRIKA_ID,GRUPA_ID,GRUPA_NEW,ACCESS)
VALUES (:ID,:RAZDEL,:RUBRIKA,😛ODRUBRIKA,:GRUPA,:GRUPA_NEW,'0');
SELECT FNAME,LNAME,PHONE,EMAIL
FROM MAIN_REGISTRATION WHERE ID=:ID INTO :FNAME,
:LNAME,
😛HONE,
:EMAIL;
------------------stored procedure OBIAVLENIE_ADD_TMP_1 END-----
after executing this procedure i get results, but in table
DOSKA_OBIAVLENIA_TMP i cannot see new insert with new value, why, ?
thanks for helping
