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...
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)...
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...
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...
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...
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...
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')...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.