iSQLPlus creating packages with multiple procedures in it
Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don’t work and i get the error package created with complication errors, however when i type [...]

Answer Question   |  December 19, 2011  5:24 PM
iSQL*Plus, Oracle development, Oracle SQL, SQLPlus

Oracle Forms 6i Database Objects
I have problem that Forms 6i does not see packages stored on Database with Dynamic SQL code on it. When I open Forms Designer it does see Database Objects at the bottom but with running the forms it gives and error that does see sys. dba_sql. Thank you

Answer Question   |  March 9, 2009  9:31 AM
Dynamic SQL, Oracle Designer, Oracle development, Oracle Forms 6i, Oracle SQL, SQL

Connectivity of Visual Basic 6 and Oracle 10g
Can u plzzz sugest me the code of how to connect Visual Basic6 and oracle 10g, I am facing problems while connecting. Plzz do reply at ur earliest. -Supriya

Answer Question   |  April 10, 2012  4:57 PM
Database connectivity, Oracle 10g, Oracle connectivity, Oracle development, VB 6, Visual Basic 6

.NET connecting to Oracle 9i
Please Help. I am new to .Net. Using .Net 2003 Oracle 9i Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _ OracleConnection(“User Id=system;Password=dax856;Data Source=DMS”) Dim objDataAdapter As New OracleDataAdapter Dim objDataSet As DataSet = New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ‘ Set [...]

Answer Question   |  March 9, 2009  12:57 AM
.NET, .NET development, Oracle 9i, Oracle 9i Enterprise Edition 9.2.0.7.0, Oracle connectivity, Oracle development, Visual Studio 2003

Developing standalone Apps with Oracle Developer 10g
hai, i am new to oracle 10g development. can i build an application using oracle forms developer 10g and run it without deploying in the application server.(i.e without using oracle 10g Application Server) thanks np

Answer Question   |  March 6, 2009  8:26 AM
Oracle 10g, Oracle applications, Oracle development, Oracle Forms, Oracle Forms & Reports Developer 10g, Oracle Forms 10g

Oracle Request Set Run Time Log File Posting
Hi Everyone, I am currently using the put_line to write information to the log file in Oracle. I don’t get to see what is in the log file until the job finishes running. I would like to write to the log file and have the information available while the job is progressing (running) at any [...]

Answer Question   |  March 5, 2009  3:25 PM
Oracle development, Oracle Log File

Hiding a stacked canvas in Oracle 9i
how to hide the stacked cancas using a code in the oracle9i? i call the stacked using the form so the problem now is what code am i going to use to hide it in runtime! so that the user input will be on the content canvas and the stacked canvas will not be visible [...]

Answer Question   |  March 12, 2009  4:55 PM
Oracle 9i, Oracle 9i Canvas, Oracle development, Oracle Forms Canvas, Stacked Canvas

Looping Queries in Oracle using data from SQL Server
I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = ’0′ CONNECT BY PRIOR a.parentid = a.sid’ Where I have ’0′ in the query above, should take all the values from PID. Is there a easy way [...]

Answer Question   |  March 2, 2009  4:05 PM
Oracle development, Oracle queries, SQL, SQL queries, SQL Server connectivity

Default Types in Oracle Parameter Screen
I am adding my default parameters to my stage. In the default type drop down box I see Constant, Current Date, Current Time, Field, Profile, SQL Statement and Segment. I know what most of them mean but have questions on Field, Profile and Segment. I have tried searching the web for answers but came up [...]

Answer Question   |  February 12, 2011  12:59 PM
Oracle default parameters, Oracle developers, Oracle development

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

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

Errors in Creating Oracle packages
Can anybody plz find out the error in the following code?? plz reply back. SQL> CREATE OR REPLACE package body PKG_IMAGEM1 2 as 3 PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, 4 P_College IN VARCHAR2, 5 P_CourseCat in varchar2, 6 P_CourseName in varchar2, 7 P_StudentName in varchar2, 8 P_ID in varchar2, 9 P_FileName in varchar2, 10 P_IMG IN [...]

Answer Question   |  February 9, 2009  1:04 PM
Creating Oracle packages, Oracle development, Oracle Package, Oracle SQL

PL/SQL – Attribute to test not null and can take specific value instead
Hi Experts, How can we make a check on an attribute not null but can take – rather I have address 3 which can’t take null instead – would be fine how this can be check n PL/SQL procedure

Answer Question   |  February 9, 2009  11:13 AM
NOT NULL, NULL, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL procedure

Oracle vs Java programming
Which is better Oracle or Java? I have a interest in programming. What should I learn?

Answer Question   |  September 17, 2011  7:33 PM
IT career planning, IT careers, Java developers, Oracle development, Programming Careers

PL/SQL error
Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

Answer Question   |  February 9, 2009  8:32 AM
ORA-08102, Oracle development, Oracle error messages, PL/SQL, PL/SQL error messages

Need help creating a specific Oracle View
We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would prefer not to [...]

Answer Question   |  February 3, 2009  4:02 PM
Oracle development, Oracle Nested Tables, Oracle Views, VARCHAR