Since this is called from a TCL page and is not pulled into a
query file, should be change the Oracle data-model to use the same
sequence name? That is sp_session_id_sequence instead of
sp_session_id_seq.
Yup. The name that you choose for the oracle sequence should be
the same as the postgres view