I have two ASA 12 databases. DB1 and DB2. A remote server connection using ODBC has been set up between DB2 to DB1 with read only set as false.
In DB1 I have created a function with twelve parameters.
I have added a new remote procedure to the remote server in DB2. When I look at the parameters for the remote procedure in DB2 I see nothing.
Have I missed something in the creation of the function in DB1, or something in creating the remote procedure in DB2?
Please show us the code of both...
Where/how do you "look" at these parameters?
The definition of both the local function in DB1 and the remote function in DB2 should be identical (though the name may be different), they need to have the same number (and usually the same types) of parameters.
The main difference is that the local function would have a compound statement whereas the remote (proxy) function will have an "AT clause" instead.
The same is true for stored procedures.
Note: There are some restrictions for the possibly data types of remote functions/procedures, as documented here.