Database Administration (MOSC)

MOSC Banner

What is the maximum length of sys_context('USERENV','HOST')

Hello,

i have to create a trigger which has to log client connections in a table.

So i am going to use sys_context('USERENV','HOST') for selecting client hostname.

Now i have to define a field for that in table. The fieldlength should be a real value.

So my question is : what's the defined length in sys_context('USERENV','HOST') by Oracle ?

Regards

Michael

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center