0 Replies Latest reply on Sep 6, 2009 4:30 AM by 721043

    Need help for Oracle Stored proc, Need to read multi values???? Urgent Thks


      I have to write a stored proc and I am new to it.

      The requirement is:

      1. There is a user table with userid as PK

      2. For each userid we have a role table with role id.

      One userid can have mutiple roles (role id).

      I have to return a comma separated values of roles for each userid along with user details.
      Pls suggest some better way?

      Thnks for all your help.

      With Regrds