WebUtil client_ole2 commands in Oracle Forms 10g
I want to attach a sheet from an excel 2007 datasource to a word 2007 mailmerge using webutil client_ole2 commands in oracle forms 10g

Answer Question   |  June 12, 2009  10:09 AM
Mailmerge, Microsoft Excel 2007, Microsoft Word 2007, Oracle Forms 10g, WebUtil

Oracle Forms 6i and Reports 6i
i get an error message when i call a report6i from a form6i, plz tell me the whole code with description, and plz also send me an ebook related to form6i and report 6i

Answer Question   |  June 13, 2009  6:30 AM
Oracle error messages, Oracle Forms 6i, Oracle Forms and Reports 6i, Oracle Reports 6i

i want to restore data from one as400 server to another.
we have an AS400 server with JDE A7.3 installed on it, know we want to move data from this server to another AS400 server which dont have JDE A 7.3 .so first we need to install JDE A7.3 on it and then upload data with the help of tape.but i want to know the process [...]

Answer Question   |  June 12, 2009  5:25 PM
AS/400 Server, JDE, JDE 7.3, JDE A7.3

Oracle PL/SQL Toad for Oracle-How to make editor generate a script for tables,views,packages so that the script can be searched
Hello, I am using “Toad for Oracle” and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to [...]

Answer Question   |  July 21, 2009  7:40 PM
Oracle, Oracle PL/SQL, PL/SQL, TOAD

Errors Registering Recovery Catalog in 10g Grid
I have a 2 node RAC environment that I am trying to catalog in a database that is not part of the RAC instances, but is a tablespace in the Oracle Grid control database. This is a testing environment so my configuration may not be the most secure, but the production environment will have a [...]

Answer Question   |  June 10, 2009  6:33 PM
Oracle 10g, Oracle Database, Oracle Database 10g, Oracle Enterprise Manager, Oracle Recovery Catalog, Oracle Recovery Manager, RMAN

JDe world invalid password error
Has anyone encountered and solved a software password invalid error iin JDE 7.3 world environment?

Answer Question   |  June 9, 2009  4:34 PM
JDE, JDE 7.3, JDE Error Messages

How to determine the number of concurrent processes in Oracle 10g
How can I find out the number of concurrent processes at any point of time in 10g database

Answer Question   |  June 9, 2009  10:50 AM
Benchmarking oracle db, Oracle 10g, Oracle 10g administration, Oracle 10g concurrent processes, Oracle 10g performance, Oracle performance

Oracle Form: export to Microsoft Excel
I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.

Answer Question   |  April 1, 2012  6:22 AM
Excel import/export, Microsoft Excel, Oracle, Oracle Forms, Oracle Forms 10g, Oracle import/export

How to pass parameters from Oracle Form to Oracle Report?
how we can run oracle repoert from Oracle form and passing parameters from form to oracle report by Clicking Button

Answer Question   |  July 15, 2011  7:24 AM
Oracle administration, Oracle Forms, Oracle Reports

Oracle SP syntax issues
We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can’t seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are [...]

Answer Question   |  June 5, 2009  2:42 PM
Oracle, Oracle stored procedures, SQL Server, Syntax errors

Send alert via email/SMS with Oracle 9i & Oracle Forms 6i
Hi! I am using an application ,form6 as front end and oracle9i as back end. I want to sent alerts to the superiors as automail when certain data reaches the thresh hold and sent sms using certain service provider API ,to customer when certain condition is satisfied in the database. Kindly guide me how I [...]

Answer Question   |  October 24, 2009  7:45 AM
Oracle 9i, Oracle alerts, Oracle Forms 6i

How to work with JavaBeans in Oracle Forms 10g
I’ve downloaded “First Bean” Demo but i dont understand how to use/implement it. I dont know much about Java Programming.In Forms 10g, when i draw a bean and give “oracle.forms.demo.canvasproperty” in Implemantation Class property of bean, an error occurs FRM-13008: Cannot find java bean with name oracle.forms.demo…. Please help.

Answer Question   |  March 16, 2010  10:51 AM
FRM-13008, Java, JavaBeans, Oracle 10g, Oracle 10g error messages, Oracle Forms 10g

Executing Oracle stored procedure from SQL server
Using a linked server I can’t seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider “MSDAORA” for linked server “PASSRPT” returned message “Syntax error in {resultset…} ODBC Escape.”. Do I need [...]

Answer Question   |  June 4, 2009  7:42 PM
Oracle, Oracle stored procedures, SQL Server

How many statutory charts can be linked to a primary operational chart?
We have a situation where we would like to establish a common operational chart for all countries. However, each country, and even each product line within a country, may have its own statutory chart. Can we map multiple statutory charts (and even multiple accounts within each chart) to a single operational chart?

Answer Question   |  May 27, 2009  3:52 PM
GL, SAP FICO, SAP FICO Primary Operational Charts, SAP FICO Statutory Charts

Connectivity between Oracle BI Publisher and Microsoft Access
I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

Answer Question   |  May 27, 2009  11:52 AM
Database connectivity, JDBC, Microsoft Access, OBIEE, Oracle BI Publisher, Oracle Business Intelligence

Oracle RR Date Format
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)

Answer Question   |  August 9, 2011  8:43 AM
Oracle 9i, Oracle RR date format, SQL

How to install Oracle Developer 2000 on Windows XP client
i use xp as os.i installed oracle 9.0.1.4 version. can i install on this pc d2k2000 ?.

Answer Question   |  November 6, 2009  9:15 AM
Developer 2000, Oracle Developer Suite, Oracle installation, Windows XP

SQL error
DECLARE BEGIN FOR C1 IN (SELECT A.BANK,A.BRANCH,A.MODULE,A.SCHEME,A.ACCOUNTNO,A.ACCOUNTISN,NVL(T.NEXTDUEDATE,:TDATE) NEXTDUEDATE,A.REVIEWDATE FROM ACCOUNTMASTER A,TERMLOANSDATA T WHERE A.BANK=:INPBANK AND A.BRANCH=DECODE(:INPBRANCH,’ALL’,A.BRANCH,:INPBRANCH) AND A.MODULE=:INPMODULE AND A.SCHEME=DECODE(:INPSCHEME,’ALL’,A.SCHEME,:INPSCHEME) AND A.ACCOUNTNO=DECODE(:INPACCOUNTNO,’ALL’,A.ACCOUNTNO,:INPACCOUNTNO) AND T.BANK=A.BANK AND T.BRANCH=A.BRANCH AND T.MODULE=A.MODULE AND T.SCHEME=A.SCHEME AND T.ACCOUNTNO=A.ACCOUNTNO AND T.ACCOUNTISN=A.ACCOUNTISN) loop while c1.NEXTDUEDATE<=c1.REVIEWDATE c1.NEXTDUEDATE:=add_months(c1.NEXTDUEDATE,1) dbms_output.put_line(c1.BANK||’ ‘||c1.BRANCH||’ ‘||c1.MODULE||’ ‘||c1.SCHEME||’ ‘||c1.ACCOUNTNO||’ ‘||c1.ACCOUNTISN||’ ‘||c1.NEXTDUEDATE||’ ‘||c1.REVIEWDATE); end loop; END; ORA-06550: line 16, column 1: PLS-00103: [...]

Answer Question   |  May 28, 2009  5:49 AM
ORA-06550, Oracle error messages, SQL

Delphi application freezing on search
We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.

Answer Question   |  May 26, 2009  9:56 AM
Delphi 5.0, Oracle development, TAdvStringGrid

Oracle installation and migration between versions in Linux
Hi Experts, I need some useful doc links or step by step procedure to perform oracle installation and migration in Linux environment I surfed thru net ,cud not find any good docs or pdf on this As i am new to explore this role,can any one provide me some useful related links

Answer Question   |  June 9, 2009  9:31 AM
Linux databases, Oracle administration, Oracle installation, Oracle migration, Oracle on Linux