Q

Building a form with BLOB data

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 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

Dig deeper on Using Oracle PL-SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close