SQL & PL/SQL :: Unable To Use UTL_MAIL

Apr 2, 2010

i used UTL_SMTP to send email. it works fine and send email. but when i used UTL_MAIL, its throwing below error

Error at line 1
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 20
ORA-06512: at "SYS.UTL_SMTP", line 96
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "SYS.UTL_MAIL", line 395
ORA-06512: at "SYS.UTL_MAIL", line 608
ORA-06512: at line 2;

i ran below

begin
utl_mail.send('abc.def@xyz.com',
'abc.def@xyz.com','Testing UTL_MAIL Option','blah blah blah');
end;

if utl_smtp is working, means SMTP server is configured properly. then why am i not able to get email using UTL_MAIL ?

utl_mail hav public grant.

also i smtp_out_server has value in v$parameter :

select * from v$parameter where name = 'smtp_out_server';

View 7 Replies


ADVERTISEMENT

SQL & PL/SQL :: Formatting In Utl_mail Output

May 26, 2012

Formatting the mail message sent using utl_mail, i have created one table and it has around 17 rows inside as sample and it may increase as well, my present email format is like very distorted and i have to have it as readable in single line .Please find below the code i have written along with test case, you may substitute your emailid and test, especially my main focus is on the lable aff.mark number where all the mark numbers are distorted and want to be arranged in line.I have attached the email format that i am getting at present also.


CREATE TABLE FAB_LOG ( MRK VARCHAR2(30))
INSERT ALL
INTO FAB_LOG VALUES ('1018017M-6001')
INTO FAB_LOG VALUES ('1018017M-6002')
INTO FAB_LOG VALUES ('1018017M-6003')
INTO FAB_LOG VALUES ('1018017M-6004')
[code]......

View 7 Replies View Related

Server Administration :: Setting Up UTL_MAIL

Apr 9, 2013

Using UTL_MAIL package.

My server version is:- 10.2.0.3.0
Here is the INIT Parameter file.

My question is, how it will affect if I configure the UTL_MAIL package by executing the Scripts ("utlmail.sql" and "prvtmail.plb")? And setting the Parameter SMTP_OUT_SERVER=''?

View 8 Replies View Related

PL/SQL :: Error While Running UTL_MAIL Package

Aug 8, 2012

SQL> conn system/sys@ORCL;
Connected.
SQL> @F:oracleproduct10.2.0client_5RDBMSADMINutlmail.sql

Package created.
Synonym created.

SQL> @F:oracleproduct10.2.0client_5RDBMSADMINprvtmail.plb

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY UTL_MAIL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
319/5 PL/SQL: SQL Statement ignored
320/10 PL/SQL: ORA-00942: table or view does not exist
325/7 PL/SQL: SQL Statement ignored
326/12 PL/SQL: ORA-00942: table or view does not exist

View 2 Replies View Related

SQL & PL/SQL :: Send Emails From Oracle Using Both UTL_MAIL As Well As UTL_SMTP

Oct 9, 2013

I developed a program to send e-mails from Oracle using both UTL_MAIL as well as UTL_SMTP. My requirement now is to send around 75,000 emails per day, When I tested for 1000 emails it is taking around 6 mins., Then for 75,000 it would be around 7-8 hours. Not to put the server busy for these many hours. Can we really send this much of e-mails from Oracle? UTL_MAIL is little faster than UTL_SMTP)

View 12 Replies View Related

SQL & PL/SQL :: How To Manage Rule Link With Utl_mail Package

Aug 3, 2011

I have 2 questions :

1. How many oracle mechanism can link with oracle send mail mechanism ??
2. Any samples which the oracle send mail mechanism to run with some oracle alert mechanism.

View 3 Replies View Related

SQL & PL/SQL :: Send Email Attachment Using Utl_mail.send_raw Utility And Not Successful

Jun 6, 2011

I am trying to send an email attachment using "utl_mail.send_raw" utility and not successful. Constantly I keep getting an error:

"ORA-20001: An error has occured: ORA-20001: ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "APPOWNER.SANDEEP_CT_FILE", line 103"

I think it's emanating from "ORA-06508: PL/SQL: could not find program unit being called".

a) this morning my production dba " utlmail.sql in DEVELOPMENT as sys.

b) Create or replace directory TEMP_SANDEEP as '/u01/data' (This was created so that BFILENAME could read it + "dbms_lob.fileopen" needs to access this from Oracle directory and not Operating system directory)

c) 'u01/data' exists on Unix development box.

d) Then I created the following procedure to create a text file (text file's name is currentdate.txt i.e. 06062011.txt) that has some information. Once created, the UTL_MAIL.SEND_RAW should pick this file up and email this to concerned parties(and in this case it's me as I am doing this on development environment).

Code for the above is as follows:

CREATE OR REPLACE procedure sandeep_ct_file is
/*Variable declarations */
v_dir_location varchar2(100);
v_file_name varchar2(100);
v_file_handle UTL_FILE.FILE_TYPE;
v_report LONG := chr(10)||'Prog Code' ||' '||
[code]....

Do I have to defined SMTP connections and parameters?

View 10 Replies View Related

Unable To Upgrade From 9i To 10g?

Oct 31, 2010

I'm attempting to upgrade a 9.2.0.7 to 10.2.0.? (haven't run the patch set yet so it's at 10.2.0.1) I'm not sure if the listener is correct to proceed.

The platform is Windows x323 (server 2003)

>>I'm not an Oracle DBA, I stumble thru it in administering PTC's Windchill vault..

I am trying to run the Oracle DBUA and the documentation for the Upgrade Assistant instructs me to install in an OraHome that is separate from the existing. Done.

The Upgrading Guide then States:
"Run the Oracle Net Configuration Assistant
If you are upgrading from Oracle9i and a listener was not configured in the Oracle9i repository, run Oracle Net Configuration Assistant to configure the listening protocol address and service information for the new Oracle Database 10g database, including a listener.ora file. A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."

Oracle Net Services Administration Guide, �10 states:

"Note:

A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."

Here's what I've got: The Installation using the Universal installer for 10g ran w/o complaint, reported success. The installation type was Advanced>Custom per the PTC Windchill documentation. After the initial installation, the Oracle Net Configuration Assistant did not start automatically, as the documentation stated it would. (The documentation from PTC on Oracle is skimpy at best)

I launched the Network Config Assistant from the start menu in the new OraHome10g. When I tried to create the listener, TCP on port 1521, it told me this was already in use by another program. I could configure it, but until the conflict was resolved....

When I open the Net Manager, the path in the header bar of the frame is to OraHome92\network\Admin....YET, when I run HELP>About in the Net Manager it reports "Oracle Net Manager; Version 10.2.0.0.0 Production"

I had stopped all Oracle services when I ran the UI to install 10g. I have also since removed the service for the 9i TNSListener from windoze register (and restarted). Right now, there is no that shows running in Services.

??Am I actually OK to go ahead w/ the patch set, then run the Pre-Upgrade Information Tool then the Oracle DBUA?

Do I actually have a 10g listener setup?

But, the listener.ora, tnsnames.ora etc are all in the OraHom92/network/admin folder and nothing but the samples show in the OraHome10g/network/admin. Will the DBUA migrate these or should I manually transplant them into the OraHome10g directory?

View 1 Replies View Related

Unable To Mount The DB?

Jan 15, 2013

i am not able to mount my database created today. I uninstalled the RDBS software and all peoplesoft database content to start from a fresh again. But now i am not able to mount my DB. I am working on 11g. The error is -

SQL> startup
ORACLE instance started.
Total System Global Area 744910848 bytes
Fixed Size 1374696 bytes
Variable Size 226493976 bytes
Database Buffers 511705088 bytes
Redo Buffers 5337088 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 2192
Session ID: 5 Serial number: 1
SQL>

View 11 Replies View Related

Unable To Connect DB From LAN PC?

Mar 12, 2013

I hv no problem connecting oracle at localhost. but when connecting using another pc on the same LAN, the sqldeveloper returned an error saying

IO Error: The Network Adapter could not establish the connection on the linux where oracle installed, iptables is disable, but firewalld is enabled, so I did a

'firewall-cmd permanent zone=home --add-port=1521/tcp'

yet the remote pc still prompt the same IO error. what should I do to have oracle accept connection from the LAN and WAN ( I hv setup virtual server on router)

View 12 Replies View Related

Unable To Bind - OLD And NEW

Mar 18, 2009

Whenever I try to create this trigger, it asks for values for :OLD and :NEW for some reason, and then when I attempt to put those in, it just says

Unable to bind ":OLD"
Unable to bind ":NEW"

CREATE OR REPLACE TRIGGER audit_grade_change
BEFORE UPDATE OF final_letter_grade ON enrollments
FOR EACH ROW
BEGIN
UPDATE grade_change_history SET old_final_grade=:old.final_letter_grade, new_final_grade=:new.final_letter_grade;
end;

am I using :OLD and :NEW incorrectly?

View 1 Replies View Related

SQL & PL/SQL :: Unable To Generate A Fk

Mar 1, 2011

I am unable to generate a fk in the following script..

DROP TABLE PD1 ;
CREATE TABLE PD1 (APP_CODE NUMBER,APP_DTLS VARCHAR2(10),
CONSTRAINT APP_CODE_PK PRIMARY KEY (APP_CODE)
);
DROP TABLE PD2 ;

CREATE TABLE PD2 (LAND_CODE NUMBER,PVT_LAND VARCHAR2(10),
GOV_LAND VARCHAR2(10),OWND_LAND VARCHAR2(10),LEASED_LAND VARCHAR2(10),
CONSTRAINT LAND_CODE_PK PRIMARY KEY (LAND_CODE)--,
-- CONSTRAINT APP_CODE_FK FOREIGN KEY (APP_CODE) REFERENCES PD1(APP_CODE)
[code]....

View 2 Replies View Related

Unable To Find A Table?

Mar 22, 2011

why am i getting this?

SQL> SELECT TABLE_NAME,owner from dba_TABLES where TABLE_NAME in ('BSNL_ACCOUNT_DATA','BSNL_SERVICE_DATA','BSNL_PKG_DETAILS');

TABLE_NAME OWNER
------------------------------ ------------------------------
BSNL_ACCOUNT_DATA BPREAD
BSNL_SERVICE_DATA BPREAD

but the table exists

SQL> select count(*) from BPREAD.BSNL_PKG_DETAILS;

COUNT(*)
----------
3704

SQL> select TABLE_NAME,owner from dba_TABLES where TABLE_NAME='BSNL_PKG_DETAILS';

no rows selected

why is it showing no rows even if the table exists

View 3 Replies View Related

Unable To Extend Tablespace

Nov 15, 2010

I have 25G free in tablespaces. but while inserting the table i am getting error.

ORA-01688: unable to extend table CIRCMANAGER.TBK_NEW_ORDER_SUMMARY partition HA20044Q by 512 in tablespace ts_neworder

We need to change any parameter?

View 4 Replies View Related

Unable To Enable The Audit

Jul 5, 2012

I facing the below issue while enable the audit on table.

SQL> audit delete on test;
audit delete on test
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01400: cannot insert NULL into ("SYS"."AUDIT_DDL"."DICT_OBJ_TYPE")
ORA-06512: at line 2

===
Related Information
===
SQL> select version from v$instance;

VERSION
-----------------
11.2.0.2.0

SQL> show parameter audit;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /orasw/product/11.2.0
/rdbms/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB

SQL> SELECT TABLESPACE_NAME,owner from dba_tables where table_name='AUD$';

TABLESPACE_NAME OWNER
------------------------------ ------------------------------
AUDIT_DATA SYS

View 4 Replies View Related

Unable To Extract NULLS

Dec 20, 2011

Am trying to extract data from oracle onto flatfile(.txt), am using UTL_FILE but, NULLs in oracle tables are getting converted into space and if i try loading into table it is getting loaded as space,

View 1 Replies View Related

Unable To Select Only Record For 07 Nov 06

Nov 13, 2006

I am unable to select only record for 07Nov06. if i use between i get records e.g. :07 November ,2006-0941

Select
TO_CHAR(session_START_time,'dd month,yyyy-hh24mi') LOG_IN_TIME,
TO_CHAR(session_END_time,'dd month,yyyy-hh24mi') LOG_OUT_TIME
from SESSION_LOG
where SESSION_LOG.SESSION_START_TIME
between '06Nov06' AND '07Nov06';

View 2 Replies View Related

Unable To Connect To Sql Server From 11g?

Jun 21, 2012

When we tried to query a data from the sql server we are getting the below generic error message i

SQL> select * from all_users@testing
2 /
select * from all_users@testlink1
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from TESTLINK1

below are the details setup / configuration done by us:

os :windows 2008 server.
database "oracle standard edition
Command Line input /output:
C:\Users\aorenstein>C:\oracle\product\11.2.0\db_1\bin\dg4odbc
Oracle Corporation --- WEDNESDAY JUN 20 2012 10:20:54.308
Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with
Oracle Database Gateway for ODBC

[code]....

View 1 Replies View Related

SQL & PL/SQL :: Unable To Insert Rows

Aug 4, 2010

In oracle 11i, unable to insert rows using insert statement. unable to retrieve data using select statement.

View 5 Replies View Related

Reports & Discoverer :: Unable To Run Sql In 3.0?

Oct 20, 2010

I am having the following sql but unable to run in Report 3.0

SELECT LIC_NO, RO_NO, RO_DTIME, HANDLED_BY,ROW_NUMBER()
OVER (PARTITION BY HANDLED_BY ORDER BY RO_NO) AS emp_id
FROM mss_veh_input_test;

View 3 Replies View Related

SQL & PL/SQL :: Unable To Drop A Trigger?

Jun 14, 2011

I have a trigger called DDL_TRIG which is used to audit all DDL level operation on the Database. The trigger script is as below:-

CREATE OR REPLACE TRIGGER ddl_trig
AFTER DDL
ON DATABASE
BEGIN
INSERT INTO ddl_log
(user_name, ddl_date, ddl_type,

[code].....

The Table DDL_LOG exists.Now i want to disable or drop this trigger and it wont allow us. While doing on one schema it fails and with below error:

when logged in schema1 and give drop or disable command it fails

ORA:04098:trigger schema2.ddl_trig is invalid and failed re-validation.

when logged in schema2 and give drop or disable command it fails

ORA:04098:trigger schema1.ddl_trig is invalid and failed re-validation.

how can we drop this trigger in both the schema's. This trigger is not allowing us to do any activity on the Database and causing lot of problem.

View 7 Replies View Related

SQL & PL/SQL :: Unable To Recreate An Object?

Mar 15, 2010

I have the metadata of an object in one of my database table as xml. I failed to recreate the object in the other schema using metadata api. I developed a stored function to do the above job. My function doesn't throw any error as well as it doesn't create the object.

My code snippet is

CREATE OR REPLACE PROCEDURE DDI.move_table(
table_name in VARCHAR2,
from_schema in VARCHAR2,
to_schema in VARCHAR2 )
AUTHID CURRENT_USER

[code]....

The schema where i create and execute my function have dba privilege also.

View 9 Replies View Related

SQL & PL/SQL :: Unable To Insert Into Another Table?

Mar 25, 2011

i am facing a small problem (!!) while inserting into a table by selecting from another table.

let me simulate.

while execute the select query, i am able to view the records. but when the data inserted into the new table, empty column value is getting inserted. this problem with only one column.

Table 1 : data to be selected.
CREATE TABLE DRI_TEST2
(
FM_COMPANY VARCHAR2(4 BYTE)
)

[Code]....

if we select the select clause we will be able to see the records. but while inserting empty values are getting inserted.

View 15 Replies View Related

SQL & PL/SQL :: Unable To Drop A Procedure?

Nov 29, 2012

I tried to Drop a procedure we have created, but an error is raised while droping it.

ora-04043 object does not exist

View 28 Replies View Related

PL/SQL :: Unable To Drop A Broken Job

Jan 3, 2013

i want to drop a broken job but it is taking long time why?

i am using below syntax:

begin
dbms_job.broken(job=> 345,FALSE);
commit;
end;
/

View 5 Replies View Related

Client Tools :: Unable To Run SQL *Plus?

Oct 5, 2012

I'm not able to run SQL *Plus on my machine. It is giving me below error.

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Setting of PATH environment variable is as below. If I remove below highlighted part I'm able to run SQL * Plus. I cannot remove this because it is required to run my application.

C:oracleproduct10.2.0client_1in;C:OSIBANKDLLBIN;C:OSIBANKBat_Exe;C:OSIBANKDLL;c:Program Files (x86)InteliCLS Client;c:Program FilesInteliCLS Client;C:Program Files (x86)AMD APPinx86_64;C:Program Files (x86)AMD APPinx86;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;c:Program Files (x86)Microsoft SQL Server90Toolsinn;%TFSPowerToolDir%;%BPADir%;C:Program FilesIntelIntel(R) Management Engine ComponentsDAL;C:Program FilesIntelIntel(R) Management Engine ComponentsIPT;C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDAL;C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPT;C:Program Files (x86)IntelOpenCL SDK2.0inx86;C:Program Files (x86)IntelOpenCL SDK2.0inx64

View 5 Replies View Related

SQL & PL/SQL :: Unable To Create DB Package?

Mar 1, 2012

I´m having a trouble creating a db package. I´ve changed my job and now i´m working full on DB instead of Forms Developer.

So my trouble is that i want to create some like a global cursor on DB package, i know you can create global variables and use it on all the procedures/function inside the package. But how about cursors?

My problem: I dont´know how to declare into the spec. I don´t know how to use it on body.

My actual

I have the structure below:

PackageSpec:
CREATE OR REPLACE PACKAGE [i]MyPackageName[/i]
IS
CURSOR [i]myGlobalCursor[/i](par1 IN VARCHAR2, par2 IN DATE)(
);
PROCEDURE [i]MyProcedure1[/i](par1 IN VARCHAR2, par2 VARCHAR2);

[code]....

View 13 Replies View Related

Unable To Login Into Database

May 5, 2013

I have a problem to login on my database 11.1.0.7 on linux 64. It were migrated from 9.2.0.4 and everything was fine but now I am not able to connect to database.

Only one way when I can connect is when the database is started in RESTRICTED mode and I cold login under sys (sysdba).

But when i leave this mode, nobody can connect . sqlplus is freeze and I have to kill that session. What could be a reason? Any parameters? It's strange for me because It was working..

View 12 Replies View Related

Unable To Set Sga_max_size Parameter Value?

May 24, 2013

To tune the OID11g the DB parameter recommendation is :

sga_target Minimum 60% of RAM
sga_max_size Minimum 60% of RAM
db_cache_size Minimum 60% of RAM

So what is RAM size..is that the RAM size on the linux BOX which is 8 GB in my case
or RAM size assigned to Oracle DB?

If I take RAM size 8 GB I am not able to modify the parameter. I am getting below error:

SQL> alter system set sga_max_size=4916M scope=both;
alter system set sga_max_size=4916M scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

how to check that total memory assigned to Oracle DB?

View 16 Replies View Related

Unable To Login Database

Aug 1, 2012

I am not able to Login database , what should i do?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved