Oracle reports
Download <a href=”http://www.oracle.com/technology/products/forms/pdf/10g/frm10gsrw10g.pdf”>this Oracle White Paper</a>. You will find what you need and more. <a href=”http://www.oracle.com/technology/products/forms/pdf/10g/frmrepparamform.pdf”>Here </a>you can download another white paper which focus specifically in the Run_report_object function. Hope this helps.

View Answer   |  September 30, 2008  2:48 PM
Developer 2000, Oracle 10g, Oracle Reports

Oracle driver
Yes it will. If you have a 32bit application which connects to an Oracle database you will need the 32bit Oracle driver. If you have a 64bit application which connects to an Oracle database you will need the 64bit Oracle driver.

View Answer   |  September 28, 2008  6:58 AM
64-bit processors, Database, Oracle drivers

How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?
In your code you need to close the connection, and set the connection to nothing. This should cause the database connection to close and the connection to drop.

View Answer   |  September 28, 2008  6:10 AM
Database connectivity, IIS, Oracle 10g, Oracle 9i, VB, Visual Basic, Visual Basic 6, w3wp.exe, Windows Server 2003

Oracle Data Dictionary location
You need to query the data from ALL_TABLES instead of user_tables. Something like this: <pre>select table_name from ALL_TABLES where table_name like ‘TMP%’; </pre> Regards,

View Answer   |  September 26, 2008  7:41 PM
Oracle Data Dictionary

CRM on demand versus on premises solutions?
Since “On-demand” refers to services/applications that usually reside on a server at a remote site, I think that if integration is an important factor, the best choice could be an on-premises solution, but some other factors need to be taken into consideration, such as time of implementation (which is usually bigger with a on-premise solution), [...]

View Answer   |  September 26, 2008  7:31 PM
CRM integration, CRM on demand, ERP, Oracle, SAP

Oracle Named User licenses required for load testing
Any individual or device (and I think sofware, as in your case) that is going to access Oracle software is counted as a named user (or named user plus), so I think you should not create more virtual users than the numer of named users the license allows. Here is the description of a named [...]

View Answer   |  September 26, 2008  5:59 PM
Load testing tools, LoadRunner, Oracle licensing

Replication manager
This <a href=”http://download-uk.oracle.com/docs/cd/A87860_01/doc/server.817/a76959/reprepma.htm”>Site </a>explains how to use the replication manager and it supplies a few ways to start the application. Good Luck! -Flame **********************************************

View Answer   |  September 25, 2008  10:03 PM
Oracle 8i, Oracle replication

Table replication
Could you please be a little more specific on your question ? Do you want to replicate (and please specify what exactly you mean with this) a table in the same database ? Regards, ******************************************************* This <a href=”http://www.remote-dba.net/tp_table_replication_Oracle_snapshots.htm”>Site</a> describes how to use “snapshots” to replicate tables (these tables are read only though). This <a href=”http://www.orafaq.com/faqrepl.htm”>FAQ</a> [...]

View Answer   |  September 25, 2008  9:42 PM
Oracle 10g

Not Return Any Record if Value Exists
You could use a query like this: <pre>select * from table_x where f1 not in (select f1 from table_x where f2 = 3);</pre> Regards,

View Answer   |  September 24, 2008  9:04 PM
Oracle, Oracle SQL, SQL

PL/SQL – select data – group by- having?
You want to use a basic WHERE clause <pre>SELECT DISTINCT Name FROM YourTable WHERE Value IN (‘a’, ‘b’)</pre>

View Answer   |  September 24, 2008  8:47 PM
PL/SQL

reports erver in oracle 10g
Take a look at <a href=”http://www.oraclebrains.com/?p=102″>this article</a> on how to create a new report server instance, it may help you. <a href=”http://www.dbasupport.com/oracle/ora10g/deploying_reports.shtml”>This other article</a> shows how to deploy on the web, and <a href=”http://www.oraclebrains.com/?p=155″>this one</a> shows how to remove a reports server in middle tier. Hope this helps.

View Answer   |  September 24, 2008  7:31 PM
Oracle 10g, Report Server

IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’
I think an exact match for the STATIC modifier does not exist in pl/sql (because in C it can be applied even to functions or class members and each can be affected in a different way) , but you can achieve something similar usging the ‘CONSTANT’ keyword. Example: <pre>v_time_constant constant varchar2(8) := to_char(sysdate,’hh24:mi:ss’);</pre> If you [...]

View Answer   |  September 24, 2008  2:00 PM
Oracle Application Server, Oracle database replication software, Oracle developers, Oracle development, PL/SQL

How to insert/delete/update data into VIEW using forms 6i
You can insert/delete/update data in a view the same way you do with a table, but remember there are some restrictions when doing these operations on join views (for example: you cannot modify more than one base table, you cannot modify a column which maps to a non key-preserved table, you cannot delete from a [...]

View Answer   |  September 23, 2008  4:21 PM
Forms 6i, Oracle development, Oracle Forms

how i will find the duplicate rows count from employee table in oracle9i.
You could use a select statement like the following, to find out what employees exist more than once: <pre>select emp_id, count(*) from employee group by emp_id having count(*) > 1;</pre> If you want to count the duplicate employees, you could do something like: <pre>select count(*) from ( select emp_id, count(*) from employee group by emp_id [...]

View Answer   |  September 23, 2008  9:02 AM
Oracle 9i

Error when using Microsoft OLE DB for Oracle in DTS Package
When you run the job manually are you doing it on the servers console or on your workstation? Can you use the Oracle tools to connect to the Oracle server manually? Microsoft KB Article <a href=”http://support.microsoft.com/kb/255084″>255084</a> should help you out.

View Answer   |  September 20, 2008  11:01 PM
DTS Package Scheduled Task, Oracle

backup and recovery
While there are tools to convert one DB structure to another, The difficulty of doing so, or even the possibility of being able to do it at all would depend on both the version and type of DB software you are working with. <test> Good Luck *********************************************************************************

View Answer   |  September 18, 2008  3:08 PM
Backup & recovery, Database backup and recovery, Database migration, Oracle import/export

SQL Plus
I’m not sure if the code you pasted here is the ‘old’ query, which was working, or it is the new one, which fails. I think it could be useful to know the complete error message (which always contains the line number in which the error was detected).

View Answer   |  September 16, 2008  11:26 PM
SQLPlus, Subquery

Oracle Reference to Table_Name, Column_Name, etc by reference to variable
You could use a SELECT from ALL_TAB_COLUMNS instead of a DESCRIBE. For example, a cursor based on the following select: <pre>select column_name,data_type,data_length,data_precision,nullable from all_Tab_columns where table_name = v_tablename;</pre>

View Answer   |  September 16, 2008  10:05 PM
Oracle, Oracle 8i, Oracle development, SQL

constraints
I’m not sure if I understand correctly, but the all_constraints table can be used to get the table relations. This is an example query: <pre>select ac.constraint_name,ac.table_name child_table,ac2.table_name parent_table from all_constraints ac,all_constraints ac2 where ac.r_constraint_name = ac2.constraint_name;</pre>

View Answer   |  September 16, 2008  9:57 PM
Oracle

how can i update ?
ORA-0001 means that an update or insert statement attempted to insert a duplicate key. In other words, the data you were trying to enter, violates a primary key or unique index.

View Answer   |  September 16, 2008  9:45 PM
Oracle developers, Oracle error messages