I'd like to be able to take a ref cursor and transform it by selecting from it into another ref cursor. For example, something like this: begin declare c_cur sys_refcursor; c_cur2 sys_refcursor; open c_cur for select 1 from dual; open c_cur2 for select 1 from c_cur where 1 = 2; end; / Is it possible in Oracle to...
We are having trouble executing scripts that begin with BEGIN and are having multiple procedures or triggers with the aforementioned provider. Execution of those fails. Has anyone eperienced similiar problems? ...
In medium to large organizations what team or group typically support middle tier components like Oracle Application Servers? (Unix Team, DBA Team, Or Application Development/Support Team) In a client server application design the delineation of ownership between the server and the client is very clear. In the client server case the U...
We have oracle 10g running on windows server 2003. A machine which runs an application using that database has as of a few weeks ago suddenly started having connectivity problems. Today we ran the automatic updates for windows server and the problem has only gotten worse. I realize this isn't enough information for anyone to diagnose ...
I have a client that would like us to import data from Oracle into an existing Primavera Project Management system. I know Oracle and it's import/export capabilities, but I have no clue about Primavera. Neither does my client. I have tried to look up this info through the Primavera support site, but it requires a site ID just to searc...
I have a C# service written for .NET 2.0 that uses the Oracle data access provider for .NET 2.102.2.20. The service runs multiple threads and runs lots of queries to an Oracle 9.2 database. I am using NHibernate. What I am seeing is that when it starts up it runs fast, then gets slower and slower. The CPU usage starts low then goes up a...
What are the most reasonable ways to move table data from SQL Server to Oracle (on *nix) on a regular basis? ...
I am working with a team that develops an application which works on SQL Server and Oracle. SQL Server has the concept of an instance, which can house multiple databases. Oracle 10g requires one instance per database (and can allow more for redundancy), so for each database we run, we have a completely separate set of processes, and th...
I have a set of Oracle tables that describe information about property owners. Owner names and other text values are stored in multiple fields in multiple related tables, for each owner. I would like to index the contents of these fields. My goal is to provide a single field where a user can enter keywords to locate owners. How do I set...
Hi, I have to create a entire application in an Oracle RDBMS with SQL. The Design includes to complete full entity-relationship and also design the relevant Schema with object creations.Important is-When creating schema and objects..we should fully apply normalisation. Also, writing all the relevant SQLs in each and every step in this p...
Is there any feature of asynchronous calling in PL/SQL? Suppose I am in a block of code would like to call a procedure multiple times and wouldn't bother when and what the procedure returns? BEGIN myProc(1,100); myProc(101,200); myProc(201,300); ... ... END; In the above case, I don't want my code to wait for myProc(1,100) ...
I am investigating the possibility of updating our application to work with database servers other than Firebird. We rely on "STARTING WITH" for accessing our hierarchical data. Without it, I don't see how we can migrate to another database without some serious redesign. If you are not familiar with STARTS WITH, it simply checks to see ...
I have two instances of Oracle Application Server (OAS) clustered together and replicating sessions. Whenever I terminate one of the instances by killing the process, the other instance picks up and contains the session. Everything works as expected. If I gracefully shutdown one instance (using opmn stopall) of OAS, HttpSessionDestroyedE...
Hi, I have an SSRS report , Oracle is my backend and am using this following query for dataset of my second parameter. select distinct X from v_stf_sec_user_staffing_center usc where usc.center_group_id in ( select distinct center_group_id from V_T_STAFFING_CENTER_GROUP scg where INSTR(','||REPLACE(:PI_REGION_LIST,' ')||',', ','|...
We use Oracle wallet for scripting Oracle releases. Using mkstore I can add or delete private keys to Oracle wallet. Either using Java or C#, I want to read the private key sitting inside the Oracle wallet. Could someone share the sample code how to do that. This post explains how to open a wallet using Java, but it does not read the...
When adding a column to an existing table, Oracle always puts the column at the end of the table. Is it possible to tell Oracle where it should appear in the table? If so, how? ...
Obviously if I am using JDBC/ODBC, I can use bind variables and prepared statements to prevent SQL injection. However, when data is passed to batch processes that end up invoking Oracle SQLPlus, is there a way to prevent SQL injection? For example: query.sql: select '&1' from dual; exit; If I call this script from SQLPlus thusly: $ ...
table name:id col1:owner-name col2:book-id1 col3:book-id2 table name:book-name col1:id col2:name Can anyone get me a query to get following result owner-name,book1-name,book2-name using above 2 table ...
I have Oracle9i Release 2 ODAC installed and we are migrating from Microsoft .NET Data Provider for Oracle. We have some SqlCommand caching implemented, that uses System.Data.SqlCommandBuilder.DeriveParameters(result) (var result is type of SqlCommand), but there is no DeriveParameters() method until ODP.NET version 10. Perhaps anyone ...
Hi, I have a web application where I am getting data from an oracle database in a gridview. Can anyone tell me how to turn this data into links to other pages on my web application? For example, if I am getting data about a list of objects that have their own ID, I want to be able to click the ID and go to a page with information on ...