Hello experts, I've been working on this for the past few days and I can't find my way out of it. I have a C# web application that needs to print reports on screen. This same application calls a stored procedure on the database (Oracle) and it returns a cursor. Here is the procedure PROCEDURE report_total(beginDate IN DATE, endDate IN D...
Hello I've got a problem accessing Oracle DB from our datacenter through a tunnel. We've got a pretty standard datacenter with one machine being accessible from the outside (I put it's IP in the /etc/hosts file as dc) and the Oracle DB inside. The IP address of our oracle database on internal network is 192.168.1.7 To create a tunnel I...
Hello lads and ladies, I'm a bit freaked about what I just read. I did some research, as I want to start programming in Java, and I came to the conclusion that NetBeans is the best IDE for me because of its capable Swing GUI Designer and powerful reporting with Jasper Reports (iReport). Yet Oracle (who will soon buy Sun) doesn't seem ...
In Oracle, what is the difference between temp and permanent tables? ...
I am generating and validating XML and am experiencing a problem where Oracle expands the full namespace from the prefix. The source document may look like this: <pcy> <tList> <currTrn> <TXN_A>1</TXN_A> <TXN_B>2</TXN_B> ... the transform looks like this: <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet v...
How from ASP.NET I can call a stored procedure in an Oracle package that accepts a VArray. The VArray will pass a list of keys that the stored procedure will use to modify appropriate records. I know I could send the keys in separate calls or send a delimited list, but I'd rather use an array. ...
I am currently learning Cocoa. However I am coming from a traditional Sybase/Oracle background using Powerbuilder. Having been spoiled by the 'power' of a datawindow for may years, I not sure that coredata or sqllite will satisfy my needs and ideas. Basically I'm looking for some good reference sites, books, or just plain old advice on...
I'm not sure if one can do this but I need to have foreign key reference 2 tables. Table1 has 2 columns (A PK, B) Table2 has 2 columns (C PK, D) Table3 has 3 columns (A PK, B PK, E) and is made up of the first two table. What I am hoping to do is something like the following: create table Table3 ( A Varchar2 (4), C Varch...
I need to connect and perform some operation on oracle database from my C#/.NET application. Since it is a high load server application, I wish that I use only async calls to do database operations. I understand that System.Data.OracleClient is obsolete now, what are my options to do achieve above? ...
We've got a view that's defined like this CREATE VIEW aView as SELECT * from aTable Where <bunch of conditions>; The "value" of the view is in the where-condition, so it is okay to use a Select * in this case. When a new column is added to the underlying table, we have to redefine the view with a CREATE OR REPLACE FORCE VIEW aView...
I have a table in an Oracle database which has a CLOB field. My ASP.NET application (using ODAC Oracle data provider) queries this table. At the point of running the query we are seeing this error (from a 9i database): ORA-01062: unable to allocate memory for the define buffer In another Oracle database (10g) the query executes with...
I need to create a report that references multiple tables, including one table that is a line-by-line detail of an order. On orders, we have packages and the only way to determine if the package is of a certain status is to analyze the statuses of it's component members. The invoice detail is stored in sequential order with the line nu...
Hi there, I have to send a binary stream of a blob by means of a ServletOutputStream. I'm using the following technologies and software: Oracle 11, WebSphere 7, Springframework 2.5.5, Hibernate 3.3.SP1. There are two Oracle databases. The first one contains tables for description of documents I have to transfer, and the second one - ...
I am refactoring an old Oracle 10g schema to try to introduce some normalization. In one of the larger tables, there is a text field that has at most, 10-15 possible values. In my mind, it seems that this field is an example of unnecessary data duplication and should be extracted to a separate table. After examining the data, I cannot...
We recently upgraded to 10g and I've noticed that metadata queries seem to take an extraordinarily long time (at a guess 2-5 times slower than on 9i). Has anyone else noticed this? Any suggestions on ways to rectify this problem (settings/patches/incantations)? Thanks. ...
I want to use scrollable resultset, so when I use two lines of code: rs.setFetchDirection(ResultSet.TYPE_SCROLL_SENSITIVE); rs.absolute(12); in my DAOimpl, I get exception, plz help to solve them, thank in advance. import oracle.jdbc.OracleTypes; import org.springframework.jdbc.core.CallableStatementCallback; import org.spr...
I have this table created as follow: CREATE TABLE FORNECPRODS ( SUPPLIER FORNEC_OBJ , PRODUCTS PRODTABLE )NESTED TABLE "PRODUCTS" STORE AS "PRODUCTSTABLE"; / create or replace type PRODTABLE as table of PROD_OBJ; create or replace TYPE PROD_OBJ AS OBJECT ( ID_PROD ...
Hello, I installed Oracle 10G XE on RHEL 5.3 . I am able to login as user oracle to the database, but am unable to do so as root. If i try to login as root using 'sys as sysdba' username i get ORA-01031: insufficient privileges The root user is part of the dba group. Any way to fix this ? Thank You edit Additional info: When logge...
I have created this type: create or replace type PRODTABLE as table of PROD_OBJ; and I use that PRODTABLE in the follow PLSQL code: FUNCTION INSERT_PRODUCTS ( a_supplier_id IN FORNECEDOR.ID_FORNECEDOR%TYPE, a_prodArray IN PRODTABLE ) RETURN NUMBER IS v_error_code NUMBER; v_error_mess...
I have two tables : T_STOCK: primary key is id, seller, and some others fields let say a and b. T_FLOW: primary key is (id + startdate), and some others fields, for example c and d. I want a query that returns all the columns for each records from T_STOCK regarding a specific seller, but completed with the columns (startDate, c and d) ...