Re: Length of BLOB file

From: Damir Vadas <Damir.Vadas_at_trinity.de>
Date: Sat, 21 Jul 2001 21:37:54 GMT
Message-ID: <9ip37l$jrs$03$1@news.t-online.com>

I have tried and it doesn't work.
I'm using Oracle 8.05 on Win2k (no SP installed).

Table is created throgh the script:
-- TABELLE TMS_SYSBenutzerMenus
CREATE TABLE TMS_SYSBenutzerMenus (

   nAppId            NUMBER (5,0),
   sLoginName        VARCHAR2(32),
   sAppVer           VARCHAR2(32) CONSTRAINT TMS_SYSBenutzerMenus_NN_sVer
NOT NULL,
   blMenus           LONG RAW,
   sEingabe          VARCHAR2(32) DEFAULT USER,
   dtEingabe         DATE         DEFAULT SYSDATE,
   sAenderung        VARCHAR2(32) DEFAULT USER,
   dtAenderung       DATE         DEFAULT SYSDATE

) TABLESPACE TMS_DATEN; ALTER TABLE TMS_SYSBenutzerMenus
  ADD CONSTRAINT TMS_SYSBenutzerMenus_PK PRIMARY KEY (nAppId,sLoginName)     USING INDEX TABLESPACE TMS_INDEX;
ALTER TABLE TMS_SYSBenutzerMenus
  ADD CONSTRAINT TMS_SYSBenutzerMenus_FK_nAppId FOREIGN KEY (nAppId) REFERENCES TMS_SYSApps(nAppId);
ALTER TABLE TMS_SYSBenutzerMenus
  ADD CONSTRAINT TMS_SYSBenutzerMenus_FK_sLName FOREIGN KEY (sLoginName) REFERENCES TMS_SYSBENUTZER(sLoginName);

---

---

grant all on TMS_SYSBenutzerMenus to TMS_PRG; grant select on TMS_SYSBenutzerMenus to TMS_PRG_RO; create public synonym TMS_SYSBenutzerMenus for TMS.TMS_SYSBenutzerMenus;

and the query I tried to execute is:
"select dbms_lob.getlength(BLMENUS) from tms_sysbenutzermenus;"

The error I get is:(from SQL workshop)

    SQLWKS> select dbms_lob.getlength(BLMENUS)

        2> from tms_sysbenutzermenus;

    select dbms_lob.getlength(BLMENUS)

                              *

    ORA-00997: Unzulässige Verwendung des Datentyps LONG

    SQLWKS> What is wrong?
THX! "Damir Vadas" <Damir.Vadas_at_trinity.de> schrieb im Newsbeitrag news:9imp4u$ocf$00$1_at_news.t-online.com...
> Hi!
> How to see through SQL statement how much bytes does BLOB field occupied?
> Regards
> Damir!
>
>
>
Received on Sat Jul 21 2001 - 16:37:54 CDT