Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: slicendice
  • Content: Threads
  • Order by date
  1. slicendice

    Inserting data into a different Access database using IN with variable path...?

    I have a database that I'm using to extract/generate data that includes a whole bunch of tables, queries, VBA, etc and the output of this is a set of data that will be used by a customer. The data that is extracted has to be in a separate database so that it only contains the data and nothing...
  2. slicendice

    Best type of index to use...?

    Hi everyone I have a situation where I'm processing the data in a large table using a PL/SQL routine. The processing has to happen in batches and when a record has been processed, a field in the table is updated to indicate this. The field in question (called PROCESSED) is a simple NUMBER(1)...
  3. slicendice

    How handle null/empty fields in XML?

    Hi I have a bunch of XML files that need reading/processing and I've constructed something that uses xmltype, dbms_xmlschema, etc. I've loaded the associated XSD schema into the database using the following: -- Read the XSD file and load it into an xmltype -- xtXSD is declared as...
  4. slicendice

    Oracle errors (ORA-06508 and ORA-04061) when attempting to run job...

    I have a package that compiles and works fine - no issues or errors and the package status is VALID. There is a main function in the package and this in turn calls various other functions within the package as part of the processing. All functions are fully internal to the package and no...
  5. slicendice

    How to restrict results where duplicate in one column but not another

    Sorry if the subject doesn't explain things too well, but it's difficult to get across in one line! Anyway, we have a query which returns a data set that contains two columns - an ID and optionally a date. The query used to generate the data is as follows: WITH evt AS (SELECT aceu_cnh_id...
  6. slicendice

    Using REPLACE on CLOB causes increase in CACHE_LOBS...

    I have a requirement to use the built in REPLACE function on a CLOB variable as part of a larger PL/SQL process. I'm using Oracle 11g R2 and the function works OK, in that it does the replace as required, but as the procedure runs (there are around 2.5 millions records to process), it slows down...
  7. slicendice

    Using negative number in WHEN clause using SQL*Loader...?

    Hi Does anyone know if it's possible to check for a negative number using the WHEN clause in SQL*Loader? The column being checked is defined in the database table as NUMBER(8). I can use the following OK: WHEN (col1 <> '1') The above works fine, but if I change it to: WHEN (col1 <> '-1')...
  8. slicendice

    How to handle string array returned from Java function in PL/SQL...?

    Hi I've got a function in Java that returns a string array but I'm not sure how to reference this in PL/SQL (I am a total beginner when it comes to Java!). The Java function is as follows: CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "GetDirListArray" AS import java.io.*; import...
  9. slicendice

    How to add two time values...?

    Hi I have two variables that are involved in processing some appointment data - one is the start time of the appointment and the other is the duration (in minutes). I need to calculate the end time of the appointment using those two items - which in itself is not a complex concept! I know I can...
  10. slicendice

    Returning cursor from dynamic SQL

    Hi If I have a function that returns a cursor, is it possible to call that function using dynamic SQL? I know it's possible to call a function using something like: DECLARE vSQL VARCHAR2(100); iParam INTEGER; BEGIN vSQL := 'BEGIN some_function(:1) END;'; iParam := 5; EXECUTE...
  11. slicendice

    Strange behaviour when reading user input in command file

    Hi I have a simple batch/command file that I'm using as the mechanism to run some Oracle SQL scripts on Win XP. The script starts off by requesting the user to input the password of an authorised Oracle account. Entering this password is not mandatory - it simply means that a user can run...
  12. slicendice

    Why is all text grey in Firefox?

    I'm having a problem with Firefox whereby all web pages have a white background and all text is grey (regardless of the colour it should actually be). Images seem to show correctly but that's about it. I was originally on v3 but I've just upgraded to v4 and I have exactly the same problem. Can...
  13. slicendice

    Numbering screwed up on Heading 2 style

    Hi I'm not a Word expert by any means and I've got an issue with numbering that I can't seem to solve. The document in question uses styles Heading 1 and Heading 2, each of which are numbered. So ideally the doc would look like: 1. First heading 1.1 sub-heading 2. Second heading 2.1 sub...
  14. slicendice

    Getting error &quot;ORA-01086: savepoint 'SP_ONE' never established&quot;

    Hi I have a small PL/SQL script that is being run by a customer. It's nothing complex and is basically inserting various records based on various criteria. There are several discreet blocks within the code with each having it's own exception handler, which will print diagnostic messages and then...
  15. slicendice

    Computer starting all by itself...

    Hi My PC is about 5 years old or so and has been a pretty dependable work horse. Over the last few months though, it's been prone to starting up all on its own. There doesn't seem to by any rhyme or reason as to why it's doing this but it does seem to be getting worse. Usually it would happen...
  16. slicendice

    Possible to specify relative path in SQL*Loader control file?

    Hello I'm just wondering if it's possible to specify a relative path in a SQL*Loader control file - so something along the lines of: LOAD DATA INFILE '../data1.csv' BADFILE '../data1.bad' DISCARDFILE '../data1.dsc' TRUNCATE INTO TABLE data1 FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( col1...
  17. slicendice

    Back side of page upside down when booklet printing

    Hi I am trying to print out a PDF in booklet format (printing on both sides) and yet no matter what I try, the back side of every page is printed upside down. The print settings I'm using are: Print Range: - All Page Handling: - Copies: 1 - Page Scaling: Booklet Printing - Booklet...
  18. slicendice

    Inactive connection status icon in taskbar, even when connected

    This is more of a query than a problem as such - I have recently noticed that my network connection status icon in the task bar isn't showing any activity at all, even when I am using the web. If I double click it to get the Connection Status dialog box, it tells me my status is connected, it...
  19. slicendice

    Loading multi-line text fields using SQL*Loader

    Hi I have a scenario whereby I need to load data into a table using SQL*Loader. The fields are pipe seperated and one of the fields contains text that may be split onto several lines. The target table is defined as: COL1 NUMBER(8) COL2 VARCHAR2(10) COL3 VARCHAR2(500) COL4 NUMBER(1) Each...
  20. slicendice

    Bulk collect hangs...

    Hi I'm trying to do a simple (at least I *thought* it was simple!) BULK COLLECT in 9i but when that actual BULK COLLECT statement runs, it just seems to hang (I've run it in SQL*Plus and PL/SQL Developer debugger). The code I'm running is as follows: TYPE typVacRec IS TABLE OF...

Part and Inventory Search

Back
Top