We have an application running in Oracle Forms which connects to an Oracle database (12c). We've always had issues with using the "@" sign in passwords so we always instructed our users not to use the "@" sign. Is there a way we can use this? Maybe some modification to the formsweb.cfg or something else? We connect to an Oracle Database via Oracle Forms. Many thanks in advance! Best regards, Roël

I'm working on an Oracle Forms 11g application linked with an Oracle 18c database and I stumbled upon a strange error when compiling my form. Here's a snippet to illustrate the problem (I changed the identifiers name but it doesn't matter): PROCEDURE SOME_PROCEDURE(...) IS v_arg1 relation.c_arg1%type; v_arg2 relation.c_arg2%type; v_arg3 relation.c_arg3%type; BEGIN SELECT r.c_arg1, r.c_arg2, r.c_arg3 INTO v_arg1, v_arg2, v_arg3 FROM relation r WHERE ... -- Some more code ... END; When I'm compiling, the error I get is : Compilation errors on SOME_PROCEDURE: PL/SQL ERROR 302 at line 2, column 19 component 'C_ARG1' must be declared PL/SQL ERROR 0 at line 2, column 10 Item ignored PL/SQL ERROR 302 at line 3, column 19 component 'C_ARG2' must be declared PL/SQL ERROR 0 at line 3, column 10 Item ignored PL/SQL ERROR 302 at line 4, column 19 component 'C_ARG3' must be declared PL/SQL ERROR 0 at line 4, column 10 Item ignored relation here is a table name and is causing the problem. If, for testing purposes, I pick another table and field name, the code compiles fine e.g. v_arg1 other_table.other_field%type;. I figured maybe relation is a reserved keyword (even though I couldn't find anything in the documentation about this specific keyword, yikes), so I tried to put the schema name admin before the table name: PROCEDURE SOME_PROCEDURE(...) IS v_arg1 admin.relation.c_arg1%type; v_arg2 admin.relation.c_arg2%type; v_arg3 admin.relation.c_arg3%type; BEGIN And it works just fine. Now this is a problem, because admin is not a fixed name and will change because multiple schemas are used for multiple purposes ie development, testing, production, etc. This is where I'm stuck. I don't know how to do this the "right" way: because the %type is a VARCHAR2 with some length, I'll use something larger than usual such as VARCHAR2(100) and hopefully it downcasts without errors in the future. My question is, is it possible to come up with a way to reference this table without specifying the schema? This is for my work, I don't have much freedom in changing the table/schema name, etc. Thank you

I generate a report in PDF through passing of parameters from Oracle Forms 11g. I have a requirement to email the same report automatically as well. Following is the part of forms where I have passed on the parameters. pl_id := Create_Parameter_List('tmpdata1'); add_parameter(pl_id, 'FDT', TEXT_PARAMETER, :a); add_parameter(pl_id, 'TDT', TEXT_PARAMETER, :b); add_parameter(pl_id, 'VC', TEXT_PARAMETER, :e); add_parameter(pl_id, 'SYS_DATE', TEXT_PARAMETER, :f); ADD_PARAMETER(pl_id,'DESTYPE',TEXT_PARAMETER,'FILE'); ADD_PARAMETER(pl_id,'DESFORMAT',TEXT_PARAMETER,'PDF'); ADD_PARAMETER(pl_id,'DESNAME',TEXT_PARAMETER,'C:\Downloads\abc.pdf'); Now a copy of report is saved in C:\Downloads folder as well as its shown in browser. I use the following procedure to send current data shown in Forms via emails. create or replace procedure send4 (p_sender IN VARCHAR2, p_recipient IN VARCHAR2, p_subject IN VARCHAR2, p_message IN VARCHAR2) IS crlf VARCHAR2(2) := chr(13)||chr(10); l_mailhost VARCHAR2(255) := ; v_connection UTL_SMTP.connection; BEGIN V_CONNECTION := utl_smtp.open_connection(l_mailhost, 25); utl_smtp.Helo(V_CONNECTION, l_mailhost); utl_smtp.Mail(V_CONNECTION, p_sender); utl_smtp.Rcpt(V_CONNECTION, p_recipient); utl_smtp.Data(V_CONNECTION, 'Date: ' || to_char(sysdate, 'Dy, DD Mon YYYY hh24:mi:ss') || crlf || 'From: ' || p_sender || crlf || 'Subject: '|| p_subject || crlf || 'To: ' || p_recipient || crlf || 'MIME-Version: 1.0'|| crlf || -- Use MIME mail standard 'Content-Type: multipart/mixed;'|| crlf || ' boundary="-----SECBOUND"'|| crlf || crlf || '-------SECBOUND'|| crlf || 'Content-Type: text/plain;'|| crlf || 'Content-Transfer_Encoding: 7bit'|| crlf || crlf || p_message|| crlf || crlf || '-------SECBOUND'|| crlf || 'Content-Type: text/plain;'|| crlf || ' name="file.txt"'|| crlf || 'Content-Transfer_Encoding: 8bit'|| crlf || 'Content-Disposition: attachment;'|| crlf || ' filename="attachment.txt"'|| crlf || crlf || p_message|| crlf || -- Content of attachment crlf || '-------SECBOUND--' -- End MIME mail ); UTL_SMTP.quit(v_connection); EXCEPTION WHEN utl_smtp.Transient_Error OR utl_smtp.Permanent_Error then raise_application_error(-20000, 'Unable to send mail', TRUE); END; 1. Can I email the Report generated directly? I tried passing the parameter 'MAIL' and 'Email address' in destype and desname but I am guessing there is some settings need to be done? OR 2. How can I use the email procedure to send the said report as attachment? OR 3. How can I copy the report pdf generated in user's PC to a specific directory at server? Because I have one separate procedure for email where I can mail PDFs from server directly. User has Windows PC while server is LINUX. OR 4. Generate report in PDF format at server directly so I could use the procedure (#3 point) to email it? I am posting this here in Database Administrators because I believe there needs to be a database level configuration done (developers have not been able to help). Sorry if its a wrong forum to post.

Since few years ago I have worked and extending a application build by Forms Builder 10g and running via Oracle Application Service 10g. The application can be launched as: http://portal.dev:7778/forms/frmservlet?config=db Now, we want to take a new step migrating our forms to the cloud an be accessed from anywhere. My first task was finding some resource into Oracle services, and I found [Java Cloud Service - SaaS Extension](https://cloud.oracle.com/en_US/java/servicesaas/pricing) : > 1. This is the number of Oracle WebLogic Server Managed Server instances to which the applications are deployed (customer managed Java EE application container) Preconfigured Oracle WebLogic Server 12c or 11g cluster configured with Oracle Database Cloud Service 2. This is the amount of RAM allocated to the Java heap for all of the service's Managed Servers combined to run the Oracle WebLogic Server Managed Servers and the objects consumed by your application code So, I decided to try the free month there. Successfully the account was created and I can navigate between all services listed there. But the real question is, which of all services there should I need to open? My first impression is to start with the "Java": But I would like to take your advice, because I am not sure at all. Please, let me know if more details are needed.

I have an old Oracle Forms solution that accesses a 9i database and I have been asked if it's possible to replicate to an Oracle 12c database server, with the intention of using Fusion until a new application is built. Is it possible to replicate between these two versions? Or is there another way to achieve an active-active replica between the two servers? i.e. log shipping etc.