02-11-2009
Quote:
Originally Posted by
Revo
Hmm, interesting, I wonder if that is something to do with the way oracle is assigning the variable $week_end_dt
As an aside, what unix are you running? and what version of oracle?
Thanks for letting us know you've got it sorted
Hi Revo,
No. It is nothing do with how the oracle assigns the value to the variable. The thing which i got to learn is that you cannot pass a variable directly into the subject of the mail. On the contrary if you pass the variable as an executable command then it works properly as in this case.
I am using Linux and Oracle 9i.
Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
i have seen the following line in some unix shell script .
can some one explain me what exactly the statement is meant for ?
=========================================================
mailx -s " Master Data Transmission Report for $TODAY at $TIME " < /etc/tr/tmp/$tmplog... (5 Replies)
Discussion started by: sveera
5 Replies
2. UNIX for Advanced & Expert Users
Hi,
mailx -s "hi" -r "abc@yahoo.com" aaa@yahoo.com<<EOF
Hi,
~<!uuencode a.txt a.txt
EOF
the above code is sending mails, but attachment is not going instead i just get like below
~<!uuencode a.txt a.txt
Thanks. (3 Replies)
Discussion started by: shahnazurs
3 Replies
3. Shell Programming and Scripting
Dear All,
I need to send a mail to a group ( the address of which is in a .profile file)..My basic mailing functionality isn't working. When i try to run
mailx -s "Hello" abc@xyz.com the command does not return to the prompt an runs infinitely.
Request you to help me out here along with... (3 Replies)
Discussion started by: kaushikraman
3 Replies
4. UNIX for Dummies Questions & Answers
hi,
i want to pass a unix variable as the subject of the mail alongwith a string. My part of code is as below..
week_end_dt=`sqlplus -s rsamart@martdev.world/rsamart<<EOF
SET FEED OFF;
SET TIMING OFF;
SET HEADING OFF;
SET PAGESIZE 500;
SET LINESIZE 1000;
select... (1 Reply)
Discussion started by: Jalkukdi@10
1 Replies
5. UNIX for Dummies Questions & Answers
How does the -s command work with mailx. I know that -s is to create a symbolic link when being used with ln but i'm not sure what the command does with mailx.
Anyone?:confused: (1 Reply)
Discussion started by: kjetterman
1 Replies
6. Shell Programming and Scripting
Hi All,
Can anyone please provide the command for sending an mail with attachment using mailx command.
Thanks in Advance :)
Regards,
Siram. (3 Replies)
Discussion started by: Sriram.Vedula53
3 Replies
7. Solaris
HI All,
I have an unix server , where sendmail command works for sending mail.
But if i use mailx command it is not working.
Is there any specific settings needed for this.
Kindly help.
Thanks and Regards
Rj (1 Reply)
Discussion started by: jegaraman
1 Replies
8. Solaris
Dear all,
Every time if i use mailx it is asking for entering the From Address.
I want to set it in some place, So that it will take it by default whenever we send mails.
Pl help on this.
Regards
JeganR (2 Replies)
Discussion started by: jegaraman
2 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I am seeing that this command is sending mail even when the nawk command in untrue ( does not have any output ). I only want it to send mail, where it goes above the threshold, and has some output.
nawk -F'(MOD dn="uid=)|(DEL dn="uid=)|' '/(MOD dn="uid=)|(DEL dn="uid=)/... (2 Replies)
Discussion started by: john_prince
2 Replies
10. Red Hat
Using RHEL 5.5
New to using 'mailx'
Was trying to check if mailx is configured.
mailx command gives a list of unread mails.
Now I tried to send mail using this command to a local or on network machine using
mailx -s "Test2" "root@<servername>"
But did not receive any message. (6 Replies)
Discussion started by: ikn3
6 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::oracle
DBIx::SearchBuilder::Handle::Oracle(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::Oracle(3pm)
NAME
DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
Connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
BuildDSN
Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.
Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host
defined or not:
dbi:Oracle:sid=<SID>;host=...[;port=...]
dbi:Oracle:<SID>
Read details in documentation for DBD::Oracle module.
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
InsertFromSelect
Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.
Unlike other DBs Oracle needs:
o id generated from sequences for every new record.
o query wrapping in parens.
NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
following query would generate "ORA-00918: column ambiguously defined" error:
SELECT g.id, u.id FROM ...
Solve with aliases:
SELECT g.id AS group_id, u.id AS user_id FROM ...
KnowsBLOBs
Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs
for inserts.
BLOBParams FIELD_NAME FIELD_TYPE
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
DistinctQuery STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
BinarySafeBLOBs
Return undef, as Oracle doesn't support binary-safe CLOBS
DatabaseVersion
Returns value of ORA_OCI constant, see "Constants" in DBI.
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT tzname FROM v$timezone_names;
Read Oracle's docs about timezone files:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
perl(1), DBIx::SearchBuilder
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)