How To Pass Oracle Procedure Value using Tidal Oracle Database Job Definition to Tidal Variable
how do i pass the parameter value from an oracle database tidal job to a tidal variable? for example i have this oracle db job that is defined to execute an oracle database procedure and i need to pass the parameter value to the tidal variable.
begin procedure_get_user_info(<OracleUserVariable.1>); end;
hi i'm not sure how to use the "tesmcmd varset" command. i guess if that command will be use in a predecessor job it will not work. because the value that the tidal variable needs will come from the oracle procedure. the oracle procedure needs to execute first and pass the value to the tidal variable.