plsql - PL/SQL sending email through a SSL enabled smtp server -

-

i struggling send mail plsql. using following code. hitting 1 or other error. can plz provide pointers ?

l_mail_conn := utl_smtp.open_connection( host => l_smtp_host,                                            port => l_smtp_port,                                            wallet_path => l_wallet_path,                                            wallet_password => l_wallet_password,                                            secure_connection_before_smtp => false);    utl_smtp.ehlo(l_mail_conn, l_smtp_host); --  utl_smtp.starttls(l_mail_conn); // if enable line, "503 5.5.2 send hello first" error  --  utl_smtp.command( l_mail_conn, 'auth login'); // tried approach same unrecognized authentication type --  utl_smtp.command( l_mail_conn, l_mail_username_encoded); --  utl_smtp.command( l_mail_conn, l_mail_password_encoded);   utl_smtp.auth(l_mail_conn,l_mail_username,l_mail_password,utl_smtp.all_schemes);    utl_smtp.mail(l_mail_conn, p_from);   process_recipients(l_mail_conn, p_to);   process_recipients(l_mail_conn, p_cc);   process_recipients(l_mail_conn, p_bcc);   utl_smtp.open_data(l_mail_conn);   utl_smtp.write_data(l_mail_conn, 'date: ' || to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss') || utl_tcp.crlf);   utl_smtp.write_data(l_mail_conn, 'to: ' || p_to || utl_tcp.crlf);   if trim(p_cc) not null     utl_smtp.write_data(l_mail_conn, 'cc: ' || replace(p_cc, ',', ';') || utl_tcp.crlf);   end if;   if trim(p_bcc) not null     utl_smtp.write_data(l_mail_conn, 'bcc: ' || replace(p_bcc, ',', ';') || utl_tcp.crlf);   end if;   utl_smtp.write_data(l_mail_conn, 'from: ' || p_from || utl_tcp.crlf);   utl_smtp.write_data(l_mail_conn, 'subject: ' || p_subject || utl_tcp.crlf);   utl_smtp.write_data(l_mail_conn, 'reply-to: ' || p_from || utl_tcp.crlf || utl_tcp.crlf);   utl_smtp.write_data(l_mail_conn, p_message || utl_tcp.crlf || utl_tcp.crlf);   utl_smtp.close_data(l_mail_conn);   utl_smtp.quit(l_mail_conn);

i hitting error - unrecognized authentication type . have configured oracle wallet , necessary acls.

i using oracle 12c db. there better way of sending mails utl_smtp ??


Comments

Post a Comment

Popular posts from this blog

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

jsf - "PropertyNotWritableException: Illegal Syntax for Set Operation" error when setting value in bean -

-
this question has answer here: how send form input values , invoke method in jsf bean 1 answer i error when trying send values jsf page bean. i want set values fields in bean, create airplane instance , add database. error telling me use illegal syntax setter part of bean. why error? didnt find on site helped me problem. here jsf part: <h4>add plane</h4> <c:if test="#{not empty listairplanebb.error}"> <div class="alert alert-danger"> <span class="glyphicon glyphicon-remove"></span> <h:outputtext value="#{listairplanebb.error}" /> </div> </c:if> <h:form> <table class="table"> <thead> ...
Read more

laravel - Undefined property: Illuminate\Pagination\LengthAwarePaginator::$id (View: F:\project\resources\views\admin\carousels\index.blade.php) -

-
when try pass variable data view error, can't find document problem controller(carouselcontroller.php) public function index() { $carousels = carousel::orderby('created_at', 'asc')->paginate(12); return view('admin.carousels.index')->withcarousels($carousels); } my view(index.blade.php) <div class="row"> <div class="col-md-9"> <h1>all images</h1> </div> <div class="col-md-3"> <a href="{{ route('carousels.create') }}" class="btn btn-lg btn-block btn-primary ">create new carousel</a> </div> <div class="col-md-12"> <hr> </div> </div>{{-- end of row --}} <div class="row"> <div class="col-md-12"> <div class="row"> @foreach($carousels $photo) <div class="col-xs-6 col-md...
Read more