GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
Windows and .NET
.NET Stored Procedures
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Sep 5, 2009 9:30 PM by 721043
Need help for Oracle Stored proc, Need to read multi values???? Urgent Thks
Sep 5, 2009 9:30 PM
Currently Being Moderated
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.
Track in Communications
- 10 points
- 5 points