Search results for query: *

Hi, Is it possible to start a trace without having the alter session privilege? We have a user that we have set-up to monitor DB activities for all users but we dont want to grant alter session privilege to it but we do want to allow the user to start/stop traces. We granted DBMS_MONITOR and...

Hi, I have a query that returns the last 3 salaries of employees but I want to display the results in 1 row as Sal1, Sal2, Sal3. Anybody know how to do this? My query is: select b.REFNO, s.SA02D, s.SA04P from basic b, salary_history s where b.BGROUP = s.BGROUP and b.REFNO = s.REFNO and s.SA02D...

Hi, I have a home PC that the CPU is running at 100% as soon as I login. The process that is causing the problem is a wmiprvse.exe process. I know that this is a windows management process and can also be a virus. I have checked the registry for entries (if it is a virus there are supposed...

Hi, I can run a vb process from the command line o the server and it runs fine. when I call it from my application it fails half way. I use commands like this to view results when I run from command line Wscript.echo "Command = Did I get here " but when I run from the application it runs in...

Hi, Not sure if this is the correct forum for this but . . . I can run a .bat on server if I run it from the command line on the server and it works fine. If I run it from my application it fails halfway through (I cannot see wht it fails as it runs in the background). I s there a command...

Hi, I have an LOV using a record group that I am trying to use as to validate against a supplier ID or a supplier name. I have over 40,000 records. It was returning in about 2 seconds when I had only validate against ID. Now my first column uses concatenation for 3 columns. The query takes...

Hi, I can create a 2 dimension array. I tried to create an n dimension array. Is this possible? I did not get an error on creation but got an error when I tried to assign a value. Here is what I tried: type v_admin_type_record is record(v_index number...

Hi, I am using Tab Canvas in forms 6.0. I have 2 tabs which are based on one block. If I am in tab2 and click enter query, the cursor jumps back to the first item on tab1. How can I force the cursor to stay on the item it is on. Thanks, daniel.

Hi, I have a script that adds a file type. My problem is that it only adds for each user. How can I run this once and it will be available for each user that uses the PC? Code I use is copied below. Any help will be much appreciated. Daniel. I have a .bat that contains this: assoc...

Hi, Is it possible to change cursor style in forms6i. I have users that are used to looking at a chunky cursor. Is this possible to change? Thanks, daniel.

Hi all, What is the easiest way to copy the contents of an excel sheet into a table. i am using forms 6i. Thanks, daniel.

Hi, I have a web page that I paste an excel sheet into a text area. When I click on save it calls an a program unit that uploads values into database. My problem is that if the number of characters is over 32,000 I get an error. This is a http limitation that variables cannot be over 32000...

Hi, I have a web page that I paste an excel sheet into a text area. When I click on save it uploads these values into the database. My problem is that if the number of characters is over 32,000 I get an error. This is a http limitation that variables cannot be over 32000 characters. Any ideas...

Hi, I have a script that adds a file type into the registry. my problem is that it needs to be run for each user that logs into the PC. Is it just as simple as an Admin user or is there another setting in the registry I need to set up. Thanks in advance for any help. daniel. Here is...

Hi, I have a form updating a view. All works OK until I add in a column from the view that is based on a function. I have the properties set on the field Enabled=NO keyboard navigable=NO update allowed=NO insert allowed=NO But I still get "ORA-01733: virtual column not allowed here" when I...

Hi, This is the code that is generated when I re-call. The value in the text area has been pasted from an excel sheet in the first form. I get an unterminated string constant error from the browser. Is there a way around this? Thanks, Daniel. <SCRIPT>document.insert.i_part_desc.value = "Part1...

Hi, I have a web page that I paste an excel sheet into a text area. When I click on save it uploads these values into teh database. My problem is that if the number of characters is over 32,500(around this figure, probably 37,760) the page fails. Is this because the most a value can hold 32,760...

<option value="57742">57742 12D SOLUTIONS PTY LTD</option> Hi, Why does this not show spaces between the 57742 and the 12D? Thanks, Daniel.

Hi, I have just received an excel file and I need to use the TRIM function on an entire column. I seem to be able to get it to work for a cell but not entire column. I know it's prob easy but I am new to this. Thanks in advance, Daniel.

Hi, I have the url below. This is being called from the function below it. Why does it not put the value of bu_id into the url. I have tried all ways with the plus sign. http://intranet.lc.local:8000/webdev/test_xaps.load_cat?i_action=insert&i_bu_id='+bu_id' <SCRIPT>function...