Recent content by iolani

  1. I

    Programm very slow during startup

    I've got the following problem: We're Using oracle 8.0.3 on Netware an DOA 3.3.1. and Delphi 4 with Service Pack 3. We're using only 1 Oracle-User and have the clientprogramm running on about 15 WIN95-PCs. The TOraDataset-Structure is kind of 3 or 4 trees linked together mostly with the...
  2. I

    ORA-01036: illegal variable name/number

    It's just an idea, but are you sure that the otinteger Type is the right type. Have you tried otvariant, or otfloat or something? Bye for now!
  3. I

    PL/SQL Developer/Sequences

    You were absolutely right! 2 Rows - 1 deleted - worked. Thanks for helping!
  4. I

    PL/SQL Developer/Sequences

    What am I doing wrong? I try to get a sequencenumber by using the following SQL-Statement in a PL/SQL-Function/Procedure: SELECT SEQ_UPVerbindungen.Nextval INTO UPVID FROM DUAL; UPVID is of the right type, but I get the following error: ORA-01422 exact fetch returns more then requested number of...
  5. I

    I don't found my search records

    Try using variables. It helped me a lot. Because the records are filtered on the server not on the client. So performance is really good. I hope it helped So long!
  6. I

    Slow Performance with O8 and D4

    It worked quite well, thanks. Now I'm trying to get last bit of speedup by tuning Oracle.
  7. I

    Slow Performance with O8 and D4

    a) How could it be, that a locate.event in 4000-entries Oracle8-Table causes a delay of up to 30 seconds. QueryAllRecords is set to false already. What about the Readbuffer-property? What are recommended values for that? The SQL-Explorer works in fine speed. b) TOracleDatasets linked to another...
See more
Back
Top