Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Roles are not granted in PL/SQL ???

Re: Roles are not granted in PL/SQL ???

From: Tomasz Gołebiowski <tgolebiowski_at_digest.com.pl>
Date: Wed, 03 Nov 1999 15:10:52 +0100
Message-ID: <3820426C.8D833FA9@digest.com.pl> 





Hi,



    The problem is that in your procedure your query returns more than
one row what isn't allowed.


I advice creating cursor and handling the result with loop.



Tomek

Received on Wed Nov 03 1999 - 08:10:52 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US