commit and rollback on triggers
Nope. The only way to commit or rollback in a database trigger (or a procedure/function invoked by a trigger) is using <a href=”http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/autonotransaction_pragma.htm”>Autonomous Transactions</a>.
View Answer
| February 3, 2012 2:43 PM
Oracle, Oracle 10g, Oracle 10g triggers
Nope. The only way to commit or rollback in a database trigger (or a procedure/function invoked by a trigger) is using <a href=”http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/autonotransaction_pragma.htm”>Autonomous Transactions</a>.
View Answer
| February 3, 2012 2:43 PM
Oracle, Oracle 10g, Oracle 10g triggers
commit and rollback on triggers
Short answer: It is a restriction imposed by Oracle. Not so short: If transaction control commands (commit/rollback) were allowed in database triggers, then other programs or stored procedures/functions would not have control over their own transactions. They would not have a way to decide when to commit or rollback their operations. For example, if a [...]
View Answer
| February 2, 2012 3:44 PM
Oracle 10g, Oracle 10g triggers
Short answer: It is a restriction imposed by Oracle. Not so short: If transaction control commands (commit/rollback) were allowed in database triggers, then other programs or stored procedures/functions would not have control over their own transactions. They would not have a way to decide when to commit or rollback their operations. For example, if a [...]
View Answer
| February 2, 2012 3:44 PM
Oracle 10g, Oracle 10g triggers
Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8
I haven’t tried this before, but all you should need to do is install MySQL-ODBC and configure a connection between the MySQL and Oracle databases by modifying the odbc.ini files on each server, create an Oracle database link to the MySQL data source, then you should be able to insert, update, delete, and select from [...]
View Answer
| January 31, 2012 9:20 PM
MySQL 5.0, Oracle 10g, Solaris 8, Windows Server 2003
I haven’t tried this before, but all you should need to do is install MySQL-ODBC and configure a connection between the MySQL and Oracle databases by modifying the odbc.ini files on each server, create an Oracle database link to the MySQL data source, then you should be able to insert, update, delete, and select from [...]
View Answer
| January 31, 2012 9:20 PM
MySQL 5.0, Oracle 10g, Solaris 8, Windows Server 2003
How can I Send report output to 3 different printer programatically
You would need to call the RUN_REPORT_OBJECT (or RUN_PRODUCT) built-in procedure 3 times. For each call, you would need to set the DESNAME parameter to the name of the desired printer. As you probably know, DESNAME is a system parameter, and you will need to use a Parameter List to send it to the reports [...]
View Answer
| January 31, 2012 3:27 PM
Oracle 6, Oracle Reports, Oracle Reports 6i
You would need to call the RUN_REPORT_OBJECT (or RUN_PRODUCT) built-in procedure 3 times. For each call, you would need to set the DESNAME parameter to the name of the desired printer. As you probably know, DESNAME is a system parameter, and you will need to use a Parameter List to send it to the reports [...]
View Answer
| January 31, 2012 3:27 PM
Oracle 6, Oracle Reports, Oracle Reports 6i
about oracle installation
I am assuming that you want to install Oracle11g on Windows 7. Here is a link to video tutorial that demonstrates how to install Oracle11g on Windows 7 – <a href=”http://www.youtube.com/watch?v=C5XDtdxSqf0″>http://www.youtube.com/watch?v=C5XDtdxSqf0</a>. Please keep in mind that you should have sufficient free disk space (~5GB), an ample amount of free memory (~2GB), and a decent CPU [...]
View Answer
| January 31, 2012 3:12 PM
Oracle, Oracle installation, Windows 7
I am assuming that you want to install Oracle11g on Windows 7. Here is a link to video tutorial that demonstrates how to install Oracle11g on Windows 7 – <a href=”http://www.youtube.com/watch?v=C5XDtdxSqf0″>http://www.youtube.com/watch?v=C5XDtdxSqf0</a>. Please keep in mind that you should have sufficient free disk space (~5GB), an ample amount of free memory (~2GB), and a decent CPU [...]
View Answer
| January 31, 2012 3:12 PM
Oracle, Oracle installation, Windows 7
Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Compressing Old Files
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
oracle
You can use Oracle’s Change Management Pack, TOAD for Oracle from Quest Software, or Oracle Schema Compare from Red Gate Software to compare the structure and contents of two tables. You can use the “describe” command in SQL*Plus also to show the structure of a table and determine differences.
View Answer
| January 22, 2012 12:52 PM
Oracle Schema, Oracle Table, Toad Data Modeler
You can use Oracle’s Change Management Pack, TOAD for Oracle from Quest Software, or Oracle Schema Compare from Red Gate Software to compare the structure and contents of two tables. You can use the “describe” command in SQL*Plus also to show the structure of a table and determine differences.
View Answer
| January 22, 2012 12:52 PM
Oracle Schema, Oracle Table, Toad Data Modeler
sc password reset on SUN V245
Just connect to the Alom in serial port and power down the server and remove the power cards wait a couple of seconds. Again unplug the power card Alom booting that time you press EScap Key on ALOM menu you press E for erase the Alom NVRAM variables and press R to return now you [...]
View Answer
| January 20, 2012 12:20 AM
Oracle
Just connect to the Alom in serial port and power down the server and remove the power cards wait a couple of seconds. Again unplug the power card Alom booting that time you press EScap Key on ALOM menu you press E for erase the Alom NVRAM variables and press R to return now you [...]
View Answer
| January 20, 2012 12:20 AM
Oracle
How to install oracle 7 or 11 xp x64 bit ?
Installing Oracle 11g on Windows XP is pretty straight forward. Here is a link that demonstrates how with screenshots – http://www.errcode.net/blogs/?p=9. I would not recommend Oracle 7 as it is way to old and not supported anymore. If you need more assistance please provide the error you are getting.
View Answer
| January 18, 2012 12:01 PM
Oracle 11, Oracle 11g installation, Oracle 7, Oracle installation
Installing Oracle 11g on Windows XP is pretty straight forward. Here is a link that demonstrates how with screenshots – http://www.errcode.net/blogs/?p=9. I would not recommend Oracle 7 as it is way to old and not supported anymore. If you need more assistance please provide the error you are getting.
View Answer
| January 18, 2012 12:01 PM
Oracle 11, Oracle 11g installation, Oracle 7, Oracle installation
How can do iSQl*Plus login for DBA
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Why in oracle sql the deleted(uncommited) rows are not visible in current session but visible to other session?
Here’s the link provided in the answer above: <a href=”http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm”>Oracle® Database Concepts – Data Concurrency and Consistency</a>
View Answer
| January 16, 2012 2:37 PM
Oracle
Here’s the link provided in the answer above: <a href=”http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm”>Oracle® Database Concepts – Data Concurrency and Consistency</a>
View Answer
| January 16, 2012 2:37 PM
Oracle
Benefits of Oracle database 10g vs. 11g editions?
I’m unaware of the existence of an 11g express edition. Have a look at the following document to get information on some of the new features/enhancements on 11g: <a href=”http://www.oracle.com/technology/products/database/oracle11g/pdf/database-11g-product-family-technical-whitepaper.pdf”>Oracle Database 11g Product Family</a> (pdf). A major advantage of Oracle11g over 10g is a 25% performance improvement in many SQL queries without any code modifications. [...]
View Answer
| January 16, 2012 2:31 PM
Oracle 10g, Oracle 11g, Oracle Database Versions
I’m unaware of the existence of an 11g express edition. Have a look at the following document to get information on some of the new features/enhancements on 11g: <a href=”http://www.oracle.com/technology/products/database/oracle11g/pdf/database-11g-product-family-technical-whitepaper.pdf”>Oracle Database 11g Product Family</a> (pdf). A major advantage of Oracle11g over 10g is a 25% performance improvement in many SQL queries without any code modifications. [...]
View Answer
| January 16, 2012 2:31 PM
Oracle 10g, Oracle 11g, Oracle Database Versions
getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch
As the error states, your query is returning more than one row, when a single row/value is expected, the options to resolve this error are: 1. Rewrite your SELECT INTO statement so that only one row is returned. 2. Replace your SELECT INTO statement with a cursor. Additional helpful information about this error with examples [...]
View Answer
| January 9, 2012 4:36 PM
Database, Oracle, Oracle installation
As the error states, your query is returning more than one row, when a single row/value is expected, the options to resolve this error are: 1. Rewrite your SELECT INTO statement so that only one row is returned. 2. Replace your SELECT INTO statement with a cursor. Additional helpful information about this error with examples [...]
View Answer
| January 9, 2012 4:36 PM
Database, Oracle, Oracle installation
How to recover from ORA 01033 Oracle installation or shutdown in progress error
The ORA-01157 error is telling you that Oracle cannot locate and/or access the data files identied by the ORA-01110 error, and Oracle cannot start if it cannot locate/access these data files. And, the ORA-01081 error is telling you that you cannot start an already running or partially started database. I would recommend issuing a “shutdown [...]
View Answer
| April 19, 2013 2:59 AM
Oracle 8i, Oracle Database, Oracle error messages
The ORA-01157 error is telling you that Oracle cannot locate and/or access the data files identied by the ORA-01110 error, and Oracle cannot start if it cannot locate/access these data files. And, the ORA-01081 error is telling you that you cannot start an already running or partially started database. I would recommend issuing a “shutdown [...]
View Answer
| April 19, 2013 2:59 AM
Oracle 8i, Oracle Database, Oracle error messages
size of oracle database
Oracle can store as much data as you can throw at it. Really. Oracle is scalable to the petabyte level and as long as hardware platforms keep increasing processing capacity, memory, storage, and network throughput, that number will continue to get larger and larger. The difference between Oracle9i (i = internet) and Oracle10g (g = [...]
View Answer
| January 8, 2012 6:39 PM
Oracle
Oracle can store as much data as you can throw at it. Really. Oracle is scalable to the petabyte level and as long as hardware platforms keep increasing processing capacity, memory, storage, and network throughput, that number will continue to get larger and larger. The difference between Oracle9i (i = internet) and Oracle10g (g = [...]
View Answer
| January 8, 2012 6:39 PM
Oracle
how to open oracle in web browser??
By opening Oracle in web browser, I am assuming you mean how to access Enterprise Manager via the browser which can be done using this URL construct – http://hostname:portnumber/em where host name is the name of the computer where you installed Oracle and port 5500 by default. Useful documentation can be found at http://docs.oracle.com/cd/B13789_01/server.101/b10742/em_manage.htm. The [...]
View Answer
| January 7, 2012 3:08 AM
Oracle 10g, Oracle 10g connectivity, Oracle memory usage
By opening Oracle in web browser, I am assuming you mean how to access Enterprise Manager via the browser which can be done using this URL construct – http://hostname:portnumber/em where host name is the name of the computer where you installed Oracle and port 5500 by default. Useful documentation can be found at http://docs.oracle.com/cd/B13789_01/server.101/b10742/em_manage.htm. The [...]
View Answer
| January 7, 2012 3:08 AM
Oracle 10g, Oracle 10g connectivity, Oracle memory usage
running oracle form
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
| January 3, 2012 2:13 PM
Oracle Forms & Reports Developer 10g
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
| January 3, 2012 2:13 PM
Oracle Forms & Reports Developer 10g
Open IT Forum: What cloud concern do you need addressed?
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
What are your favorite cloud security blogs?
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
