Jul 24 2007, 11:19 AM
I'm attempting to setup up a streams environment to send data from one table to a custom DML handler. That custom DML handler strips apart the LCR and passes the data required to another procedure. I'm running into an issue in that when the procedure is called it apparently has no user context. It inserts pieces of the LCR into various tables and massages the data then inserts, however when user is called it returns a null value. Is this expected behavior and if so is there a way to set the user context. I'm running on 126.96.36.199 and at this time cannot upgrade to 10. I have Madhu's book but in his custom DML handler example does not address this issue.