Temporary Table in Oracle 10g
If you are running your commands exactly as you posted them, they should work and you should have data in the temporary table, <b>unless your query causes no records to be retrieved</b> (and inserted). However, if you are issuing a COMMIT after the insert, then the temporary table will be empty, as they are transaction-specific [...]
View Answer
| April 20, 2011 3:55 PM
Oracle, Oracle 10g, Oracle Tables
If you are running your commands exactly as you posted them, they should work and you should have data in the temporary table, <b>unless your query causes no records to be retrieved</b> (and inserted). However, if you are issuing a COMMIT after the insert, then the temporary table will be empty, as they are transaction-specific [...]
View Answer
| April 20, 2011 3:55 PM
Oracle, Oracle 10g, Oracle Tables
Activating Oracle Save Button when data is inserted in the text box
You could create a post-change or when-validate-item trigger for the text box, and use the set_item_property built-in procedure to change the button’s ‘enabled’ property.
View Answer
| April 19, 2011 2:23 PM
Oracle, Oracle Forms, Oracle Forms 6i
You could create a post-change or when-validate-item trigger for the text box, and use the set_item_property built-in procedure to change the button’s ‘enabled’ property.
View Answer
| April 19, 2011 2:23 PM
Oracle, Oracle Forms, Oracle Forms 6i
Oracle and form
The forms runtime needs to be installed on client machines. It includes some basic Oracle client software and other tools needed to run FMX files.
View Answer
| April 19, 2011 2:19 PM
FMX, Oracle Database, Oracle Forms, Oracle projects
The forms runtime needs to be installed on client machines. It includes some basic Oracle client software and other tools needed to run FMX files.
View Answer
| April 19, 2011 2:19 PM
FMX, Oracle Database, Oracle Forms, Oracle projects
Increasing printable area in oracle report 6i
Increase the hieght of main section —-report builder—>layout model—->Main Section
View Answer
| April 19, 2011 9:54 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i User Parameters
Increase the hieght of main section —-report builder—>layout model—->Main Section
View Answer
| April 19, 2011 9:54 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i User Parameters
Free IT Book: Why New Systems Fail
Disaster Recovery Planning posted here. http://itknowledgeexchange.techtarget.com/itanswers/disaster-recovery-5/
View Answer
| April 19, 2011 12:25 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Disaster Recovery Planning posted here. http://itknowledgeexchange.techtarget.com/itanswers/disaster-recovery-5/
View Answer
| April 19, 2011 12:25 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SAP training materials?
ERP is “enterprise resource planning”. ERP is a software , which is developed for all departments for an organisation(like sales,finance,hr,material management,production planning etc.). In earlier days, for finance , one software, & for sales another software, like due to this integrations of all softwares is much difficult. But right now, ERP COMES INTO EXISTANCE. WHICH [...]
View Answer
| April 15, 2011 1:09 PM
Certifications, IT careers, Oracle ERP, Recommended reading, SAP careers, SAP certifications, SAP developers, SAP development, SAP ERP, SAP jobs, SAP training
ERP is “enterprise resource planning”. ERP is a software , which is developed for all departments for an organisation(like sales,finance,hr,material management,production planning etc.). In earlier days, for finance , one software, & for sales another software, like due to this integrations of all softwares is much difficult. But right now, ERP COMES INTO EXISTANCE. WHICH [...]
View Answer
| April 15, 2011 1:09 PM
Certifications, IT careers, Oracle ERP, Recommended reading, SAP careers, SAP certifications, SAP developers, SAP development, SAP ERP, SAP jobs, SAP training
Auto-creation of CoA segments legal value
yes, simple; customisation. step 1. update fnd flex (api) for the segment step 2. run your interface
View Answer
| April 15, 2011 11:18 AM
Key flexfield CoA segment, Oracle E-Business Suite, Oracle EBS
yes, simple; customisation. step 1. update fnd flex (api) for the segment step 2. run your interface
View Answer
| April 15, 2011 11:18 AM
Key flexfield CoA segment, Oracle E-Business Suite, Oracle EBS
Installing Windows 2008 recovery console on windows server 2008 server
Looks like the old recovery console has been superseded… http://en.wikipedia.org/wiki/Windows_Recovery_Environment It looks like the following link describes (eventually) how to install it to a partition…but it seems to be quite convoluted…have fun! http://social.technet.microsoft.com/Forums/en/winservergen/thread/1be47c9d-c701-44f3-a2b5-6ec0c655a5cd
View Answer
| April 14, 2011 9:47 PM
Boot manager, Recovery Manager, Windows Server 2008, Windows Server 2008 Administration, Windows server administration
Looks like the old recovery console has been superseded… http://en.wikipedia.org/wiki/Windows_Recovery_Environment It looks like the following link describes (eventually) how to install it to a partition…but it seems to be quite convoluted…have fun! http://social.technet.microsoft.com/Forums/en/winservergen/thread/1be47c9d-c701-44f3-a2b5-6ec0c655a5cd
View Answer
| April 14, 2011 9:47 PM
Boot manager, Recovery Manager, Windows Server 2008, Windows Server 2008 Administration, Windows server administration
regarding networking oracle 10g on linux
First back to the basics. The session data unit / SDU & transport date unit / TDU parameters are located in the tnsnames.ora and listener.ora files. SDU specifies the size of the packets to send over the network. The TDU is the default packet size used within Oracle*Net to group data together. The TDU parameter [...]
View Answer
| April 14, 2011 11:06 AM
Linux, Oracle 10g, Oracle administration
First back to the basics. The session data unit / SDU & transport date unit / TDU parameters are located in the tnsnames.ora and listener.ora files. SDU specifies the size of the packets to send over the network. The TDU is the default packet size used within Oracle*Net to group data together. The TDU parameter [...]
View Answer
| April 14, 2011 11:06 AM
Linux, Oracle 10g, Oracle administration
Win Drupal’s Building Blocks!
Check out member KFaganJr’s <a href=”http://itknowledgeexchange.techtarget.com/bookworm/kfaganjrs-review-of-drupals-building-blocks/”>review of <i>Drupal’s Building Blocks</i></a>!
View Answer
| April 12, 2011 5:57 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Storage virtualization, Virtualization, VoIP, Windows Server
Check out member KFaganJr’s <a href=”http://itknowledgeexchange.techtarget.com/bookworm/kfaganjrs-review-of-drupals-building-blocks/”>review of <i>Drupal’s Building Blocks</i></a>!
View Answer
| April 12, 2011 5:57 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Storage virtualization, Virtualization, VoIP, Windows Server
Requesting career advice
SAP ERP Human Capital Management or SAP ERP HCM provides features and functions that can help you manage on the same field. May develop and deploy talent more rapidly and flexibly than ever before. The solution supports and integrates all talent management processes – so u can attract, acquire, educate, and develop talent; identify and [...]
View Answer
| April 12, 2011 12:32 PM
IT career advice, IT careers, Oracle DBA, Oracle DBA jobs, SAP careers, SAP certifications
SAP ERP Human Capital Management or SAP ERP HCM provides features and functions that can help you manage on the same field. May develop and deploy talent more rapidly and flexibly than ever before. The solution supports and integrates all talent management processes – so u can attract, acquire, educate, and develop talent; identify and [...]
View Answer
| April 12, 2011 12:32 PM
IT career advice, IT careers, Oracle DBA, Oracle DBA jobs, SAP careers, SAP certifications
How to call word file from oracle report/forms 6i
Try out this….. declare AppID PLS_INTEGER; begin AppID := DDE.App_Begin(<path where the winword.exe in ur system> <path of the document u wish to open>,DDE.APP_MODE_NORMAL); end; Note: Space is must in between first path and second path ! Hope it may help u !
View Answer
| April 12, 2011 5:25 AM
Oracle Forms 6i, Oracle Reports, Oracle Reports 6i
Try out this….. declare AppID PLS_INTEGER; begin AppID := DDE.App_Begin(<path where the winword.exe in ur system> <path of the document u wish to open>,DDE.APP_MODE_NORMAL); end; Note: Space is must in between first path and second path ! Hope it may help u !
View Answer
| April 12, 2011 5:25 AM
Oracle Forms 6i, Oracle Reports, Oracle Reports 6i
Oracle 10g forms run problem
Take a look at these similar questions: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/oracle-10-g-developer/”>oracle 10 g developer</a> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/how-to-run-10g-forms-on-browser/”>How to run Oracle 10g forms on browser </a> You might want to use the site’s search feature as well.
View Answer
| April 5, 2011 2:06 PM
Oracle 10g, Oracle 10g forms, Oracle Developer 10g, Oracle Developer Suite
Take a look at these similar questions: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/oracle-10-g-developer/”>oracle 10 g developer</a> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/how-to-run-10g-forms-on-browser/”>How to run Oracle 10g forms on browser </a> You might want to use the site’s search feature as well.
View Answer
| April 5, 2011 2:06 PM
Oracle 10g, Oracle 10g forms, Oracle Developer 10g, Oracle Developer Suite
How to Validate USER parameters in Oracle Reports 6i
If you are talking about validating it in the report’s parameter form, you need to open the property palette of the desired field, and click on the” validation trigger” property. An editor will appear, in which you can write the desired code to validate the user input. When your trigger determines that the user input [...]
View Answer
| April 1, 2011 3:33 PM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i User Parameters, Oracle Reports User Parameters
If you are talking about validating it in the report’s parameter form, you need to open the property palette of the desired field, and click on the” validation trigger” property. An editor will appear, in which you can write the desired code to validate the user input. When your trigger determines that the user input [...]
View Answer
| April 1, 2011 3:33 PM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i User Parameters, Oracle Reports User Parameters
Process Manager service won’t start
I have seen this before and it’s was due to one of the oracle services being set to start or automatic instead of manual. Oracles process manager controls the starts and though it seems weird that one being set to automatic would make it load before process manager and prevent it from happening it did. [...]
View Answer
| March 31, 2011 11:15 PM
Application Server, JDE, JDE 8.11 SP1, Oracle error messages, Process Manager
I have seen this before and it’s was due to one of the oracle services being set to start or automatic instead of manual. Oracles process manager controls the starts and though it seems weird that one being set to automatic would make it load before process manager and prevent it from happening it did. [...]
View Answer
| March 31, 2011 11:15 PM
Application Server, JDE, JDE 8.11 SP1, Oracle error messages, Process Manager
Database connectivity from Oracle Forms
When you connect your forms to the database, you specify a database alias, which is an entry in your TNSNAMES.ORA file. You need to create an entry for the new database in your TNSNAMES.ORA, and then use that alias as the host string when connecting. HARSH:– i would like to improve this answer a bit… [...]
View Answer
| March 30, 2011 7:45 AM
Database connectivity, Legacy applications, Oracle connectivity, Oracle Forms
When you connect your forms to the database, you specify a database alias, which is an entry in your TNSNAMES.ORA file. You need to create an entry for the new database in your TNSNAMES.ORA, and then use that alias as the host string when connecting. HARSH:– i would like to improve this answer a bit… [...]
View Answer
| March 30, 2011 7:45 AM
Database connectivity, Legacy applications, Oracle connectivity, Oracle Forms
Need to transfer files (Excel, CSV) from Oracle to Sharepoint
Hi, you can use Oracle Connector to SharePoint server Check this link http://extensions.services.openoffice.org/en/project/sharepoint_connector
View Answer
| March 29, 2011 2:54 PM
File Transfer, File Transfer Protocols, FTP, Oracle, SharePoint
Hi, you can use Oracle Connector to SharePoint server Check this link http://extensions.services.openoffice.org/en/project/sharepoint_connector
View Answer
| March 29, 2011 2:54 PM
File Transfer, File Transfer Protocols, FTP, Oracle, SharePoint
d2k error in Oracle 10g
It sounds that, most probably errors on tnsnames.ora If u r using local naming tnsnames.ora (I hope so….) Make sure that “tnsnames is listed as one of the values of parameter in SQLNET.ORA Verify that a tnsnames.ora exists and is in the proper directory and is fully accessible Check that the net service name used [...]
View Answer
| September 17, 2012 10:40 AM
D2K, Oracle 10g, Oracle 10g administration, Oracle 10g error messages
It sounds that, most probably errors on tnsnames.ora If u r using local naming tnsnames.ora (I hope so….) Make sure that “tnsnames is listed as one of the values of parameter in SQLNET.ORA Verify that a tnsnames.ora exists and is in the proper directory and is fully accessible Check that the net service name used [...]
View Answer
| September 17, 2012 10:40 AM
D2K, Oracle 10g, Oracle 10g administration, Oracle 10g error messages
how delete 12,33,200 rows in oracle table
How many total rows are in the table? If not much more than the rows you want to delete, then you might copy the rows you want to keep into a new table and truncate the old table and then copy the records back. Otherwise, you will need to make sure your rollback segment is [...]
View Answer
| March 28, 2011 4:20 PM
DELETE statement, Oracle Table
How many total rows are in the table? If not much more than the rows you want to delete, then you might copy the rows you want to keep into a new table and truncate the old table and then copy the records back. Otherwise, you will need to make sure your rollback segment is [...]
View Answer
| March 28, 2011 4:20 PM
DELETE statement, Oracle Table
Oracle 9i eating up storage
Sounds like you are using archivelog mode and your system is creating archive logs.and that will chew up disk space like no tomorrow.
View Answer
| March 24, 2011 12:55 AM
Oracle 9i, Oracle 9i Configuration, Oracle 9i installation, Storage, Windows XP SP3
Sounds like you are using archivelog mode and your system is creating archive logs.and that will chew up disk space like no tomorrow.
View Answer
| March 24, 2011 12:55 AM
Oracle 9i, Oracle 9i Configuration, Oracle 9i installation, Storage, Windows XP SP3
