Search results for query: *

Hi, I installed XE this morn and did this on my PC to test and it works on my PC. Here’s what I did: Logged in as system: CREATE USER dan IDENTIFIED BY dan DEFAULT TABLESPACE USERS; grant connect, resource to dan; Logged in as sys: GRANT EXECUTE ON dbms_monitor to dan; Logged in as dan: EXECUTE...

Hi Karluk, This is the comamnd I used: EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(527,2, TRUE, TRUE); The command executed(Returning PL/SQL procedure successfully completed) so I was expecting the trace to start but there was no file produced. I checked DBA_ENABLED_TRACES but there was no entry...

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

Thanks, Sorry about replying so late. I've been away on a long weekend with the family. Daniel.

Hi Dave, This is great. I have read the analytic functions and this is going to be make my life so much easier. I have to support report requests by the business on a daily business and this can be applied in a lot of the cases. I have never came across "partition by" before. I should have...

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 took the easy way out of this. I went into msconfig and disabled the service Windows Management Instrumentation. can anyone let me know if this will affect anything else on the PC. It all looked to be running fine last night. Thanks, Daniel.

Will check firewall. What puts me off is that there is no network traffic. I am not even using any software. It just starts after I login. The firewall being used is Mcafee. I will try to stop Mcafee starting on startup and see if that works. If that is the case then I have another problem - no...

Hi, Thanks for reply. I will try these as soon as I get home. I have tried it as different users and the result is the same. The process that does start is a Newtwork Service. Don't know if this gives you any clues as to the origin of the starting program? Thanks again, Daniel.

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, sorry but I do not know much about vbscripts. I use oracle forms to call my vbscript. It uses a host command to kick off the vbscript. I have been asked to change someone elses script, basically add extra parameters but when I add any parameters it fails. If I add in a Wscript.echo...

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, Thanks for reply. One of the standards that I have to stick to is all LOV's have to be validated from the list. For now I have changed my LOV so that it reads like this: select supplier_id, supplier_name . . . But this only allows the user to search by supplier_id using text_field. This...

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

Found problem here but now have another 1st problem was v_admin_index_table.v_index(1) := 1; should have been v_admin_index_table(1).v_index := 1; Is it possible to define these tables within an oracle forms session so that all program units would have access to it. Thanks, Daniel.

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

Thanks for info. Daniel.

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.

Thanks, will try that. Daniel.