This content has been marked as final. Show 4 replies
I know the correction but I need to know why now the client did had this error,
SELECT DISTINCT SID INTO My_sid FROM V$SESSION WHERE sid = ( select sid from v$mystat where rownum=1 );
You realise that this is much simpler:
select sid into My_Sid from v$mystat where rownum=1
we used this query to get also program and other information about this session.