Hi, I am testing a PL/SQL that calls OS command. It works fine but it seems that I have to give the permission on each OS command...

Andrew

08-11-2003 05:29 PM
Rauf Sarwar

Hi all, I have 2 XP machines - one acting as a client and the other as a server. They're both running 9i. When I make the initial connection from...

Nick Williamson

08-11-2003 02:50 PM
Karsten Farrell

Hi Folks: More frustrating than I initially thought... I'm trying to run some of the Oracle file io samples... I am getting the following error...

tk

08-11-2003 10:48 AM
Niall Litchfield

Hi all, I am studying to take the 1z0-007 Introduction to Oracle9i SQL. I heard that there was a free voucher that could reduce the test price. Does...

SPIDERMAN

08-11-2003 09:35 AM
Brian Peasland

Hi all, I have Oracle 9i, v9.0. Is it possible to apply a patch or patches to get me up to 9.2, or do I have to download the full 9.2 product and...

Nick Williamson

08-11-2003 08:27 AM
sybrandb@yahoo.com

LKBrwn_DBA <member30625 (AT) dbforums (DOT) com> wrote Thanks it doesnt work exactly(it just adds 1 after every record) but it has pointed me in...

Derek Abernethy

08-11-2003 03:06 AM
Derek Abernethy

Hi everybody i would like to execute a stored procedure in Oracle from a Progress (Version 8.x) 4GL program. For...

Friedrich W. Bonhagen

08-11-2003 12:46 AM
Billy Verreynne

Well, not exactly sure. I have not used 8i for a couple of years now :-) It is possible that privileges contained within certain 'roles' have changed...

Jusung Yang

08-10-2003 09:48 PM
cschang

I found a couple of odd flaws in Oracle's CSV report generating feature (Oracle 9iEE / Windows) and the "View/Edit Contents" feature. If you are in...

Paul Murphy

08-10-2003 11:01 AM
Paul Murphy

If a queue table is created in RAC with the Primary and Secondary instances specified, what happens if both these instances fail? Does the queue...

Fido

08-10-2003 06:20 AM
Fido

tk wrote: No JavaDoc equivalent - it's manuals-style documentation. This is available in the same place as ALL the Oracle documentation .......

Hans Forbrich

08-09-2003 03:13 PM
Hans Forbrich

That's my complaint with OEM too....just too damned slow. Even running on a workstation with at least 2.0GHz and more than enough free memory. But I...

Billy Verreynne

08-09-2003 02:53 PM
Harald Maier

Rainer Hahnekamp wrote: Go to http://tahiti.oracle.com and look up REF CURSOR. -- Daniel...

Daniel Morgan

08-09-2003 11:43 AM
Daniel Morgan

OK, I have a procedure where Employees working on a PASSED Project Name have their salaries increased by a PASSED percentage. The kicker is I CAN...

Steven Markey

08-08-2003 06:49 PM
Steven Markey

I need to increase the size of the existing rollback segments. I have the SQL to do it but am not sure of the timing. Can I take one rollback...

Vince Laurent

08-08-2003 02:48 PM
Vince Laurent

Hi First, scuse my english, I'm a litle frenchy. :-p what is NLS ? I have an NLS error and ignore how to repare it ... if someone can help...

Gab

08-08-2003 10:37 AM
Gab

On Fri, 8 Aug 2003 11:46:11 +0200, "Hubert Holler" <haiflosse (AT) gmx (DOT) net> wrote: Just use the alter table modify command. NEVER EVER try to...

Sybrand Bakker

08-08-2003 10:10 AM
Sybrand Bakker

I have this situation: We are inserting many rows at a given time. Part of the data is a blob. We are using prepared statements & are thinking about...

Vinnie

08-08-2003 07:24 AM
Vinnie

Hi Norman, may I help you? Please spell after me: a-t-e e-y-e Nice weekend to all, Guido "Norman Dunbar" <Norman.Dunbar (AT) lfs (DOT) co.uk>...

Mikito Harakiri

08-08-2003 07:22 AM
Ryan Gaffuri

I have a schema design problem with which I would appreciate some advice. In my setup I have two tables, each having a very long string primary key...

Boris Pelakh

08-08-2003 07:09 AM
Noons

Hi! What is standard and direct way (within Oracle stored procedures) for writing binary data from Oracle to external file on disk? We have tried to...

Igor Shulgin

08-08-2003 05:35 AM
Igor Shulgin

Hi Folks: Going thru the Oracle 8i book (even though I installed 9i), I'm just playing around with Triggers/Views to familiarize myself more with...

tk

08-07-2003 09:58 PM
tk

Hi Alan Mills, thanks for writing this: Or ... if you expect to someday expand the trigger to also handle updates, surround your SELECT with: if...

Karsten Farrell

08-07-2003 09:58 PM
tk

Thanks, Volker. See my other replies in this thread. We can't point everyone to a central tnsnames file due to entries for locally...

Ray Porter

08-07-2003 05:10 PM
Daniel Morgan

Hi! I'm trying to import some data into a Oracle 9.2.0.3.0 database using SQLLoader, and get some trouble loading into one table. This is the the...

Frode Langseth

08-07-2003 03:01 PM
Ed prochak

Dear all, I have ora 3113 error. I've read already a lot about but still cannot find a solution. I have Oracle Enterprise Edition 8.1.7 running on...

konstantin

08-07-2003 03:01 PM
konstantin

I spent a while trying to figure this out, and couldn't the find answer anywhere, so I thought I'd post it (so that I can find it next time!). If...

Larry Leonard

08-07-2003 02:46 PM
Larry Leonard

Is it possible to do an SQL looking at InvNumber and comparing the previous record to see if that previous record has the same invoice number and...

David B69

08-07-2003 09:32 AM
David B69

Hi! My name is jufeca, I have just intalled 9i on my machine, I can't find the service "LSNR" or "Listener". . Please how is this posible????? What...

jufeca

08-07-2003 01:58 AM
jufeca

I just got a CD titled "Oracle9i AS Java Edition Developer CD" in the latest Oracle magazine. Does it actually contain a small database engine I...

atl

08-07-2003 01:49 AM
Jan Schaefer

Hi all, I am a newbie, trying to run this procedure and get Invalid Procedure error. The procedure compiles without errors and returns the number...

Sanna B

08-06-2003 10:20 PM
Sanna B

Hi! I just tried to alter the HTTP port in the Oracle Enterprise Manager Console unter <db> -> XML Database -> Configuration but a windows pops...

Timo Nentwig

08-06-2003 07:42 PM
Ana C. Dent

I'm running Oracle 9i on Windows 2000 on my PC. I don't know if that makes a difference.... My ORACLE_HOME is not set (when I do echo...

tk

08-06-2003 04:03 PM
Keld Nielsen

hi all, can any one point me to OCI wrapper libraries for c++/c (except OTL by skuchin)? it will be of great help. thanks in advance.

tornado

08-06-2003 12:37 PM
Ed prochak

Hi Mike, a couple of questions : what is the optimizer mode (rule or choose - or something else ?) how many rows in each table ? what is the...

Norman Dunbar

08-06-2003 11:41 AM
Norman Dunbar

Ed Prochak <edprochak (AT) adelphia (DOT) net> wrote And of course, Miss Manners, who normally is entertaining as dotage, but here has a reasonable...

Richard

08-06-2003 11:29 AM
Joel Garry

Hello Group, I run into the following problem when installing Oracle v. 8.1.6 onto an IBM XSeries 345 server with a Xeon processor. I created a CD...

Dave

08-06-2003 10:28 AM
Dave

Hei all, i want to connect to ORACLE Database( this run in Windows) from UNIX through sqlplus ?? I need to update any file in UNIX ? What...

ip

08-06-2003 09:31 AM
Brian Peasland

Saludos alguien tiene alguna informacion de como realizar esto o que pasos se tienen que tomar en cuenta.

Juan Carlos

08-06-2003 09:23 AM
Brian Peasland

Folks, I was reading Chapter 4 of Pro*C/C++ Precompiler Programmer's Guide. In it they say the Oracle Internal Datatype VARCHAR2 must be less than...

Hemant Shah

08-06-2003 09:22 AM
Hemant Shah

While stranded on information super highway Anurag Varma wrote: :) :)"Hemant Shah" <shah (AT) typhoon (DOT) xnet.com> wrote :)> :)> :)>...

Hemant Shah

08-06-2003 09:18 AM
Hemant Shah

The application which generates the data runs on Solaris Intel. We have a streaming application to stream it to the database. Right now, I have to...

Pari

08-06-2003 09:16 AM
Brian Peasland

Hi everyone, could anyone explain to me is there any similarity between :system.form_status and :system.mode variables in oracle forms. i'm a...

marc

08-06-2003 06:39 AM
marc

On Tue, 05 Aug 2003 16:26:43 +0200, Stefan Röhle <roehle (AT) uni-mainz (DOT) de> wrote: So you now have hit the reason NOT to do that, and...

Norman Dunbar

08-06-2003 05:50 AM
Ed Prochak

Hi "You" I have two collection types declared at the SQL level. 1. Do you know of any known bugs with the BULK COLLECT clause used with the TABLE...

Paul Rowe

08-05-2003 06:46 PM
Daniel Morgan

I have a "Legacy" data conversion project. I've done this sort of thing in the past using SQL scripts, but this particular project appears to be a...

Oscar Bowyer

08-05-2003 05:28 PM
Oscar Bowyer

Protect your hard work! Do you have that all important Copyright? Did you spend a lot of blood, sweat, and tears developing an application only...

Miles Jackson

08-05-2003 04:56 PM
Niall Litchfield

Where can I buy Personal Oracle8 or 9 on CD for the PC? I need a part number, a price, and an address. Please don't refer me to the Oracle Web site...

Tom Fisher

08-05-2003 04:08 PM
Joel Garry

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote According to the desupport notice, E-Business Suite 11i customers...

Robert A.M. van Lopik

08-05-2003 03:52 PM
Joel Garry

"tk" <theronk (AT) charter (DOT) net> wrote If the OReilly book is the Steve Feuerstein one - then it is excellent. Don't know squat about...

tk

08-05-2003 02:47 PM
Niall Litchfield