Re: passing IN parameter to stored procedure

From: amogh <amogh.r_at_gmail.com>
Date: Thu, 11 Aug 2005 11:50:34 +0530
Message-ID: <BlCKe.31$XF1.90@news.oracle.com>

DA Morgan wrote:
> earl wrote:
>

>> Hi Daniel,
>> Please take a look at my response to David Fitzjarrell where I posted
>> my complete SP
>> Earl

>
>
> And by watching you again post the same semantic error what conclusion
> would you like me to draw? That you looked at a solution that works for
> your syntax error and chose to ignore it?
>
> I'm leaving for Japan in 14 hours and will not revisit this thread:
> Ever! But rest assured, the above, is the thought you leave with me.
>
> Try the solution I gave you.

Earl,
Bottomline: Do not pass in multiple values through USER_GRPS. Pass them separately or pass in the values by picking them from a table directly, one after the other,or any other way suited to you, but not multiple values!

Regards,
Amogh

"A soft answer turneth away wrath; But a grievous word stirreth up anger." Received on Thu Aug 11 2005 - 01:20:34 CDT