stacked canvas and tab page toghether
I’m not sure I understand what you are trying to do, but you might need to set the Viewport X and/or Y positions of the canvases in a manner that they do not overlap.
View Answer
| November 4, 2008 6:16 PM
Oracle Forms, Stacked Canvas
I’m not sure I understand what you are trying to do, but you might need to set the Viewport X and/or Y positions of the canvases in a manner that they do not overlap.
View Answer
| November 4, 2008 6:16 PM
Oracle Forms, Stacked Canvas
rep-002
Things to try: - Check that the user running the report has execute permissions on any stored SQL procedures called in the report (if any) - Compile the report against the same instance it is being run against. (If it is compiled against other instance, and that instance is somehow different to the one it [...]
View Answer
| November 4, 2008 2:29 PM
Oracle 9i, Oracle error messages, Oracle Reports, Oracle Reports 9i, REP-002
Things to try: - Check that the user running the report has execute permissions on any stored SQL procedures called in the report (if any) - Compile the report against the same instance it is being run against. (If it is compiled against other instance, and that instance is somehow different to the one it [...]
View Answer
| November 4, 2008 2:29 PM
Oracle 9i, Oracle error messages, Oracle Reports, Oracle Reports 9i, REP-002
What are the know issues with Oracle Flash back recovery area?
- You need to be sure to allocate enough space for the Flash Back recovery area, because if you don’t, this may cause problems. - Enabling flashback imposes an overhead on the database, and this could lead to a performance issue, mainly in write-intensive databases. *********************
View Answer
| November 3, 2008 5:08 PM
Oracle administration, Oracle backup, Oracle Flashback
- You need to be sure to allocate enough space for the Flash Back recovery area, because if you don’t, this may cause problems. - Enabling flashback imposes an overhead on the database, and this could lead to a performance issue, mainly in write-intensive databases. *********************
View Answer
| November 3, 2008 5:08 PM
Oracle administration, Oracle backup, Oracle Flashback
ORA-00600
ORA-00600 is a general error code, which can have many different causes. Without enough information about your environment and what operation you were trying to do, I think it will be very hard to figure out what the problem is.
View Answer
| November 3, 2008 3:20 PM
EXP dump files, ORA-00600, Oracle error messages, Oracle import/export
ORA-00600 is a general error code, which can have many different causes. Without enough information about your environment and what operation you were trying to do, I think it will be very hard to figure out what the problem is.
View Answer
| November 3, 2008 3:20 PM
EXP dump files, ORA-00600, Oracle error messages, Oracle import/export
Database Oracle
Have a look at the following articles. They will help you. 1) <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm”>Creating an Oracle Database</a> 2) <a href=”http://support.microsoft.com/kb/280106″>How to set up and troubleshoot a linked server to an Oracle database in SQL Server</a> Good luck.
View Answer
| October 31, 2008 8:26 PM
External database, Linked database, Oracle 9i, SQL Server 2000
Have a look at the following articles. They will help you. 1) <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm”>Creating an Oracle Database</a> 2) <a href=”http://support.microsoft.com/kb/280106″>How to set up and troubleshoot a linked server to an Oracle database in SQL Server</a> Good luck.
View Answer
| October 31, 2008 8:26 PM
External database, Linked database, Oracle 9i, SQL Server 2000
Oracle 9iAS Components
You could find that out by running the Oracle Universal Installer, and then clicking on the “Installed Products” button. OUI usually gets installed when you install some Oracle product, so I guess you have it on your server.
View Answer
| October 30, 2008 10:58 PM
Oracle 9i, Oracle 9i Application Server, Oracle 9iAS, Oracle Application Server
You could find that out by running the Oracle Universal Installer, and then clicking on the “Installed Products” button. OUI usually gets installed when you install some Oracle product, so I guess you have it on your server.
View Answer
| October 30, 2008 10:58 PM
Oracle 9i, Oracle 9i Application Server, Oracle 9iAS, Oracle Application Server
Linked Server Query Returns Incomplete Results
That sounds strange. Have you connected directly to the Oracle database with the same user configured for the ODBC connection, and run the same query ? The only thing that comes to my mind is the possibility of more than one table with the same name, created on different schemas. You might be querying the [...]
View Answer
| October 30, 2008 12:43 PM
Linked servers, ODBC, OLE DB, Oracle Database
That sounds strange. Have you connected directly to the Oracle database with the same user configured for the ODBC connection, and run the same query ? The only thing that comes to my mind is the possibility of more than one table with the same name, created on different schemas. You might be querying the [...]
View Answer
| October 30, 2008 12:43 PM
Linked servers, ODBC, OLE DB, Oracle Database
how to list forms and their base tables
I don’t know of a way to do what you need, and honestly, I don’t think that is possible with Forms 6i (I really hope to be wrong). Some time ago, due to some problems we had with a form, we ended opening it with a text editor like Notepad, and among other things we [...]
View Answer
| October 29, 2008 4:58 PM
Forms 6i, Oracle 10g
I don’t know of a way to do what you need, and honestly, I don’t think that is possible with Forms 6i (I really hope to be wrong). Some time ago, due to some problems we had with a form, we ended opening it with a text editor like Notepad, and among other things we [...]
View Answer
| October 29, 2008 4:58 PM
Forms 6i, Oracle 10g
Linking sqlserver to oracle
One thing to check: Verify the service name you are using to create the link in management studio. It needs to be exactly the same as defined in your tnsnames.ora file.
View Answer
| October 29, 2008 1:30 AM
Linking to Oracle from SQL Server, Oracle 9i, Oracle SQL, SQL Server
One thing to check: Verify the service name you are using to create the link in management studio. It needs to be exactly the same as defined in your tnsnames.ora file.
View Answer
| October 29, 2008 1:30 AM
Linking to Oracle from SQL Server, Oracle 9i, Oracle SQL, SQL Server
ORACLE DBMS vs. SQL sever DBMS
Hopefully the answer to this doesn’t turn into a slug fest. (First post is from the SQL Server point of view, hopefully one of the Oracle guys will post as well.) Key Differences SQL Server using T/SQL language, Oracle uses PL/SQL SQL Server can only be installed on Windows – Oracle can be installed on [...]
View Answer
| October 29, 2008 1:07 AM
Data base management, DBMS, Oracle, Oracle DBMS, SQL Server, SQL Server DBMS
Hopefully the answer to this doesn’t turn into a slug fest. (First post is from the SQL Server point of view, hopefully one of the Oracle guys will post as well.) Key Differences SQL Server using T/SQL language, Oracle uses PL/SQL SQL Server can only be installed on Windows – Oracle can be installed on [...]
View Answer
| October 29, 2008 1:07 AM
Data base management, DBMS, Oracle, Oracle DBMS, SQL Server, SQL Server DBMS
ORA-00257
ORA-000257 is the “archiver stuck” error. If enough space is available, this will not happen… in a perfect world….. Based on the activity of the database and the amount of free space I have been able to allocate to archived redo logs, I have scheduled the logs to be written to our offline backup mechanism [...]
View Answer
| October 28, 2008 9:36 PM
ORA-00257, Oracle error messages, Redo logs
ORA-000257 is the “archiver stuck” error. If enough space is available, this will not happen… in a perfect world….. Based on the activity of the database and the amount of free space I have been able to allocate to archived redo logs, I have scheduled the logs to be written to our offline backup mechanism [...]
View Answer
| October 28, 2008 9:36 PM
ORA-00257, Oracle error messages, Redo logs
Oracle Developer 10g Express Edition and Oracle Database 10g
Although I have not tested it, I guess you can. I don’t really see a reason for that not being possible.
View Answer
| October 27, 2008 7:06 PM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g, Oracle Developer 10g Express Edition
Although I have not tested it, I guess you can. I don’t really see a reason for that not being possible.
View Answer
| October 27, 2008 7:06 PM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g, Oracle Developer 10g Express Edition
Oracle, MySQL connectivity by HSODBC
It is probably a configuration issue. Things to check: - You have created an ODBC connection to your MySql database and you have tested it from outside Oracle, and it is working well. - Your Oracle global_names parameter is set to false (init.ora) - You have configured the hetergeneous services. (This consists of creating an [...]
View Answer
| October 27, 2008 6:32 PM
Database connectivity, HSODBC, MySQL, ORA-02063, ORA-28545, Oracle, Oracle 10g, Oracle error messages, Solaris
It is probably a configuration issue. Things to check: - You have created an ODBC connection to your MySql database and you have tested it from outside Oracle, and it is working well. - Your Oracle global_names parameter is set to false (init.ora) - You have configured the hetergeneous services. (This consists of creating an [...]
View Answer
| October 27, 2008 6:32 PM
Database connectivity, HSODBC, MySQL, ORA-02063, ORA-28545, Oracle, Oracle 10g, Oracle error messages, Solaris
Oracle Reports duplicate labels
One way could be increasing the size of the repeating frame (in the layout model) up to the size of a complete page, and then copying the field (or text field) that contains the label data the necessary times to fill the new size of the repeating frame. Regards,
View Answer
| October 24, 2008 12:00 AM
Oracle printing, Oracle Reports
One way could be increasing the size of the repeating frame (in the layout model) up to the size of a complete page, and then copying the field (or text field) that contains the label data the necessary times to fill the new size of the repeating frame. Regards,
View Answer
| October 24, 2008 12:00 AM
Oracle printing, Oracle Reports
Replace a variable part of a string in a varchar2 field
You could play with the INSTR function, which returns the position of a specified substring within a string. Usage: instr(<string>,<substring>,<starting_position>,<occurrence>) You can use this function to see the value of a specific element in the PVC_Value, for example, to see the 7th element, the following select should do the trick: <pre>select substr(pvc_value,instr(pvc_value,’;',1,6)+1,instr(pvc_value,’;',1,7)-1-instr(pvc_value,’;',1,6)) from your_table;</pre> and [...]
View Answer
| October 23, 2008 11:36 PM
Oracle PL/SQL, Oracle Table, VARCHAR
You could play with the INSTR function, which returns the position of a specified substring within a string. Usage: instr(<string>,<substring>,<starting_position>,<occurrence>) You can use this function to see the value of a specific element in the PVC_Value, for example, to see the 7th element, the following select should do the trick: <pre>select substr(pvc_value,instr(pvc_value,’;',1,6)+1,instr(pvc_value,’;',1,7)-1-instr(pvc_value,’;',1,6)) from your_table;</pre> and [...]
View Answer
| October 23, 2008 11:36 PM
Oracle PL/SQL, Oracle Table, VARCHAR
Updating Microsoft SQL Server tables from Oracle generates error
ORA-00904 means that you are using an invalid column name. It seems that no column called NAME exist in the oracle table.
View Answer
| October 22, 2008 4:59 PM
Microsoft SQL Server 2000, ORA-00904, Oracle error messages, Oracle import/export, SQL Server 2000, SQL Server import/export
ORA-00904 means that you are using an invalid column name. It seems that no column called NAME exist in the oracle table.
View Answer
| October 22, 2008 4:59 PM
Microsoft SQL Server 2000, ORA-00904, Oracle error messages, Oracle import/export, SQL Server 2000, SQL Server import/export
Oracle Forms
If you have the Forms Builder installed, you can simply go to HELP -> ABOUT FORM BUILDER. This will show separate version numbers for different components. Look for “Forms [xx bits] version…”. If you have just the runtime, you will need to right-click the runtime executable (usually called ifrunXX.exe, and usually under <oracle_home>bin), click on [...]
View Answer
| October 21, 2008 11:38 PM
Oracle Forms, Oracle Forms 6i
If you have the Forms Builder installed, you can simply go to HELP -> ABOUT FORM BUILDER. This will show separate version numbers for different components. Look for “Forms [xx bits] version…”. If you have just the runtime, you will need to right-click the runtime executable (usually called ifrunXX.exe, and usually under <oracle_home>bin), click on [...]
View Answer
| October 21, 2008 11:38 PM
Oracle Forms, Oracle Forms 6i
Want to know about Oracle Reporting
Oracle Reports is part of the Oracle Developer suite; a separate Oracle product. With database version 8i you would probably use Oracle Developer 6i, which includes Oracle Forms, Oracle Reports and Oracle Graphics.
View Answer
| October 21, 2008 5:04 PM
Oracle 8i, Oracle reporting, Oracle Reports
Oracle Reports is part of the Oracle Developer suite; a separate Oracle product. With database version 8i you would probably use Oracle Developer 6i, which includes Oracle Forms, Oracle Reports and Oracle Graphics.
View Answer
| October 21, 2008 5:04 PM
Oracle 8i, Oracle reporting, Oracle Reports
Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object
Sounds like you have created a unique constraint or unique index on the table that didn’t exist on the Oracle database, or you are trying to insert the records a second time. It could also be that the Oracle table was case sensitive, while the SQL Server defaults to case insensitive. If this is the [...]
View Answer
| October 18, 2008 6:46 PM
Oracle 9i, Oracle 9i to SQL Server 2005 Data Migration, SQL Server 2005
Sounds like you have created a unique constraint or unique index on the table that didn’t exist on the Oracle database, or you are trying to insert the records a second time. It could also be that the Oracle table was case sensitive, while the SQL Server defaults to case insensitive. If this is the [...]
View Answer
| October 18, 2008 6:46 PM
Oracle 9i, Oracle 9i to SQL Server 2005 Data Migration, SQL Server 2005
automate Oracle database backup on Windows 2000 server
What you could do is have the results of the copy be sent to a log file in a particular location so that you could have a shortcut on your desktop to that location and look at the logs. To do that, your .bat files would direct the output of the command like this: copy [...]
View Answer
| October 17, 2008 3:40 PM
Backup, Database Backup, Oracle 8i, Oracle backup, Oracle database backup and recovery, Windows 2000 Server
What you could do is have the results of the copy be sent to a log file in a particular location so that you could have a shortcut on your desktop to that location and look at the logs. To do that, your .bat files would direct the output of the command like this: copy [...]
View Answer
| October 17, 2008 3:40 PM
Backup, Database Backup, Oracle 8i, Oracle backup, Oracle database backup and recovery, Windows 2000 Server
