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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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 the anonymous blocks are stored?
Answer Question | February 18, 2009 5:46 AM
Oracle Anonymous Blocks, Oracle development
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
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
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