Search results for query: *

I have created a procedure that returns data in a Pl\SQL collection. What would the syntax be for calling a procedure that has an out parameter that is an associative array and accessing the data in teh collection that the procedure returns?

Thanks for your feedback. Though I'm new, I'm not that new. I'm not doing this in a hapazard way, though, but studying things by topic. Right now, the topic of the day is tables; I want to understand them in-depth. Of course, the level of depth is subjective. I doubt I'll go as low, say, as the...

Thank you very much for your response. You explained this in a way I could understand. Thank you for your gentle reminder. This question was not related to an immediate problem I was having. I'm sorry, but I didn't realize that the site was directed more towards real-world problems. My...

What is the difference between a hash cluster and an index/b-tree cluster such that the hash cluster is to be preferred when running "equality" queries and the index/b-tree is to be preferred when searching a range of values?

Thanks for filling Tharg in, Santa. To update you on what happened today, I should first say that the problem was a little more complicated than I'd outlined. There was more than one subprocedure to be called and some subprocedures took as paramaters the OUT variables of previous procedures. I...

I've officially thanked T (sorry, didn't understand the jargon of this site). BTW, I am indeed a Badger and the weather here is quite dangerous.

I'm sorry! I didn't mean to be disingenuous. I am in the US and am indeed under pressure. I was to have this done today at the latest but, along with my coworkers, had to leave the office due to inclement weather (snowstorm in Midwest). What would ordinarily be time off is now being spent...

I have yet to try this. I am at home and researching the problem but will be back in the office tomorrow to execute. I'll let you know how I fare. Thank you! I do appreciate your help.

Thank you! Much appreciated.

What if I wanted to do it within the context of an Oracle stored procedure? Is there any data structure that could handle 30K values? Thanks again!

I need to execute a stored procedure for 30K employees. I've been given a list of employee IDs which uniquely identify each employee. Now, it would have been easy if I had a sql statement that contained the employee IDs. Then, I'd just create a cursor and loop through it, passing each employee...

Sure. And thank you in advance for help. I have been given a list of 30,000+ employee IDs. For each of these employees, I need to execute a stored procedure that accepts the employee ID as one of several parameters. I don't have access to change the stored procedure. I also don't have access to...

Also, this is just a one-time data update. It's not going to be saved in the database as a stored procedure for future use. I know it's inefficient but I don't have access to a sql statement, only a list of primary key values. There are 30000 + values in my array, so I've split the update...

That is, split between lines.

The environment may be a red herring, but I'm certain that my values aren't being returned as expected because they are being written out to the buffer. It only seems to work if I adjust each line in toad so that the values are not split by lines.

I am using TYPE to build a varchar array of about 5000 items (unfortunately I'm not able to use a SQL statement). The problem is that that when I execute the procedure in TOAD, it doesn't return the values I'd expect when I loop through the array. For example, if the number '6789' is part of the...