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

Home -> Community -> Usenet -> c.d.o.server -> Re: passing IN parameter to stored procedure

Re: passing IN parameter to stored procedure

From: earl <earlcoombs_at_gmail.com>
Date: 15 Aug 2005 07:19:27 -0700
Message-ID: <1124115567.183402.77480@z14g2000cwz.googlegroups.com> 





Hi Jaap,


Thanks a lot - your solution:



"and instead of


USERS.USERNAME IN USER_GRPS



use


USER_GRPS LIKE '%'||USER.USERNAME||'<terminat­or>%' "



is exactly what I was looking for and a better solution than the one I
had written (parsing the USER_GRPS parameter).
You certainly are a courteous person and I appreciate your contribution
very much.


Thanks again,


Earl
Received on Mon Aug 15 2005 - 09:19:27 CDT












Original text of this message













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