Recent content by jee

I am going to guess that you have a Pentium IV computer. There is a known bug associated with the Oracle install and Pentium IVs that has the symptom you describe. There are several work-arounds. See faq186-1124 in this forum for more information.

We saw this problem with an earlier version (somewhere around 8.0.5 or 8.1.6). If you had a task that kept repeatedly trying to connect to Oracle and failing (perhaps because of using a bad password or reaching the limit on the number of sessions or something), processes were created and never...

Just some random thoughts here... You mentioned the job_queue_processes parameter being set to 5. What about the job_queue_interval parameter (controls how often jobs are checked to see if any are due to run)? I suspect if this is set to zero, it never happens. I think it defaults to 60 seconds...

Well you just need to get the parameter into your spfile (or setup to use a pfile - you can still do that in Oracle 9). To update your spfile, you first export it to a flat file, then edit it to add the UTL_FILE_DIR parameter, then import it back. Instructions are in the Oracle Administrator's...

If what you want to do is search your procedures/triggers for references to certain tables and or columns (not sure I understand what you want)... If you happen to have access to the TOAD tool, you can search all procedures/functions/packages and/or triggers for specified strings - so you could...

No such view - options: 1) Usie auditing as suggested above. 2) Write a "Login" trigger to record logins to your own table. 3) Read/parse the listener.log file - only works if all database accesses going through SQL*NET/NET80.

Unfortunately what I told you was the full extent of my knowledge on the subject, as I have never written an external procedure. Here is a link to the manual I mentioned in my previous post: http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76939/toc.htm The information is in...

Sorry jad - I failed to notice the reference to 8.0.5 in your first message. You are correct - temporary tables first appeared sometime after 8.0.5 (a reason to upgrade??) As a suggestion for doing the thing with dynamic SQL... Try building something like this: SELECT COUNT (p.piece_id) FROM...

Sounds like what you want is what Oracle calls a temporary table. You set this up like any other table, only use this syntax: CREATE GLOBAL TEMPORARY TABLE current_inventory This creates a table that has the following characteristics: 1) Data stored is only accessible by the...

If you want the full user name as stored in Active Directory (first name, middle name/initial, last name) you will need to write an "External Procedure" (Procedure written in C or JAVA that is callable by PL/SQL code). You can read more about this in the Oracle Applcation Developer's...

The resulting number from date arithemtic is a number of days - so to convert to seconds, simply multiply by the number of seconds in a day, 86400.

Starting somewhere in Oracle 8i, the concept of "System Triggers" were introduced - and you can write a system logon trigger (has to be created by a DBA) - something like this: CREATE OR REPLACE TRIGGER logontrig AFTER LOGON ON DATABASE BEGIN INSERT INTO last_login (user_name...

Yes - you could write a batch file and do this. Quite simple actually: Put something like this in your file: rem Perform a full database export exp user/password parfile=dailyexport.fil You can fancy it up with error handling, etc. Then use the job scheduler to specify when the job...

I think you have two options: 1) You can turn on auditing and audit logons - then the data is in the audit trail. 2) You can write a trigger that fires on logon and store the date/time in your own table. I don't think the last logon date/time for a user is available anywhere else in Oracle

I am having a hard time seeing just what you are trying to do. It looks like you are setting a status flag in the same row(s) to two different values (same where clause for each), which is, of course, not possible. If there is a typo in your example and what you are wanting to do is set the...