Recent content by o.germeau

  1. O

    List of connected users

    One other way is to use the DBMS_LOCK package. For each connection, you use ALLOCATE_UNIQUE procedure. In my application, it's work well for control if a user is connected or not. I use one oracle user for many user in my application.
  2. O

    Where are declared otFloat & Co?

    OtString otinteger and Co are declared in oracle.pas ------------------
  3. O

    ORA-01041 - hostdef extension doesn't exist

    I have the same problem. After more test, it's appear that this problem don't appear on windows 2000 sp1. I have detected this problem on windows98. This problem occurs more frequently on low ressource on workstation, for example with big query with order by multi columns descending. Why, i...
  4. O

    Using BLOB in a SELECT statement

    I have already tested BLOB and CLOB but the result is the same. The idea is to convert HEXA in VARCHAR2. But i don't know how to process and why HEXTORAW don't work.
  5. O

    Using BLOB in a SELECT statement

    I have text in a BLOB field and i want to do a select statment. When i use DBMS_LOB.SUBSTR the result is in hexadecimal. Also SELECT * FROM TEST WHERE DBMS_LOB.SUBSTR(BLOBFIELD) LIKE 'Ligne%' don't work. But SELECT * FROM TEST WHERE DBMS_LOB.SUBSTR (BLOBFIELD) LIKE RAWTOHEX('Ligne') | | '%' work...
See more
Back
Top