• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Devaka Cooray
Saloon Keepers:
  • Ganesh Patekar
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
Bartenders:
  • Ron McLeod
  • Frits Walraven
  • Pete Letkeman

oracle store procedure taking a list of values at run time ?  RSS feed

 
Ranch Hand
Posts: 375
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Want to use oracle store procedure, one of the input is a list. The list can have different number of elements at run time. is it possible to pass such a list to a store procedure ? for example, if I want to the following --

select * from ... where ... AND
id IN ('11', '12','13','14');

this is static, I want to pass a list of "id" to the store procedure at run time, don't know how I can write store procedure for this case ?

 
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
your stored procedure would need to except a string/varchar as a variable. Your list would be passed as a single string variable. You will need to parse the string to utilize your list.

Here is an example from Tom Kyte's Oracle Page
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!