Below is a script for one of our tables, which contain BLOB data type. I need to build a form on this table. Forms won't allow BLOB data type. Can you help?

 CREATE TABLE WKS_BIZ_RULE ( BIZ_RULE_ID VARCHAR2 (40) NOT NULL, BIZ_RULE_LOAD_CD VARCHAR2 (20) NOT NULL, USECASE_CD VARCHAR2 (10) NOT NULL, BIZ_RULE_CD VARCHAR2 (256) NOT NULL, RULE_VALUE BLOB NOT NULL, OBJECT_MAP BLOB NOT NULL, CONSTRAINT BIZ_PK PRIMARY KEY ( BIZ_RULE_ID ) USING INDEX TABLESPACE APOLLO PCTFREE 10 STORAGE ( INITIAL 40960 NEXT 40960 PCTINCREASE 50 )) TABLESPACE APOLLO PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 40960 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 ) NOCACHE; ALTER TABLE WKS_BIZ_RULE ADD FOREIGN KEY (BIZ_RULE_LOAD_CD) REFERENCES APOLLO.WKS_BIZ_RULE_LOAD_TYPE (BIZ_RULE_LOAD_CD) ; ALTER TABLE WKS_BIZ_RULE ADD FOREIGN KEY (USECASE_CD) REFERENCES APOLLO.WKS_USE_CASE (USECASE_CD) ; CREATE UNIQUE INDEX SYS_IL0000039454C00005$$ ON WKS_BIZ_RULE() TABLESPACE APOLLO PCTFREE 10 STORAGE(INITIAL 524288 NEXT 524288 PCTINCREASE 5 ) ; CREATE UNIQUE INDEX SYS_IL0000039454C00006$$ ON WKS_BIZ_RULE() TABLESPACE APOLLO PCTFREE 10 STORAGE(INITIAL 524288 NEXT 524288 PCTINCREASE 5 ) ; CREATE INDEX XIF1WKS_BIZ_RULE ON WKS_BIZ_RULE(USECASE_CD) TABLESPACE APOLLO PCTFREE 10 STORAGE(INITIAL 81920 NEXT 57344 PCTINCREASE 0 ) ; CREATE INDEX XIF2WKS_BIZ_RULE ON WKS_BIZ_RULE(BIZ_RULE_LOAD_CD) TABLESPACE APOLLO PCTFREE 10 STORAGE(INITIAL 81920 NEXT 57344 PCTINCREASE 0 ) ; GRANT ALTER ON WKS_BIZ_RULE TO PUBLIC; GRANT DELETE ON WKS_BIZ_RULE TO PUBLIC; GRANT INDEX ON WKS_BIZ_RULE TO PUBLIC; GRANT INSERT ON WKS_BIZ_RULE TO PUBLIC; GRANT SELECT ON WKS_BIZ_RULE TO PUBLIC; GRANT UPDATE ON WKS_BIZ_RULE TO PUBLIC; GRANT REFERENCES ON WKS_BIZ_RULE TO PUBLIC;


Usually

    Requires Free Membership to View

    Login

you have some form of binary object like image or sound or mMultimedia item that you store as BLOB in the database. If that is the case, then Form can retrieve it. You can define an image item in Forms. The item can be a base table item and Form will display that image item in your form.

So, please let me know what your BLOB columns are storing in the database so that I can answer further.

This was first published in March 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top