I know what the issue is: when I run *oci_set_client_identifier* ( resource $connection , string $client_identifier ), it creates another connection, now the original one from Doctrine connection object. how do I get the oci8 connection resource out from the Doctrine connection:
On Tuesday, 23 April 2019 16:01:54 UTC-4, [email protected] wrote: > > in a API project I am working on, we need to pass the login user info ( > user name) to the backend Oracle sys_context for auditing purpose, > basically like this: > php: oci_set_client_identifier > > // Find the application user's login name > session_start(); > $un = my_validate_session($_SESSION['username']); > $c = oci_connect('myschema', 'welcome', 'localhost/XE'); > > // Tell Oracle who that user is > oci_set_client_identifier($c, $un); > > // The next round-trip to the database will piggyback the identifier > $s = oci_parse($c, 'select mydata from mytable'); > oci_execute($s); > > > how do we do this in Doctrine? any suggestions? > > > Thanks! > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
