KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Is it possible to use SELECT FROM when using an associative array? I'm passing an array to a stored procedure through a .NET application, and I wanna be able to use that array as a condition when selecting from another table. Lets say I'm passing an array of IDs to the procedure, I wanna be able to do this: select * from table1 where userID in (select column_value from array) The type for the array is defined in the package: type id_array is type of number index by pls_integer
Tags (comma-separated)
Save Edits
Cancel