Re: Cannot DROP a ROLE
From: TC <donotuse_at_donotuse.com>
Date: Mon, 07 Apr 2003 16:38:09 GMT
Message-ID: <RPhka.395955$S_4.464063_at_rwcrnsc53>
Date: Mon, 07 Apr 2003 16:38:09 GMT
Message-ID: <RPhka.395955$S_4.464063_at_rwcrnsc53>
How many rows do you have in dual ?
select count(*) from dual;
Just a thought
//tc
"Ralf" <Miko_at_boehrer.de> wrote in message
news:fa624200.0304070429.26a87438_at_posting.google.com...
> Hi to all,
>
> I want to execute the following SQL-statement in SQL-Plus.
> "DROP ROLE AAA_ROLE;"
>
> But it doesn't work.
> I get the following error:
> "ORA-00604: error occurred at recursive SQL level 1"
> "ORA-01422: exact fetch returns more than requested number of rows"
>
> What did I make wrong ?
>
> Thanks in advance for any help or comment.
> Ralf
Received on Mon Apr 07 2003 - 18:38:09 CEST