Thank you so much for your help. I was trying to pass 'yesterday's date' from unix thru a cron to a package. I took Guy's advise and created a procedure to call this pkg. It was easy and quick.
Thank you again. -----Original Message----- Sent: Friday, November 09, 2001 11:51 AM To: Multiple recipients of list ORACLE-L I'm sorry, I misunderstood. Were you trying to get Oracle to tell Unix what yesterday was? #!/bin/ksh sqlplus << EOF system/incredibly_secret_password_but_this_is_probably_overkill_why_not_use_ scott_tiger select 'YESTERDAY="||sysdate-1||'"' from dual set pages 0 set sqlprompt "" spool date_def / spool off exit EOF . ./date_def echo "Yesterday was $YESTERDAY" -----Original Message----- Sent: Friday, November 09, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Thank you so much for response to my email. I know we can do: Date= `date` but not `date -1`. -----Original Message----- Sent: Friday, November 09, 2001 11:14 AM To: Multiple recipients of list ORACLE-L So long as you embed your call to Oracle within your program, the program can pass variables to Oracle all day long. #!/bin/ksh DATE=`date - 1` DBA=`Anne Yu` sqlplus << EOF system/incredibly_secret_password select $DATE,$DBA from dual; exit EOF echo "Done!" -----Original Message----- Sent: Friday, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).