DDL in PL/SQL procedure
I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.

Answer Question   |  March 11, 2009  7:13 AM
DDL, PL/SQL, PL/SQL procedure

What am I doing wrong. Please Help
An unhandled exception of type ‘Oracle.DataAccess.Client.OracleException’ occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data 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 [...]

Answer Question   |  March 10, 2009  1:45 PM
Oracle 9i, Oracle Data Access, Oracle Database, Oracle error messages

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 BI Ad-Hoc graph – Trying to have numeric value appear above bar chart columns
An Oracle BI Ad-Hoc report has been created and the data format for numeric fields is set to be Custom 999999. When the bar chart is displayed, selecting “Show Data Labels for bars” in the “Plot Area” tab of “Edit Graph”, It is placing a value such as 15.00 instead of 15. Also it will [...]

Answer Question   |  March 5, 2009  4:35 PM
Oracle BI, Oracle BI (business intelligence), Oracle Reports

Join our ITKnowledgeExchange.com LinkedIn group
We have created an ITKnowledgeExchange.com LinkedIn Group If you are a member of LinkedIn come and join the group. You will be able to continue the discussion or post questions that we will post onto the site. Thanks Sean Community Manager

Answer Question   |  November 13, 2009  4:19 PM
AS/400, CIO, Database, DataCenter, Development, Exchange 2003, Linux, Lotus Domino, Mobile, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows

How to Determine Database Access on AS/400
I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.

Answer Question   |  March 8, 2009  3:36 PM
AS/400 database, AS/400 Permissions, DB2, DB2/400, iSeries database, JD EDWARDS, JDE

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

OracleClient
I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I enter Imports System.Data.OracleClient The system did not support. Why??

Answer Question   |  March 5, 2009  8:14 PM
Oracle 10g, Oracle 10g Express, Oracle error messages, OracleClient, VB.NET, VB.NET 2003

Running a query on both SQL Server and Oracle databases
How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

Answer Question   |  March 3, 2009  7:47 PM
Oracle, Oracle queries, SQL Server databases, SQL Server Query

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

Slowdown in SQL Restore on SQL Server 2000
We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting “Restore Database”, Enterprise Manager runs remarkably slow. I’m sure we could run the restore through a [...]

Answer Question   |  February 27, 2009  4:34 PM
Enterprise Manager, SQL Enterprise Manager, SQL Restore, SQL Server 2000, SQL Server performance

How to validate user parameters in Oracle Reports 6i?
Hi! I am using Oracle reports 6i to modify a standard report. I need to add two user parameters and a field retrieved should be between them if they are not left blank. If they are left blank, then, they should not be taken into consideration. My problem is: These two parameters are included in [...]

Answer Question   |  June 12, 2011  5:00 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i User Parameters, SQL

oracle: creating unique ID in a table
Hi there, I have a huge table (hundreds of millions rows) with this structure: call_id, date, cust_id. The PK is cust_id + call_id, so call_id is unique for each cust_id. I need to update call_id to be unique in whole table and sequential when table is ordered by cust_id and date. Values can come from [...]

Answer Question   |  March 12, 2009  7:10 PM
Oracle Table, Oracle Unique ID

Oracle database and Crystal
How can I connect oracle database to Crystal XI?

Answer Question   |  March 5, 2009  2:31 PM
Connecting Oracle Database to Crystal XI, Crystal Reports XI, Oracle Database

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

Hyperion Workspace usage 9.3.1
Hi, How and where to get the detail with repect to user id, date, time of login and logout from workspace and /or planning?

Answer Question   |  February 26, 2009  11:57 AM
Hyperion Planning, Hyperion Planning 9.3.1, Hyperion Planning 9.3.1 workspace, Oracle Hyperion Planning