Using Arrays in PL/SQL Queries [message #282625] |
Thu, 22 November 2007 12:15 |
naveed010
Messages: 1 Registered: November 2007
|
Junior Member |
|
|
Hey, I'm using oracle PSP's and getting an array passed in.
I need to use that array to query a table. ie. the browser is passing in:
procName?arr=28-SEP-07&arr=05-OCT-07&arr=12-OCT-07
The receiving procedure is using owa_util.ident_arr as the IN type. I can loop through the array, but only want to execute the subsequent query once.
Any thoughts? Thanks!!
Patrick
[Updated on: Thu, 22 November 2007 12:35] Report message to a moderator
|
|
|