Search results for query: *

Okay I feel pretty stupid right at this moment, as I feel that this should be an easy answer but here I go. I want to search a text field and return rows where there is an underscore '_' in the text. The problem is, is that the underscore is a single character wildcard as you all well know...

Don't worry, I solved it! The function is part of a larger package, that when called initializes some package variables, one of which writes to a package variable. The function itself is pure, but this initalization call was not declared as such. When I place pragma restrict_references...

I can not seem to resolve the following problem. Compliling the following returns PLS-00452: Subprogram 'BLOCK_OFFSET' violates its associated pragma. However, I can not see anything that would indicate that the function is writing to the database. -- In Header function block_offset(InDate...

To illustrate (1) suggested by carp, here is an example script to run in SqlPlus. -- start script variable jn number; create or replace procedure update_every_2hr is DECLARE << enter you declare statements here >> BEGIN << enter your sql routine here >> END; / begin...

I am running into a sporadic problem which appears to be getting more common. Firstly I am running Oracle 8.0.5.1.1 on NT6SP6. I am running my query directly on the server, so a network problem should not be the issue. The problem I am having is this. I am occasionally getting an ORA-03113...

I am more an Oracle user than Sybase, so please excuse my short comings with regards to Sybase. I am extracting data from a sybase (System 11) table that contains a field with text information. The text can contain linefeeds and carriage returns (Char(13) + Char(10)), and so when I run an...

I can not give that much help unfortunately. I have only recently started using OO4O myself, and have been doing this to interface Excel into an Oracle 8 database. But I know it should work with Access as well. OO4O is installed with the client side of Oracle 8. I do not know if it is...

Dima, Thank you very much! I tested both and both worked equally well, but I decided to implement the later to_date(decode(rec.F1DATA, '0', null, '99999999', null, rec.F1DATA),'YYYYMMDD') as it was shorter to code :) This will save me lots of grief. Thank you again. Kerry

I would just let access odbc into oracle if the table is not that large - very easy. If very large, take a look at Oracle Objects for OLE (OO4O), that should be installed as part of your client tools. Right some VBA code to use OO4O to connect to your database and tables and then use can...

Okay, this one is driving me nuts. In sqlplus the query: select to_date(19960501,'yyyymmdd') from dual; returns: 01-MAY-96 The query: select to_char(to_date(19960501,'yyyymmdd'),'mm/dd/yyyy') from dual; returns: 05/01/1996 This is what you would expect right? The thing that perplexes...

Hello, I have a problem with a mutating trigger. I have table that contains sort keys, and when a row is deleted, I want the sort keys to be resorted so that there are no gaps. Ie, if I have 100 rows, sorted 1 to 100, then if row 50 is deleted, then 51 to 100 to be renumbered 50 to 99. So...