PS/SQL Procedure

From: Geoffrey <g.dufour_at_swing.be>
Date: Thu, 24 Jan 2002 16:46:51 +0100
Message-ID: <3c502b63$0$75157$ba620e4c_at_news.skynet.be>

Hi,

CREATE OR REPLACE PROCEDURE test IS

thesid NUMBER := 0;

BEGIN Select sid into thesid from v$session where program = 'blablabla' and status != 'KILLED'; END test;

Regards. Received on Thu Jan 24 2002 - 16:46:51 CET

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]