Report

https://www.youtube.com/watch?feature=player_detailpage&v=LWbgiXz6SmA

Read Image file from oracle forms youtube

Configuration of 10DGS Report Server

PURPOSE

-------

This note tells how to convert run_product to run_report_object while migratingfroms 6i to 10g because Run_product is not supported for web.

1) Create the table rw_server in your database.You can find the script in the

ORACLE_HOME\REPORT\ADMIN\SQL\rw_server.

2) Make sure that rp2rro.pll /plx is in the forms (registry) and you are able to generate the modified plx.

3) Use Migration assistant for conversion.

Run_product built in will be replaced to rp2rro.rp2rro_run_product and will creates parameters for the DESFORMAT,DESNAME,DESTYPE,SERVERNAME etc.

4). You need to give your correct reports server name in the SERVERNAME parameter

(RP2RROREPORTSERVER).

5) Make sure that the reports server is running or you can start it by using

rwserver server=Repserver from command prompt.

6) If you are running report on Web and if the output needs to be shown in the browser

window, then the reports DESTYPE should be set to CACHE or FILE and not SCREEN or

PREVIEW.

Note: If you are not using Migration assistance then you will have to manually change the name

of function “Run_Product” to “rp2rro.rp2rro_run_product”. Also you have to create the

fallowing parameters

In the calling form.

1) RP2RRODESFORMAT ( Set initial value =HTMLCSS)

2) RP2RRODESNAME

3) RP2RRODESTYPE ( Set initial value =CACHE)

4) RP2RROREPORTSERVER ( Set initial value =Your report server name)

5) RP2RROVIRTUALDIR ( Set initial value =/reports/)

6) RP2RROREPORTSINTERFACE ( Set initial value =rwservlet)

Correct Answer1. Re: FRM-41214 Unable to run report: forms 10g, database 11g

The solution is ;

alter system set sec_case_sensitive_logon = FALSE

The problem will be solved

Procedure To Send Email from oracle database

CREATE OR REPLACE PROCEDURE EEMAIL (p_smtp_hostname varchar2,p_smtp_portnum varchar2,p_from varchar2,p_recpt_1 varchar2,p_recpt_2 varchar2,subject VARCHAR2,MSG VARCHAR2)

IS

v_connection UTL_SMTP.CONNECTION;

v_header varchar2(1000);

crlf VARCHAR2(2):= UTL_TCP.CRLF;

--subject VARCHAR2(1000);

BEGIN

v_connection := utl_smtp.open_connection(p_smtp_hostname,p_smtp_portnum);

utl_smtp.helo(v_connection,p_smtp_hostname);

utl_smtp.mail(v_connection,p_from);

utl_smtp.rcpt(v_connection,p_recpt_1);

utl_smtp.rcpt(v_connection,p_recpt_2);

--utl_smtp.rcpt(v_connection,p_recpt_3);

v_header := 'Date: 'TO_CHAR(SYSDATE,'dd Mon yy hh24:mi:ss')crlf

'From: 'p_from''crlf

'Subject: 'subjectcrlf

'To: 'p_recpt_1crlf

'CC: 'p_recpt_2';'crlf;

-- 'CC: 'p_recpt_3crlf;

utl_smtp.open_data(v_connection);

utl_smtp.write_data(v_connection,v_header);

-- RFC 821 Format (SMTP) blank line between message header and message body

utl_smtp.write_data(v_connection,crlf);

utl_smtp.write_data(v_connection,MSGcrlfcrlf' ');

utl_smtp.close_data(v_connection);

utl_smtp.quit(v_connection);

/*EXCEPTION

WHEN UTL_SMTP.INVALID_OPERATION THEN

INSERT INTO ERROR_UPLOAD_SQL_MSG (SQL_CODE,SQL_ERROR_MSG,ERROR_DATE)

VALUES ('UTL_SMTP.INVALID_OPERATION','Invalid Operation in Mail attempt using UTL_SMTP.',SYSDATE);

COMMIT;

WHEN UTL_SMTP.TRANSIENT_ERROR THEN

INSERT INTO ERROR_UPLOAD_SQL_MSG (SQL_CODE,SQL_ERROR_MSG,ERROR_DATE)

VALUES ('UTL_SMTP.TRANSIENT_ERROR','Temporary e-mail issue - try again.',SYSDATE);

COMMIT;

WHEN UTL_SMTP.PERMANENT_ERROR THEN

INSERT INTO ERROR_UPLOAD_SQL_MSG (SQL_CODE,SQL_ERROR_MSG,ERROR_DATE)

VALUES ('UTL_SMTP.PERMANENT_ERROR','Permanent Error Encountered.',SYSDATE);

COMMIT;*/

-- END EMAIL_ERRORS;

END;

/

(Go Back)