Date: Thu, 28 Mar 2024 23:36:36 +0100 (CET) Message-ID: <928133479.111308.1711665396394@srvdoc.doc.ipesoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_111307_2053477574.1711665396394" ------=_Part_111307_2053477574.1711665396394 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Prenos handle na datab=C3=A1zov=C3=A9 spojenie medzi ESL skriptami je za= bezpe=C4=8Den=C3=BD pomocou RPC proced=C3=BAr. V deklar=C3=A1cii RPC proced= =C3=BAry je potrebn=C3=A9 ozna=C4=8Di=C5=A5 parameter reprezentuj=C3=BAci h= andle na datab=C3=A1zov=C3=A9 spojenie, vymenovan=C3=BDm typom DB_HANDLE= . Algoritmus je podmienen=C3=BD existenciou datab=C3=A1zov=C3=A9ho spoj= enia. Ak handle na datab=C3=A1zov=C3=A9 spojenie je neplatn=C3=A1 hodnota a= lebo ukazuje na neexistuj=C3=BAce datab=C3=A1zov=C3=A9 spojenie, algoritmus= skon=C4=8D=C3=AD s chybou.
Vymenovan=C3=BD typ DB_HANDLE je typu INT.
Deklar=C3=A1cia RPC proced=C3=BAry:
RPC PROCEDURE ProcName [([I= N] DB_HANDLE _db_handle[,_db_handle2, ...] [IN] DB_HANDLE _db_handle3]...)= ]=20 ;akcie =20 END ProcName
_db_handle, ktor=C3=A9 sa m=C3=B4=C5=BEe pren=C3=A1=C5=A1a=C5=A5 = medzi ESL skriptami vznik=C3=A1 akciami: DB_CONNECT, PG_DISC= ONNECT, SQL_CONNECT, DB_TRANS_OPEN.
Pozn=C3=A1mky:
INT _db_handle =20 _db_handle :=3D 5 =20 CALL [objIdent] INSERT (_db_handle) ON procIdent
****************** =20 ; volan=C3=BD ESL skript RPC PROCEDURE InsertToDB(DB_HANDLE _handle) ..... END InsertToDB =20 *************** =20 =20 ; volaj=C3=BAci ESL skript INT _db_handle =20 CALL[...] InsertToDB(_db_handle) ASYNC ON .... ; Po takomto volan=C3=AD, handle na datab=C3=A1zov=C3=A9 spojenie v tomto = skripte zanik=C3=A1, vlastn=C3=ADkom sa st=C3=A1va volan=C3=BD ESL skript =20 *****************
****************** ; volan=C3=BD ESL skript RPC PROCEDURE InsertToDB(IN DB_HANDLE _handle) ..... END InsertToDB *************** =20 ; volaj=C3=BAci ESL skript INT _db_handle =20 CALL[...] InsertToDB(_db_handle) ON .... ; po takomto volan=C3=AD datab=C3=A1zov=C3=A9 spojenie v tomto skripte za= nik=C3=A1, vlastn=C3=ADkom sa st=C3=A1va volan=C3=BD ESL skript ***************
****************** ; volan=C3=BD ESL skript RPC PROCEDURE InsertToDB(DB_HANDLE _handle) ..... END InsertToDB *************** =20 =20 ; volaj=C3=BAci ESL skript INT _db_handle =20 CALL[...] InsertToDB(_db_handle) SYNC ON .... ; po takomto volan=C3=AD, vlastn=C3=ADkom datab=C3=A1zov=C3=A9ho spojenia = ost=C3=A1va volaj=C3=BAci ESL skript ***************
S=C3=BAvisiace str=C3=A1nky: