We're currently questioning our company's data model (database schemes), which has grown wildly and distributedly over the years and now suffers from redundancy and lacks clarity. Different databanks (Oracle and MySQL) are queried by different tools, developed by separate teams for different purposes (billing, reporting, business, etc). ...
So, following a variety of tutorials, I installed the following gems on my windows box: "activerecord-oracle_enhanced-adapter" and "ruby-oci8" As well as modifying my database.yml to look like: oracle_development: adapter: oracle_enhanced database: 127.0.0.0:1521/sid username: uid password: pid Ruby OCI8 wouldn't compil...
I am new to Oracle, I have two tablespaces one for dev and one for live. Is there a way that I can have a variable on a Package header that contains a tablespace name, which can then be used from within the procedures defined in the package header? I need to do this as I have one tableSpace (TableSpaceA) that needs to query tables in T...
I have a database where the nls_length_semantics value has been changed from byte to char. Is it necessary to recompile all the packages that have externally accessible varchar2 based data types (for example dbms_sql)? ...
I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various attempts, we've decided that the simplest series of steps for a clean installation include: Set up an Oracle Instant Client Install the accompanying ODBC driver (Test the connection using EZCONNECT via SQL Plus) (Test the conn...
I'm trying to create a user defined function in Oracle that will return a DATE when given a text argument containing a date substring. I've tried a couple ways of writing this, and all seem to throw the same error: CREATE OR REPLACE FUNCTION lm_date_convert (lm_date_in IN VARCHAR2(50)) RETURN DATE DETERMINISTIC IS BEGIN RETURN(TO_D...
Here's a part of XAML of the application I'm working on: <ListView Name="lsvCustomerDetails" ItemsSource="{Binding myDataTable}"> <ListView.View> <GridView> <GridViewColumn Header="Script Name" DisplayMemberBinding="{Binding ID}"/> <GridViewColumn Header="Status" DisplayMemberBinding="{Binding status}"/> ...
Hello, Here is the scenario: Oracle A: charset WE8ISO8859P1 Oracle B: charset WE8MSWIN1252 Oracle A <- dblink -> Oracle B I can't access Oracle B directly, firewall issues :( I have to get some binary files from OracleB and these files are in a column of type CLOB (don't ask me why and I can't change to BLOB). I'm using a "select ...
I'm attempting to write a simple query where I declare some variables and then use them in a select statement in Oracle. I've been able to do this before in SQL Server with the following: DECLARE @date1 DATETIME SET @date1 = '03-AUG-2010' SELECT U.VisualID FROM Usage u WITH(NOLOCK) WHERE U.UseTime > @Date1 From the searching I've ...
We have a table with a 'price' field of type NUMBER(20,7).. In TOAD I do this: update mytable set price = 1234567890123.1234567; Then I do this select: select price, to_char(price) from mytable PRICE TO_CHAR(PRICE) 1234567890123.12 "1234567890123.1234567" Question is, why does TOAD truncate the result when displayi...
Does anyone know if Informix has the same capability as Oracle with respect to the autoextend feature. With Oracle I can create a datafile and by using the autoextend feature Oracle will automatically grow the file when it gets full. Does Informix have anything like that for chunks? I can't seem to find anything in the documentation. T...
Hi, I have 35 functions that update 1 to 3 tables, in a transaction. However, they don't just execute updates, but they do queries as well. Table 1 does row update only actions, and some queries. Table 2 does queries and row level updates to existing rows, and sometimes deletes and adds rows. Table 2 may have queries within the trans...
Strange problem: Running newest Version of Zend Server CE. Local installation of Oracle XE and SQLDeveloper. Connecting from SQLDeveloper to Remote/Local DB works perfect. Connecting from Zend Server CE with PHP/Zend Framework to local Oracle XE works perfect. But connecting with the Server to an remote oracle db, gives me an error lik...
Hello, a bit of unusual question - in what context are angle brackets escaped with backslashes? I am sending an XML document (as a string xsd type) through a web service, which saves it to database, but there I see all XML's angle brackets escaped with a backslash, so I am wondering where exactly (Java XML creation using DocumentBuilder...
Is there any free tool which can generate data entry and listing screen for a database table(Oracle) based on the metadata. Desired features: Drop downs for reference data Abilty to customise the label name, showing/hiding specific column of the table, ordering of columns etc.. Operation on listing screen (modify,delete,activate,deacti...
Hi, I'm connecting to a Jet 4 DB through ODBC. The Jet DB uses pass-through queries to an Oracle DB. This works so far (can't access the p-t queries directly, but creating a view on the query does the trick). I need some subset of the data returned by the p-ts. Parameters would be best, but are not supported. Two questions: 1) Jet d...
how can i adjust the properties of connection pooling like setMaxPoolSize(); setMaxIdleTime(); setMaxPoolSize(); setMinPoolSize(); setInitialPoolSize(); setPropertyCycle(); setMaxStatements(); ...
How can i retrieve datas (using sql) from Excel to a table in Oracle database .I am using dbsaint. Insted of DBSAINT which developer tool shold i use for this purpose Thanks ...
Hello, On a Spring/Hibernate web application, I'm using a Work Queue, built with Java Threads. The Threads's run() method calls an Oracle procedure, which can last a bunch of minutes/hours. All the Work Queue's threads are stored in a list. I would like to build an interface (JSP), where I could display a list of the running jobs, and ...
Hey folks, I've got this procedure: CREATE OR REPLACE PROCEDURE CONV1( pDate IN VARCHAR2, pYear OUT number, pMonth OUT number, pDay OUT number ) AS lDate DATE; BEGIN lDate := to_date(pDate, 'DD.MM.YYYY HH24:MI:SS'); pYear := to_number(to_char(lDate, 'YYYY')); pMonth := to_number(to_char(lDate, 'M...