tom_table --------- who varchar2(20) description varchar2(100) file CLOB are you saying to take out the "file" column in tom_table and add "NAME" as an FK to the 128 character primary key for my_document_table basically do this tom_table --------- who varchar2(20) description varchar2(100) name FK MY_DOCUMENT_TABLE ----------------- NAME VARCHAR(128) UNIQUE NOT NULL, MIME_TYPE VARCHAR(128), DOC_SIZE NUMBER, DAD_CHARSET VARCHAR(128), LAST_UPDATED DATE, CONTENT_TYPE VARCHAR(128), CONTENT LONG RAW, BLOB_CONTENT BLOB ; It seems to me NAME is the PK. Based on a basic html form, can you write the correct insert statement to "my_documents_table" and "tom_table" where the pointer will be. If there was a file, we put the uploaded file into the document table you told us to - and we send you the key to that row, not the file contents, the key. Tom: Do you know what causes this error and how to fix it?
Use the Format Painter to transfer "Custom Properties" and Property Set Definitions (PSD) from one object to another.
This huge productivity improvement is also a crucial feature for extending BIM/IFC models.
we put the document in there we give you the key to the row we just put there. select utl_raw.cast_to_varchar2(dbms_lob.substr(blob_content,4000,1) ) from document_Table SQL March 06, 2008 - am UTC well, that is a plsql error and you show sql so something very relevant is MISSING here.
you do not insert into the document table we did and we give you the key to that row. like the actual code that gets the error, I'll guess that you have something wrong in your code.
Action: Switch Site: An unhandled exception occurred.
Action: Global Search: An unhandled exception occurred.
and I create this procedure procedure write_info ( who in varchar2, description in varchar2, file in varchar2) as begin insert into tom_Table values (who, description, file); htp.htmlopen; htp.headopen; htp.title('File Uploaded'); htp.headclose; htp.bodyopen; htp.header(1, 'Upload Status'); htp.print('Uploaded '