Home » Open Source » Programming Interfaces » Using Arrays in PL/SQL Queries (Oracle 10g)
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

Previous Topic: PSP help
Next Topic: informatica 8.1.1
Goto Forum:
  


Current Time: Thu Mar 28 09:22:50 CDT 2024