Recent content by lecorr

Sample from one of my cron (oracle): 30 3 * * 0 (. /home/oracle/.profile; export ORACLE_SID=selrec;. /data/datafiles/backup/rman/scripts/backup_base.ksh tape full) 1>/dev/null 2>&1 It set the profile of Oracle, export a local value, executes the backup (with parameters) and redirects...

In fact, carp got it nearly. You just need: SELECT hostname, max(alert_date) alert_date FROM myTable GROUP BY hostname; Because you want the last date for each hostname. Note: Take care that a DATE in Oracle includes hours... If the code that inserts in your table doesn't do a...

You are talking about jobs (DBMS_JOB). Depending on version, job can (10g>) or cannot (<=9i) execute an external program (to spool in a file). If you use an stored proc, you will have to use something like utl_file to create and open a file and write in it... Millions of examples on google...

Try dbms_lob.getglentgh to get the length of the lob. If you use TOAD, it contains a tool to look at the content of lobs (I just used it in a project). Depending on the oracle version, you won't get the same functions and capacities for lob. The above function should work. Try connected as SYS...

Did you look to DBMS_CRYPTO.HASH_MD5? Follow this link to some reference to Crypto on Oracle: http://www.psoug.org/reference/dbms_crypto.html Hope that helps. Christian

Hello, I'd like to know if someone knows about a program that add a button to outlook to allow the user to save a mail (or group of mail) to a database (typically oracle). It would be good if the tools opens a window to ask for a reference so that we know where to save this in the database. If...

Hi, look at the Oracle8i forum, I just post the answer. (and without java...) Christian

Hi, I just post the answer to this on server side in the Oracle 8i Forum (under unix, you're lucky). For the client side, Oracle can not do that from the server. If you use FORMS, it can do it via the HOST command. Else, you can create a shared directory on the server so that your users can...

Hi, Sem gave me a good answer when I asked for this on this forum. He gave me the link to Ask Tom. I wrote a richer version which I give to you. How it works: You call a function HOST with the text of the command to run in shell. This command is sent in a PIPE by Oracle. It is received by a...

Hi, Thank you Sem for your help. It was a bit difficult to find the info. I put here the needed links: Without the use of Java: http://asktom.oracle.com/pls/ask/f?p=4950:8:10733669045321810496::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:16212348050, With Java...

Hi, I need to run an host command (EXP ...) from my PL SQL code. I heard about doing this through a java function. Does someone knows about this? Thanks.

Hi, Sorry, no other answer than it worked wit 9.0.xxx and 9.1.xxx but not with 9.2. So I migrate my daatbase from 7 to 9 and hopes it will work. Bye.

Hi, I can't access oracle 7.3.4 instances from enterprise manager 9.2. The error is that I need more privileges than the user has. I created the role SELECT_CATALOG_ROLE in SYS, but that changes nothing to the problem. Does someone has a way to make it work? This is VERY urgent. Thanks...

Thanks, I'll try that. Christian

Thank Dima, Could you please explicit the good syntax since my test (which looks like my sample code) did not work (PL compiler does seem to even understand it and finish with an ORA-01007 error)? The fact is I don't know what to put there: 'PROCEDURE TEST(C CURSOR!!!, others param..) IS'...