If you have p4 and you want to install oracle 8i, setup will not run or may create some error like credential error.
The simple solution for this is to search the file symcjit.dll from uninstall directory of oracle 8i. Rename this file. Now run the setup. Setup will run smoothly.
If you have also installed developer 6i, search the same file from orant directory and comment it as well.
If you are on LAN, you may also get an error while creating databases; End of File. Simple solution for that as well. Search the file sqlnet from direcotry where you have installed oracle. e.g; C:\oracle\network\admin\sqlnet.ora. Comment the parameter: SQLNET.AUTHENTICATION_SERVICES= (NTS) with hash sign.
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
Hope it will be helpful
Cheers …….
Error REP-1259 in 6i/9i report.
It says group has no break coloumns.
Solution:
Check the item properties on which you have created group, in Column node check the Break Order property, It would be set to NONE. It should be either Ascending or Descending.
Regards
Oracle will acquire all outstanding shares of BEA for $19.375 per share in cash.
We can send email through Oracle forms. The procedure given below may be a stored procedure or a program unit in a form. Its upto one’s approach and requirement. Any ways the procedure is:
create or replace procedure E_MAIL(
p_to in varchar2,
p_from in varchar2,
p_subject in varchar2,
p_text in varchar2 default null,
p_html in varchar2 default null,
p_smtp_hostname in varchar2,
p_smtp_portnum in varchar2)
is
l_boundary varchar2(255) default ‘a1b2c3d4e3f2g1′ ;
l_connection utl_smtp.connection ;
l_body_html clob := empty_clob; –This LOB will be the email message
l_offset number;
l_ammount number;
l_temp varchar2(32767) default null;
begin
l_connection := utl_smtp.open_ connection( p_smtp_hostname, p_smtp_portnum );
utl_smtp.helo( l_connection, p_smtp_hostname );
utl_smtp.mail( l_connection, p_from );
utl_smtp.rcpt( l_connection, p_to );
l_temp := l_temp || ‘MIME-Version: 1.0′ || chr(13) || chr(10);
l_temp := l_temp || ‘To: ‘ || p_to || chr(13) || chr(10);
l_temp := l_temp || ‘From: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Subject: ‘ || p_subject || chr(13) || chr(10);
l_temp := l_temp || ‘Reply-To: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Content-Type: multipart/alternati ve; boundary=’ ||
chr(34) || l_boundary || chr(34) || chr(13) ||
chr(10)||utl_ tcp.CRLF;
———— ——— ——— ——— ——— —-
– Write the headers
dbms_lob.createtemp orary( l_body_html, false, 10 );
dbms_lob.write( l_body_html, length(l_ temp),1,l_ temp);
———— ——— ——— ——— ——— —-
– Write the text boundary
l_offset := dbms_lob.getlength( l_body_html) + 1;
l_temp := ‘–’ || l_boundary || chr(13)||chr( 10);
l_temp := l_temp || ‘content-type: text/plain; charset=us-ascii’ ||
chr(13) || chr(10) || chr(13) || chr(10);
dbms_lob.write( l_body_html, length(l_ temp),l_offset, l_temp);
———— ——— ——— ——— ——— —-
– Write the plain text portion of the email
l_offset := dbms_lob.getlength( l_body_html) + 1;
dbms_lob.write( l_body_html, length(p_ text),l_offset, p_text);
———— ——— ——— ——— ——— —-
– Write the HTML boundary
l_temp := chr(13)||chr( 10)||chr( 13)||chr( 10)||’–’ || l_boundary ||
chr(13) || chr(10);
l_temp := l_temp || ‘content-type: text/html;’ ||
chr(13) || chr(10) || chr(13) || chr(10);
l_offset := dbms_lob.getlength( l_body_html) + 1;
dbms_lob.write( l_body_html, length(l_ temp),l_offset, l_temp);
———— ——— ——— ——— ——— —-
– Write the HTML portion of the message
l_offset := dbms_lob.getlength( l_body_html) + 1;
dbms_lob.write( l_body_html, length(p_ html),l_offset, p_html);
———— ——— ——— ——— ——— —-
– Write the final html boundary
l_temp := chr(13) || chr(10) || ‘–’ || l_boundary || ‘–’ || chr(13);
l_offset := dbms_lob.getlength( l_body_html) + 1;
dbms_lob.write( l_body_html, length(l_ temp),l_offset, l_temp);
———— ——— ——— ——— ——— —-
– Send the email in 1900 byte chunks to UTL_SMTP
l_offset := 1;
l_ammount := 1900;
utl_smtp.open_ data(l_connectio n);
while l_offset < dbms_lob.getlength( l_body_html) loop
utl_smtp.write_ data(l_connectio n,
dbms_lob.substr( l_body_html, l_ammount, l_offset) );
l_offset := l_offset + l_ammount ;
l_ammount := least(1900,dbms_ lob.getlength( l_body_html) - l_ammount);
end loop;
utl_smtp.close_ data(l_connectio n);
utl_smtp.quit( l_connection );
dbms_lob.freetempor ary(l_body_ html);
end;
———— ——— ——— ——— ——— ——— ——— ——
You may call this procedure like
E_MAIL(’abc@abc.com’, ‘Auto Notification’ ,’YourSubject’,'abc co’,l_body,’ 192.168.10.2′,’25′);
Cheers …….