This SQL function adds the SQL statement to the log of the publication. The statement will typically be a procedure call but can be any SQL statement. There can be a parameters, which are bound to ?'s in the statement's text from left to right. There is no restriction on the number of parameters.
The parameters are input only since the actual call will take place on a remote server at an unknown future time.
Suppose on subscriber side we have a table 'foo' with two columns (integer and varchar). This statement will send a replication message to the subscribers to insert a row into the table 'foo'.
SQL> repl_text ('demo-publication', 'insert into foo values (?, ?)', 1, 'this is a test');