PS/SQL Procedure (Error)
Date: Mon, 28 Jan 2002 09:23:12 +0100
Message-ID: <3c550966$0$75153$ba620e4c_at_news.skynet.be>
Here is the error I get when compiling the procedure :
PROCEDURE Mydb.TEST
Do you have an idea ?
"Jens" <jens_at_faeustl.de> a écrit dans le message de news:
On line: 4
PLS-00201: identifier 'SYS.V_$SESSION' must be declared
> > Hi,
> >
> > Can you tell me why this script does not work ?
> >
> > (I have the right system privileges)
> >
> > =======================================================================
> >
> > 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;
> >
> > /
> >
> > quit;
> >
> > =======================================================================
> >
> > Regards.
> > Hi, > the procedure works fine. But if there is no hit, you get a no data > found exception. You have to catch it. The same if there is more than > one hit. > > JensReceived on Mon Jan 28 2002 - 09:23:12 CET