Recent content by DaPi

Hi, Under "TCP/IP properties" > "WINS Address" there is the check-box "Enable DNS for Windows Name Resolution". This has become unset. (It should be ticked - it isn't). If I change this, I get two dialogs telling me that there is no WINS address for my adapter and then an invitation to...

"Suit jacket, silk top, dress slacks, jewelry, perfume, etc" to me, an average lascivious male, this sounds great! I'm not a consultant, but after 2 take-overs in 3 years I've had a lot of experience of having to plunge into unknown waters. "Smart but BORING" is my standard...

. . . . and the utl_file to a url works perfectly! Thanks DaPi - no silver bullet

Hi Dima, The "(and Listener?)" was an after-thought - and I realised that I hadn't tried both about three seconds after I hit the "submit" button! Thanks any way! Have a good day! DaPi - no silver bullet

In an old thread sem said: "As far as I know, UTL_FILE does not work with mapped drives on NT while running under SYSTEM account, for this NT account normally has no access to those drives. You may refine the Oracle service settings (Log On As). You may also use \\machine\share\path...

Ahhhhhhh! DaPi - no silver bullet

Custom24, . . . just read the title again "many to many" ! ! ! ! Do you really mean this? Please let us know if I interpreted the cardinality of the relationships correctly. DaPi - no silver bullet

(Sorry about the duplicate - had a mini-crash). I said: "only needs to fetch one row per table" - of course this assumes all the right indexes exist and the tables have been analyzed etc. DaPi - no silver bullet

Custom24 said "for a given Analytical Submission" so it's . . . and AS.column = 'Some Value' . . . Which if the 1-to-many are as I stated, only needs to fetch one row per table and will only give one row as output. (We are "reading" the tree in the many-to-1 direction -...

Custom24 said "for a given Analytical Submission" so it's . . . and AS.column = 'Some Value' . . . Which if the 1-to-many are as I stated, only needs to fetch one row per table and will only give one row as output. (We are "reading" the tree in the many-to-1 direction -...

I'm having trouble seeing what the problem is with this . . . Library to Synthesis_Plate, Synthesis_Plate to Synthesis_Compound, Synthesis_Compound to Analytical_Submission - are all 1 to many? Using an ordinary INNER JOIN, starting from ONE Analytical_Submission, you find one...

Anyone who has found this function will not answer you, they will have gone off to make a fortune on the stock-echnage! DaPi - no silver bullet

Are you running 9i? . . . INDEX BY VARCHAR2 is new and NOT in previous versions. DaPi - no silver bullet

Try it as a BEFORE INSERT OR UPDATE trigger ..... think it should work. DaPi - no silver bullet

From SQL*Plus: - copy & paste OR - "ed" then "save as" (default is \bin - silly choice!?) DaPi - no silver bullet