I need to audit the IP addresses of APEX Connections inside the database

Hi there,

I'm trying to capture the ip addresses of queries from APEX 4.0.2.

I've got Fine Grain Auditing on which is great for capturing the actual queries from APEX which is part of what we need here and that's working fine.

However we need to also match these queries up to a physical user or PC that made the call to the database. We can use the ip address of a PC as PC addresses are static to a PC in this organisation.

I created an after logon trigger to the database which does an insert into an audit table with the following: