Greats! Daniel you are very smart...

Regards
Atte.
Ricardo Abufon Larach


-----Mensaje original-----
De: Daniel Ramirez Hernandez
[mailto:oracledba-ezmlmshield-x65060765.[Email address protected]
Enviado el: Miércoles, 31 de Octubre de 2007 10:29
Para: LazyDBA Discussion
Asunto: RE: PL/SQL Help


If you need show rhe sid via SQl*Plus write the next :

SELECT SID FROM V$SESSION

Is the same !

Regards to R.Abufon.


-----Mensaje original-----
De: Luis Cardenas
[mailto:oracledba-ezmlmshield-x33720660.[Email address protected]
Enviado el: Miércoles, 31 de Octubre de 2007 9:54
Para: LazyDBA Discussion
Asunto: PL/SQL Help


Anyone:

This bit of pl is not working:

BEGIN
FOR arec IN (SELECT SID, SERIAL# FROM V$SESSION)
LOOP
EXECUTE IMMEDIATE ''BEGIN dbms_output.put_line(arec.sid); END;'';
END LOOP;
END;



Can ne1 spot the reason please?

Thanks,
Luis

-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page