PL/SQL (MOSC)

MOSC Banner

receiving an ora-3113 with NO more data to read from socket error

edited Jul 31, 2013 6:50AM in PL/SQL (MOSC) 4 commentsAnswered
we are receiving an ora-3113 while running the following sql   running 11.2.0.2 on Linux

 select sys_connect_by_path (a.value,'.') scbp_value 
    from oid_namespace_management a
    where der='2B0601040181E4380101020114822C06A70881D23C01'
    start with a.parent is null
    connect by prior a.id=a.parent

this was sent to me from one of the developers

I am unfamiliar with hierarchial queries

thanks in advance for any help

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