Home » SQL & PL/SQL » SQL & PL/SQL » Argument to stored procedure
Argument to stored procedure [message #7067] Mon, 19 May 2003 15:36 Go to next message
H Tagore
Messages: 5
Registered: May 2003
Junior Member
I have a sql like this in my procedure
select col1,col2 from table_name where product in (list_of_products). I want to pass list_of_products as an argument to the stored procedure. How can I pass multiple values. Can I pass arrays.
Please respond.
Thanks

Report message to a moderator

Re: Argument to stored procedure [message #7068 is a reply to message #7067] Mon, 19 May 2003 16:46 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Object types work great for this - I use this approach all the time.

Report message to a moderator

Re: Argument to stored procedure [message #7129 is a reply to message #7068] Thu, 22 May 2003 11:24 Go to previous message
H Tagore
Messages: 5
Registered: May 2003
Junior Member
Thanks for your help Todd. I was able to solve the problem with your solution. Thanks once again.

Report message to a moderator

Previous Topic: SMTP error
Next Topic: Query about SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 04:01:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.