You have to modify your TNSNAMES.ORA file in your Developer’s oracle home. If you can connect from your database installation SQL*Plus, you just need to copy the contents of your database’s oracle home tnsnames file to the Developer’s oracle home one.
View Answer | September 21, 2010 2:05 PM
Oracle, Oracle 8i, Oracle 8i Installation, Oracle DBA, Oracle Forms, Windows XP
Yes, of course, u may download the Oracle 10g XE for 64 bit version.
View Answer | September 18, 2010 6:56 AM
Oracle 10g, Windows 7, Windows 7 64-bit, Windows 7 Home Basic, Windows 7 in 2010
You could use the DDE package, to call the browser sending the url as a parameter. Here's an example:declare nExplorer pls_integer; vCommand varchar2(200) := 'path/to/your/browser' || ' ' || 'www.yourpage.com'; Begin nExplorer := dde.app_begin(vCommand,dde.app_mode_normal); end;
View Answer | April 24, 2013 6:49 PM
Oracle developers, Oracle development, Oracle Forms, Oracle Forms 6i
Which Oracle 10G Server or Client ? You couldn’t mention.
View Answer | September 6, 2010 8:42 AM
Oracle, Oracle connection error, Oracle connectivity, Oracle Database, Oracle Database 10g, Windows XP
System.cursor_record is a system variable, that represents the number of the record where the cursor is located at any given time, for example, say you have a block with 5 data records (tabular). If you click on any item of the first record, the cursor_record system variable’s value would be ’1′. If you press the [...]
View Answer | September 1, 2010 1:53 PM
Oracle, Oracle Application Server, Oracle Developer 2000, Oracle Forms 10g
<i>How can I run this process without prompting for the variable?</i> You bypass prompting by supplying values for the replacement variables. In your example, you pass in a value for a replacement variable named &CUST; but the only replacement variable in your QM query is named &SELECT. You might change your STRQMQRY SETVAR() parameter to [...]
View Answer | September 1, 2010 1:46 AM
AS/400, CLP, CLPROGRAM, Query Manager, V5R4, V5R4M0
Hi Helppleaseit, Check out <a href=”http://www.orafaq.com/wiki/ORA-12541″>Oracle’s wiki page</a> for more information on error messages. Hope this helps! - Melanie
View Answer | August 26, 2010 3:01 PM
ORA-12541, Oracle Error Codes, Oracle error messages, Oracle errors, TNSNAMES.ora
The older Forms release that was certified to work with Oracle database 10g r1 is Developer 6i. If it is 10g r2 even developer 6i might not work correctly. OTOH, when asking for help it is always recommended to post the complete and exact error messages (I guess the error message is not ‘orainst sorry’).
View Answer | August 25, 2010 1:50 PM
Oracle 10g, Oracle Database, Oracle Database 10g, Oracle Developer, Oracle Developer 2000, Oracle on Windows XP, Windows XP
check for a login.sql in your ORACLE_HOME directory. Sounds like something is changing your date_format for the session.
View Answer | August 25, 2010 12:54 PM
Hi Fsdfsdfsdfsdfasdfsd, Is this what you’re looking for? <a href=”http://www.dba-oracle.com/m_library_cache_hit_ratio.htm”>Oracle Library Cache Hit Ratio</a> & <a href=”http://www.cryer.co.uk/brian/oracle/tuning_tlc.htm”>Oracle how to tune the library cache</a> - Melanie
View Answer | August 12, 2010 3:49 PM
Oracle, Oracle administration
There are several oracle partners offering this kind of work (check out the Oracle Partner web-site for Forms). The challenges of a migration are covered within the PITSS.CON knowledge-base which enables you to concentrate on the test effort of the converted Forms.
View Answer | July 19, 2012 2:21 PM
Oracle Forms 10g, Oracle Forms 4.5, Oracle migration, RHEL, RHEL 5
Deb4u, this question seems to be related to this one (which you posted yesterday): <a href=”http://itknowledgeexchange.techtarget.com/itanswers/to-display-not-exit-data/”>To display not exit data in oracle</a> If you want to provide more details or ask for clarification, please continue the discussion in the same thread. Also, you should specify the Oracle version you are using, since the answer to [...]
View Answer | August 11, 2010 1:47 PM
Oracle, Oracle Forms, Oracle Table, Oracle Tables
Deb4u, this seems to be the same question as this one (which you posted yesterday): <a href=”http://itknowledgeexchange.techtarget.com/itanswers/to-display-not-exit-data/”>To display not exit data in oracle</a> If you want to provide more details or ask for clarification, please continue the discussion in the same thread.
View Answer | August 11, 2010 1:43 PM
Oracle, Oracle Database, Oracle Forms, Oracle Table
you can’t do this only use good text editor to copy ur SQl commands
View Answer | August 11, 2010 10:48 AM
FMB, FMX, Oracle 6i, Oracle Developer, Oracle Developer 2000
You will probably need to create a table with the months of the year, and outer-join it to your main table. Or, you could use an in-line view or subquery factoring (depending on the Oracle version) to achieve the same result. Here’s an example: <pre>WITH months AS (SELECT 1 mm,’JANUARY’ month FROM dual UNION SELECT [...]
View Answer | August 10, 2010 5:01 PM
Oracle, Oracle commands, Oracle database design, Oracle Table
To connect/disconnect Forms applications to/from the database, you have to use the <b>LOGON</b> and <b>LOGOUT </b>built-in procedures.
View Answer | August 10, 2010 3:33 PM
Oracle, Oracle administration, Oracle authentication, Oracle connectivity, Oracle Forms, Oracle User Profiles
I’m not sure to understand what you are asking, but in Oracle, the physical files used to store the data are called DATAFILEs. They could be located in any folder, but in ‘default’ installations they are inside a directory called ‘oradata’ inside the oracle home. These files can only be accessed by the DBMS. You [...]
View Answer | August 9, 2010 2:20 PM
Here’s an option: <pre>SELECT * FROM your_table ORDER BY TO_DATE(’01′||month||year,’DDMONYYYY’);</pre> If you really want them in descending order (your example shows them in ascending order) just add the DESC keyword at the end of the query.
View Answer | August 9, 2010 2:05 PM
Oracle, Oracle Database, Oracle Forms, Oracle Table
Try something like this: <pre>SELECT TO_CHAR(entry_date,’month-yyyy’), column_x, column_y, column_z FROM your_table WHERE entrty_date >= ‘&start_date’;</pre>
View Answer | August 7, 2010 4:13 PM
Oracle, Oracle 10g, Oracle Data Access, Oracle Database, Oracle Query
sqlplus username@database name
View Answer | August 5, 2010 2:56 AM
Oracle 9i, Oracle Database