Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. whatsinaname99

    Array as Out Parameter in Subprocedure- Urgent

    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?
  2. whatsinaname99

    Hash cluster vs Index Cluster

    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...
  3. whatsinaname99

    Hash cluster vs Index Cluster

    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...
  4. whatsinaname99

    Hash cluster vs Index Cluster

    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?
  5. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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...
  6. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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.
  7. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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...
  8. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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.
  9. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    Thank you! Much appreciated.
  10. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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!
  11. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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...
  12. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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...
  13. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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...
  14. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    That is, split between lines.
  15. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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.
  16. whatsinaname99

    Newbie Question- Wrapping Text in Procedure

    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...

Part and Inventory Search

Back
Top