4 to 5 sql statements in procedures
I want to create 5 sql statements in one procedures which are performing diff tasks. can u provide the pl/sql PROC which can be include 5 sql statements.

Answer Question   |  July 1, 2009  4:26 AM
PL/SQL, PL/SQL procedure

can you replace the URL with the document name when opening an IR in workspace?
can you replace the URL with the document name when opening an IR in workspace?

Answer Question   |  June 26, 2009  1:11 PM
Hyperion Workspace, Workspace IR

MAXTRANS Recommended value
SQL*LOADER-926 ERROR recommends increasing MAXTRANS (Now 255) to a larger value… like what?

Answer Question   |  June 25, 2009  7:27 PM
MAXTRANS, SQL Loader

convert excel to oracle 9i?
how can i convert data excel to oracle 9i?

Answer Question   |  June 25, 2009  6:37 AM
Microsoft Excel, Oracle 9i, Oracle import/export

database
what is the database size for installing the oracle database in sap?and also what is the paramater for brbackup?

Answer Question   |  June 29, 2009  1:19 AM
Oracle interoperability, SAP interoperability

Oracle Privilege error
I am using Oracle 10g and does the following. Scheduling a job (procedure call) from my application. Procedure is querying synonyms of another schema and the schema is given the select privilege on all synonyms. When the procedure is executed directly, it works fine. But when scheduled as a job , the querying of synonyms [...]

Answer Question   |  July 30, 2009  2:39 PM
ORA-1031, Oracle, Oracle 10g, Oracle error messages, Oracle Permissions

I am not getting source of oracle.I searched a lot but was not able to get it from anywhere.Plz help me.
And also what’s the difference between oracle9i/10g/11g. Or if not wrong they are different versions only

Answer Question   |  June 25, 2009  1:19 PM
Oracle 10g, Oracle 11g, Oracle 9i, Oracle Database

Error ORA 06550
Hi.. I am Planning to make email automation . mail should have attachment. Attachment is the result of query execution in oracle database .I am getting error ORA 06550 and PLS 00013.Can u help me solve this glitch..Here I Put My PACKAGE.. create table config2 ( TO_ADDRESS VARCHAR2(1000), SMTP_SERVER VARCHAR2(1000), FROM_ADDRESS VARCHAR2(1000), EMAIL_SUBJECT VARCHAR2(1000), EMAIL_TEXT [...]

Answer Question   |  June 29, 2009  9:28 AM
ORA-06550, Oracle error messages, PLS-00013

I found FRM-92101 in oracle application server. Please help me to resolve this problem
We are having 10 As middle tier Whenever we open the form always found the erro FRM-92101

Answer Question   |  July 28, 2010  11:58 AM
FRM-92101, FRM-ERROR, Oracle 10g error messages

cannot print report
hp compaq dx2300 cannot print report 6i using adobe reader. other systems in the same office can print reports

Answer Question   |  June 23, 2009  8:31 AM
HP Compaq dx2300, Oracle Reports 6i

ORACLE RDBMS
reasons why oracle rdbms is widely used world wide and in most government ageencies?

Answer Question   |  July 30, 2009  8:55 AM
Oracle

Would you go with iSCSI or Fibre Channel for mass storage in this case?
Is there any TPS benchmarking available in deciding whether to go for Fibre channel or iSCSI? We are using Oracle database which requires a Terabyte of storage and will be operating at the 1000TPS at peak level. In this case – should we go for iSCSI or Fibre Channel as the mass storage device? Thank [...]

Answer Question   |  June 23, 2009  3:19 PM
Fibre channel, iSCSI, Oracle Benchmark Testing, Storage Channel, Storage management, Transactions Per Second

SSRS 2008 – Connection to Oracle 10g seems to be timing out
I’m running SSRS 2008 via Visual Studio on my desktop. The data source for my report is an Oracle 10g database. The report runs fine when the parameters are set to limit the number of rows returned, but when I change them to return more data it eventually times out. The same query runs in [...]

Answer Question   |  June 17, 2009  9:13 PM
Connection timeout, Oracle 10g, Oracle 10g connectivity, SQL Server Reporting Services, SSRS 2008

differences between features of jde one world & jdenterprise 8.12
wat are the new feature of jde 8.12 and what are the advancements that it has over jde one world

Answer Question   |  June 16, 2009  12:06 PM
JDE, JDE 8.12, JDE One World

Problem running Oracle Forms 10g in browser
I am unable to run the form in the browser I have set the run time preferences

Answer Question   |  December 7, 2009  11:43 AM
Oracle 10g, Oracle Forms 10g

ORA-01031 Insufficient privileges
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

Answer Question   |  June 16, 2009  6:51 AM
Foreign keys, ORA-01031, Oracle development, Oracle error messages, Oracle foreign keys, Oracle primary keys, Primary keys

Managing Failed Lots in JDE E1 8.12 QA Module
If you have any tips to get the most from this module for new users, whether it’s configuration/setup advice, or using “vanilla” functionality to manage a complex quality program, please advise. One specific question we have is this: Should you release lots using the “Manage Failed Lot” functionality, or if a lot goes on hold [...]

Answer Question   |  June 15, 2009  8:46 PM
JD EDWARDS, JD Edwards EnterpriseOne, JDE, JDE E1 8.12, Quality assurance, Quality assurance testers, Quality assurance testing, Quality control

Storing image in Oracle 9i
how to store and retrieve image having size more than 1 GB in oracle 9i

Answer Question   |  June 15, 2009  11:30 AM
BLOB, Oracle 9i, Oracle image storage

oracle initialization or shutdown in progress
When I am trying to connect System/system User id and password it is showing error message: Oracle initialization or shutdown in progress. What is the solution ?

Answer Question   |  June 13, 2009  4:00 AM
oracle initialization or shutdown in progress

SAP basics
We are running Retail Chain outlets in different locations …presently we are using Oracle based ERP solution for POS , Inventory and Financials. Want to switch over to SAP .. what things should i consider before opting for SAP. What the requirements in the form Hardware and software ( to handle POS , Payroll etc.,) [...]

Answer Question   |  June 12, 2009  6:44 PM
Oracle to SAP, SAP ERP, SAP implementation, SAP installation