Search results for query: *

Using taupirho's query, I modified it to return the originally desired results. How would this need to be formatted to run as an Oracle stored procedure with the string of data to sort being passed in as a variable? select rtrim (xmlagg (xmlelement (e, x || '|')).extract ('//text()'), '|')...

CORRECTION! So with that in mind, the return result should be: 0-50020:FLATWARE_10PC|1-6055154:STORAGE_BOXES_RED|1-6055159:STORAGE_BOXES_BLUE|2-6055159:STORAGE_CUBE_BLUE

taupirho. Thank you! Here is the result of the query: 01-6055159:STORAGE_BOXES_BLUE|0-50020:FLATWARE_10PC|001-6055154:STORAGE_BOXES_RED|2-6055159:STORAGE_CUBE_BLUE Very close! I see it is placing the 01-6055159 before 0-50020. Let me make an update to the desired output that might help...

I've used this forum for many years, asked a few questions, gave a few answers. I've seen the rants people go on when someone doesn't search for an answer that is already out there... I get that. But hey, I'm just looking for help with an Oracle data parsing scenario. The data I have to work...

Thank you both for the feedback! taupirho - the core application is an older GUI interface similar to Eclipse but far less powerful. It is capable or running an Oracle stored procedure so I'm disecting your suggestion to perhahps make it fit my needs. SantaMufasa - thank you for the...

Correction: Max value for DESC is 4000 characters, not 64000

I've been looking for bits and pieces of code to help solve this problem - as I will continue to do but have had success getting and providing answers on this forum. I have a home grown application which has very poor/limited functionality outside of what it was made to do - but it can execute...

If you explain what you are trying to achieve perhaps somebody has a viable solution. If you want to give the agent more time to prepare, you could introduce a whisper that lasts for 6 seconds (one ring cycle, increase the duration to your liking). The caller will still hear whatever treatment...

Thank you! I should probably mention that nearly every bit of code I used in this script was learned on this forum.

I've used a lot of information from this site to help in my daily activities, so hopefully this post will be useful to somebody here. It is very nice to have when you can't remember what you changed in a crisis, and need to set things back. It is also nice to find certain keywords or numbers in...

I don't think this will work because the single line of text is greater than 255 characters. If you have any suggestions to work around that limitation I would be glad to hear them. Thanks!

kodr - if you can give me a hint of the code I would be most gracious!!! Thank you!

Hi all, I was wondering if somebody already had code that would read a single line of text from FILE-A, and add a line break after every 10th item (each separated by comma) and write this to FILE-B? I have an application that writes its output to a single line of text and need to format this...

Thanks for the example scripts. From your scripts here is what I came up with... and it works beautifully This script is a useful way for anybody with an Avaya S8700 to gracefully busy sequential members of a trunk group. proc main string trunk1 string member1 string member2 integer number1...

My user input boxes will not work for integers... Ouch!

Here is what I started with. I need help with the counter/looping part... proc main string trunk1 integer member1 integer number1 sdlginput "Trunk Group" "Trunk Group" trunk1 if failure goto stopnow endif sdlginput "First Member" "First Member" member1 if failure goto stopnow endif...

I am composing a script that will be used to busy multiple members of a trunk group on an Avaya Definity. The script will prompt for the trunk group number first, then it will prompt for the 1st member to busy. Finally it will prompt for the number of members to busy (sequentially). I am...

The 8410D phones on our S8700 system show a blank screen when idle. A "date-time" button had to be added so the time would show, but it only stays on the display for a couple of seconds. Any ideas?

I think our vendor is simply not interested in supporting this initiative because we are in talks with them to implement an entirely new messaging platform. I won't mention any names, but our vendor's name rhymes with "moss".

I currently use OMM for one of my Octel 250's in Arizona... but I manage 4 others that I would like to add to my Arizona OMM system. My vendor does not off a way to upgrade my OMM to support all 5 sites - does anybody have a contact that might be able to assist?