Find out what is in dbms_sql cursor
I am trying to put in a 5500 character query into dynamic sql, and then use the Oracle dbms_sql function to execute the sql. However, there is an error in the sql statement that is being generated, but the error message doesn’t help me identify where the error is, as it pertains to the dynamic [...]

Answer Question   |  February 25, 2009  5:54 PM
DBMS, DBMS_SQL, Dynamic SQL, Oracle

Will SAP CRM add to Oracle CRM functional profile
I was working as Oracle CRM consultant a month back with 2.5 years CRM experience. I have very good knowlwdge & experience of Oracle CRM service modules like Contracts, Field Service, TeleService, Install Base etc. This economic downturn has pushed me out of job. My question is will it be helpful if I go for [...]

Answer Question   |  February 25, 2009  8:35 AM
Career development, IT careers, IT Job Market, Oracle CRM, Oracle Customer Relationship Management, SAP careers, SAP CRM, SAP Customer Relationship Management

Oracle v$ view that dynamically has the names of procedures
Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?

Answer Question   |  February 25, 2009  7:41 AM
Oracle administration, Oracle v$ Views, Oracle Views

Oracle database experience
How I can get oracle database experience without joining any firm or institution. Would anybody comment please?

Answer Question   |  February 7, 2011  9:08 AM
Oracle 10g Express, Oracle DBA, Oracle experience, Oracle training

JD Edwards screen travel
I have a user that is trying to travel between screens using JD Edwards. When she enters a new screen name on one screen, she gets the error: Security Violation. Any idea how to get this to work?

Answer Question   |  March 24, 2009  8:18 PM
JD EDWARDS, JD Edwards Error Messages, JD Edwards Security, JDE

Free Oracle Assessment Exams
Can someone tell me where I can find free Oracle Assessment exams in preparation for Oracle certifications?

Answer Question   |  February 23, 2009  6:36 PM
Oracle Assessment Exam, Oracle certifications, Oracle training and certification

Finding the number of rows of all tables of a user/schema in Oracle
how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ……

Answer Question   |  February 23, 2009  7:16 PM
Oracle 9i, Oracle SQL, ROWCOUNT statement, SQL, SQL queries

New member – Oracle questions?
I m new to this site but open to answer all the questions from the members related to oracle 10g.

Answer Question   |  February 23, 2009  8:25 AM
ITKE, Oracle

SQL query and Oracle database design help needed
Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the [...]

Answer Question   |  February 23, 2009  6:22 AM
Database design, Oracle development, Oracle SQL, SQL, SQL queries

java.lang.NoClassDefFoundError
Hi, I need some serious help here..I use OAS 10.1.2.0.2.. I deployed my ear file to the OC4J container. And everytime I access the webpage I get this error. 500 Internal Server Error java.lang.ExceptionInInitializerError at com.experio.common.util.AppUtil.getInitialContext(AppUtil.java:71) at com.experio.common.util.AppUtil.createEJB(AppUtil.java:199) at com.experio.common.util.AppUtil.createEJB(AppUtil.java:156) at com.experio.common.util.Debug.println(Debug.java:64) at com.experio.web.control.Entry.service(Entry.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:824) [...]

Answer Question   |  November 9, 2012  11:40 PM
Java development, JDeveloper, Oracle 10, Oracle Application Server, Oracle development, Oracle JDeveloper, Web development

Oracle Form Use As Web Page
I am a Oracle Form Developer 6i . I want to Apply My Oracle Form As Web Page. smply I want open my form through internet (as web-page)

Answer Question   |  February 27, 2009  7:55 AM
Oracle Developer 6i, Oracle development, Oracle Forms 6i, Oracle Forms Services

ProC under Oracle 10g
Hi! I have a piece of code in Pro-C that’s been running under Oracle 9i for several years. I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty [...]

Answer Question   |  February 26, 2009  2:31 PM
Oracle 10g, Oracle 9i, ProC, SQLPlus

What are the advantages of Hyperion Planning?
what is the purpose of this planning, What are the main advantages in this, why customers are looking in to it?

Answer Question   |  February 19, 2009  7:23 AM
Hyperion Planning, Oracle Hyperion Planning

Formatting PL/SQL code in SQL Developer
Hi experts, I would like to know some keyboard shortcuts and clever formatting on PL/SQL codes in SQL Developer. Please help me out with some hints for this. Thanks in advance.

Answer Question   |  April 18, 2013  5:49 AM
Oracle PL/SQL, Oracle SQL Developer, PL/SQL, PL/SQL block

Oracle Reports 6i – Convert data in Microsoft Excel
HOW TO CONVERT ORACLE REPORTS 6i DATA INTO MICROSOFT EXCEL THROUGH CODING ON BUTTON?

Answer Question   |  December 20, 2010  9:46 AM
Microsoft Excel, Oracle, Oracle import/export, Oracle Reports 6i, Oracle Reports 6i to Excel

Inserting 50000 rows using FORALL statement
How can we insert 50000 rows by using FORALL,please give me entire code?

Answer Question   |  February 18, 2009  5:48 AM
FORALL statement, Oracle development, Oracle SQL, PL/SQL, SQL

Where are Oracle Anonymous Blocks stored?
Where the anonymous blocks are stored?

Answer Question   |  February 18, 2009  5:46 AM
Oracle Anonymous Blocks, Oracle development

PL/SQL
Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it [...]

Answer Question   |  February 20, 2009  10:47 AM
INSERT statement, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL block, SQL, SQL Timestamp, Timestamp, UPDATE statement

Oracle SQL-Pagination Help
Hi, The below inner SELECT returns huge amount of rows (1000000+) and the outer SELECTs(alpha BETWEEN #startRec# AND #endRec#) is used for PAGINATION to display data with 25 in each page. Issue is:-This PAGINATION done below is very slow and slows the entire display of data.So could all please help me on doing this below [...]

Answer Question   |  January 2, 2010  4:24 PM
Oracle SQL, Oracle SQL Pagination, Pagination, SELECT statement

Microsoft Excel report generation from Oracle Forms 10g
what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

Answer Question   |  November 25, 2010  5:54 AM
Microsoft Excel, Oracle Forms & Reports Developer 10g, Oracle Forms 10g, Oracle interoperability, Oracle reporting