How to convert character report to bitmap
To convert it to pdf, you just need to set the MODE system parameter to BITMAP, and the DESFORMAT parameter to PDF. For the size, you need to change the Width and Height properties in the Paper Layout sections.
View Answer
| August 1, 2009 12:48 AM
Oracle 10g, Oracle Reports, Oracle Reports 10g
To convert it to pdf, you just need to set the MODE system parameter to BITMAP, and the DESFORMAT parameter to PDF. For the size, you need to change the Width and Height properties in the Paper Layout sections.
View Answer
| August 1, 2009 12:48 AM
Oracle 10g, Oracle Reports, Oracle Reports 10g
Best platform for this Oracle application mix
Hi, All other things being equal, Oracle has ALWAYS worked best on SUN. Another thing to consider is that Oracle (corp) says “Oracle (the db) is Oracle is Oracle” meaning that if you say “ABC…XYZ” within Oracle it will result in the same answer regardless of the hardware or OS. PART of the reason for [...]
View Answer
| July 31, 2009 6:40 PM
Oracle BI, Oracle E-Business Suite, Oracle on Linux, Oracle on Solaris, Oracle on Windows, Oracle SOA Suite, Siebel CRM
Hi, All other things being equal, Oracle has ALWAYS worked best on SUN. Another thing to consider is that Oracle (corp) says “Oracle (the db) is Oracle is Oracle” meaning that if you say “ABC…XYZ” within Oracle it will result in the same answer regardless of the hardware or OS. PART of the reason for [...]
View Answer
| July 31, 2009 6:40 PM
Oracle BI, Oracle E-Business Suite, Oracle on Linux, Oracle on Solaris, Oracle on Windows, Oracle SOA Suite, Siebel CRM
64bit client to 32bit database
Oracle 9i is pretty old. I’m not sure if there’s going to be any 64bit software for it. You’ll probably need newer 64bit drivers (10g, or 11). Once you’ve got the drivers setup then a 64bit client can talk to a 32bit server without issue. ——– Actually, there is an edition of Oracle 9i (Release [...]
View Answer
| July 30, 2009 9:27 PM
32-bit, 64-bit, Oracle 9i, Oracle Database
Oracle 9i is pretty old. I’m not sure if there’s going to be any 64bit software for it. You’ll probably need newer 64bit drivers (10g, or 11). Once you’ve got the drivers setup then a 64bit client can talk to a 32bit server without issue. ——– Actually, there is an edition of Oracle 9i (Release [...]
View Answer
| July 30, 2009 9:27 PM
32-bit, 64-bit, Oracle 9i, Oracle Database
How to implement oracle single sign-on with a legacy application
Oracle has two methods of signon … 1) users and passwrods defined to the Oracle database as in CREATE USER username IDENTIFIED BY pass_word 2) users that Oracle will allow to be authenticated by the operating system as in CREATE USER username IDENTIFIED EXTERNAL the second ones (used to) default to prefixing the userid with [...]
View Answer
| July 30, 2009 3:53 PM
Legacy applications, Oracle administration, Oracle connectivity, Single sign-on, SQLPlus
Oracle has two methods of signon … 1) users and passwrods defined to the Oracle database as in CREATE USER username IDENTIFIED BY pass_word 2) users that Oracle will allow to be authenticated by the operating system as in CREATE USER username IDENTIFIED EXTERNAL the second ones (used to) default to prefixing the userid with [...]
View Answer
| July 30, 2009 3:53 PM
Legacy applications, Oracle administration, Oracle connectivity, Single sign-on, SQLPlus
How to change Oracle hostname
Hi, I believe that you can change that in the INIT.ORA file (or its equivalent (I always have to qualify my Oracle answers because most everyone uses Oracle on a PC-type platform while I worked with it on mainframe using MVS, OS/390, z/OS and ofcourse there is no “init.ora” but we did have the equivalent)) [...]
View Answer
| July 30, 2009 3:42 PM
Oracle administration, Oracle hostname
Hi, I believe that you can change that in the INIT.ORA file (or its equivalent (I always have to qualify my Oracle answers because most everyone uses Oracle on a PC-type platform while I worked with it on mainframe using MVS, OS/390, z/OS and ofcourse there is no “init.ora” but we did have the equivalent)) [...]
View Answer
| July 30, 2009 3:42 PM
Oracle administration, Oracle hostname
Oracle table space
You don’t to remove data you must either 1) delete from a table (which makes space available for resuse but only to the table and only in the same way as it was originally used (hence index space stays index space and table space stays table space) 2) you truncate the table in which case [...]
View Answer
| July 30, 2009 4:00 AM
Oracle administration, Oracle Tablespaces
You don’t to remove data you must either 1) delete from a table (which makes space available for resuse but only to the table and only in the same way as it was originally used (hence index space stays index space and table space stays table space) 2) you truncate the table in which case [...]
View Answer
| July 30, 2009 4:00 AM
Oracle administration, Oracle Tablespaces
How to create procedure in Oracle
I will presume you already know how to write insert as select so that you can insert data from one table to another. That said, the only difficult part of your request is getting data form the excel spreadsheet. The reality is there is no simple way to do this. You must do one of: [...]
View Answer
| July 30, 2009 3:55 AM
Microsoft Excel import/export, Oracle development, Oracle import/export
I will presume you already know how to write insert as select so that you can insert data from one table to another. That said, the only difficult part of your request is getting data form the excel spreadsheet. The reality is there is no simple way to do this. You must do one of: [...]
View Answer
| July 30, 2009 3:55 AM
Microsoft Excel import/export, Oracle development, Oracle import/export
After trigger select from other tables using joins
The most likely reason your trigger is doing jack is because of this: EXCEPTION – If an exception is raised, exit gracefully WHEN OTHERS THEN NULL; Do not take this as an offence, but this is considered by the oracle community to be the stupidest piece of code anyone can write. Many people do it. [...]
View Answer
| July 30, 2009 3:47 AM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers
The most likely reason your trigger is doing jack is because of this: EXCEPTION – If an exception is raised, exit gracefully WHEN OTHERS THEN NULL; Do not take this as an offence, but this is considered by the oracle community to be the stupidest piece of code anyone can write. Many people do it. [...]
View Answer
| July 30, 2009 3:47 AM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers
ORACLE RDBMS
Oracle is widely used because 1) it is a mature database. It offers more than saveing data relationally. It has significant backup/recovery protection for example. It is in fact all those things that you do not see that make is so great. I call it mature, some people call it industrial strength but you get [...]
View Answer
| July 30, 2009 3:42 AM
Oracle
Oracle is widely used because 1) it is a mature database. It offers more than saveing data relationally. It has significant backup/recovery protection for example. It is in fact all those things that you do not see that make is so great. I call it mature, some people call it industrial strength but you get [...]
View Answer
| July 30, 2009 3:42 AM
Oracle
Oracle Privilege error
My first guess would be that the user executing the job is not the same user that you use when testing the code. Thus the job executing user does not in fact have the correct privileges. Run a test job that does nothing but raise_application_error(-20999,’user-’||user); and find out who he thinks he is when he [...]
View Answer
| July 30, 2009 3:32 AM
ORA-1031, Oracle, Oracle 10g, Oracle error messages, Oracle Permissions
My first guess would be that the user executing the job is not the same user that you use when testing the code. Thus the job executing user does not in fact have the correct privileges. Run a test job that does nothing but raise_application_error(-20999,’user-’||user); and find out who he thinks he is when he [...]
View Answer
| July 30, 2009 3:32 AM
ORA-1031, Oracle, Oracle 10g, Oracle error messages, Oracle Permissions
Database modeling question
Based on the information you have provided, I would choose the first model. It is more flexible, scalable, <b>and it is normalized</b>. Let’s talk about the second model. In the CONTEXTS table, the name column is going to refer to the context name, or the property name ? Maybe he wants to add another ‘name’ [...]
View Answer
| July 30, 2009 3:12 AM
Database, Modeling, Normalization
Based on the information you have provided, I would choose the first model. It is more flexible, scalable, <b>and it is normalized</b>. Let’s talk about the second model. In the CONTEXTS table, the name column is going to refer to the context name, or the property name ? Maybe he wants to add another ‘name’ [...]
View Answer
| July 30, 2009 3:12 AM
Database, Modeling, Normalization
Using INSTEAD OF Views in Oracle Forms 6i
by instead of trigger I presume you are refering to a database instead-of-trigger on the view. It has been some time since I have travelded this specific road withs forms, however, I seem to recall a few things are needed to make dml against a complex view with instead of triggers a reality. There should [...]
View Answer
| July 30, 2009 2:51 AM
FRM-40602, INSTEAD OF triggers, Oracle development, Oracle Forms 6i, Oracle Views
by instead of trigger I presume you are refering to a database instead-of-trigger on the view. It has been some time since I have travelded this specific road withs forms, however, I seem to recall a few things are needed to make dml against a complex view with instead of triggers a reality. There should [...]
View Answer
| July 30, 2009 2:51 AM
FRM-40602, INSTEAD OF triggers, Oracle development, Oracle Forms 6i, Oracle Views
oracle 10g forms
Have you chosen the IE compatible view option under tools?
View Answer
| July 28, 2009 5:04 PM
Oracle 10g, Oracle 10g forms
Have you chosen the IE compatible view option under tools?
View Answer
| July 28, 2009 5:04 PM
Oracle 10g, Oracle 10g forms
Oracle 6i Log in – User-name & Password
Oracle comes with 2 system admin userids; SYS & SYSTEM. At install time, the passwords are MANAGER & CHANGEONINSTALL. The “sample” userid of SCOTT (password TIGER) also has system admin privileges and should either be locked down or the overly powerful authorizations revoked. In addition, individual userids need to be established and authorizations granted to [...]
View Answer
| July 28, 2009 2:27 PM
Database Management Systems, Oracle 6i
Oracle comes with 2 system admin userids; SYS & SYSTEM. At install time, the passwords are MANAGER & CHANGEONINSTALL. The “sample” userid of SCOTT (password TIGER) also has system admin privileges and should either be locked down or the overly powerful authorizations revoked. In addition, individual userids need to be established and authorizations granted to [...]
View Answer
| July 28, 2009 2:27 PM
Database Management Systems, Oracle 6i
Oracle9i error message on installation
If you had searched, you would have found that an answer to this same question was posted on April 6th, by ITKE. The answer given was “Oracle 9i is not compatible with vista. That is why you are getting that message “
View Answer
| July 25, 2009 7:08 AM
Oracle 9i, Oracle Application Express, Oracle error messages, Oracle installation
If you had searched, you would have found that an answer to this same question was posted on April 6th, by ITKE. The answer given was “Oracle 9i is not compatible with vista. That is why you are getting that message “
View Answer
| July 25, 2009 7:08 AM
Oracle 9i, Oracle Application Express, Oracle error messages, Oracle installation
Oracle- Parsing data in a specific row into a temp table
Assuming that you want to wind up with a bunch of “rows” – each containing one “line” of text, you need to parse it in two steps. First, keep in mind that the field can contain a nearly unlimited amount of text, while the internal limit on VARCHAR and VARCHAR2 length is 32767 characters. Thus, [...]
View Answer
| July 23, 2009 4:31 PM
Oracle, Oracle Tables, Oracle Tablespaces
Assuming that you want to wind up with a bunch of “rows” – each containing one “line” of text, you need to parse it in two steps. First, keep in mind that the field can contain a nearly unlimited amount of text, while the internal limit on VARCHAR and VARCHAR2 length is 32767 characters. Thus, [...]
View Answer
| July 23, 2009 4:31 PM
Oracle, Oracle Tables, Oracle Tablespaces
paper size parameter report 6i
I’m not completely sure whether this is what you are asking, but, if you want to send the paper size to the report as a parameter, you need to use the PAGESIZE parameter, and the dimensions will be in a string of the form ‘<width> x <height>’. For example, if you are calling the report [...]
View Answer
| July 22, 2009 10:51 PM
Oracle 6i, Oracle 6i Reports Builder, Oracle Reports 6i
I’m not completely sure whether this is what you are asking, but, if you want to send the paper size to the report as a parameter, you need to use the PAGESIZE parameter, and the dimensions will be in a string of the form ‘<width> x <height>’. For example, if you are calling the report [...]
View Answer
| July 22, 2009 10:51 PM
Oracle 6i, Oracle 6i Reports Builder, Oracle Reports 6i
oracle graphics 6i: controlling the line chart
-Right-click on the chart -Click on “Axes…” -Select the “Continuous Axis” tab -Set the desired values for “Maximum” and “Minimum” -Click “Ok”
View Answer
| July 22, 2009 8:11 PM
Oracle 6i, Oracle Graphics, Oracle Graphics 6i
-Right-click on the chart -Click on “Axes…” -Select the “Continuous Axis” tab -Set the desired values for “Maximum” and “Minimum” -Click “Ok”
View Answer
| July 22, 2009 8:11 PM
Oracle 6i, Oracle Graphics, Oracle Graphics 6i
Can Oracle Forms 10g run on any web server?
Short answer is no. You will need at least Oracle Forms services. If you want to be able to run your applications on other servers (JBoss, or tomcat for example) you will need to develop using other technologies, such as Oracle ADF. Also, you can avoid the use of the Application server, by developing with [...]
View Answer
| July 22, 2009 7:30 PM
Oracle Forms, Oracle Forms 10g
Short answer is no. You will need at least Oracle Forms services. If you want to be able to run your applications on other servers (JBoss, or tomcat for example) you will need to develop using other technologies, such as Oracle ADF. Also, you can avoid the use of the Application server, by developing with [...]
View Answer
| July 22, 2009 7:30 PM
Oracle Forms, Oracle Forms 10g
About Oracle Forms & Reports
I have found a little hard to find good Oracle Developer tutorials on the web in the past, but here are some links that you might find helpful: <a href=”http://www.sba.oakland.edu/oracle/Oracle/Ora_Tutor/Forms%20Tutorial/Forms%20Tutorial/9iForms_L1.htm”>Tutorial for Oracle10g Forms / Reports</a> <a href=”http://www.oracle.com/webapps/online-help/forms/10g/state?navSetId=_&navId=0″>Oracle Forms official documentation</a> <a href=”http://download.oracle.com/docs/cd/B25016_08//doc/dl/bi/B13895_01/toc.htm”>Oracle® Reports Building Reports</a> <a href=”http://download.oracle.com/docs/cd/B25016_08//doc/dl/bi/B14364_01/toc.htm”>Oracle® Reports Tutorial</a> If you find some specific problems/doubts, [...]
View Answer
| July 22, 2009 2:20 PM
Oracle 10, Oracle Forms, Oracle Reports
I have found a little hard to find good Oracle Developer tutorials on the web in the past, but here are some links that you might find helpful: <a href=”http://www.sba.oakland.edu/oracle/Oracle/Ora_Tutor/Forms%20Tutorial/Forms%20Tutorial/9iForms_L1.htm”>Tutorial for Oracle10g Forms / Reports</a> <a href=”http://www.oracle.com/webapps/online-help/forms/10g/state?navSetId=_&navId=0″>Oracle Forms official documentation</a> <a href=”http://download.oracle.com/docs/cd/B25016_08//doc/dl/bi/B13895_01/toc.htm”>Oracle® Reports Building Reports</a> <a href=”http://download.oracle.com/docs/cd/B25016_08//doc/dl/bi/B14364_01/toc.htm”>Oracle® Reports Tutorial</a> If you find some specific problems/doubts, [...]
View Answer
| July 22, 2009 2:20 PM
Oracle 10, Oracle Forms, Oracle Reports
