Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Ora-1031 (Insufficient Privileges) Inserting BLOB Data With Perl
One of our developers has written a program to upload files into the database via perl. The actual file contents are stored in a blob.
The table was created with the following script
CREATE TABLE BP_FILES
(FILE_ID NUMBER(7,0) NOT NULL,FILE_NAME VARCHAR2(80) NOT NULL
,FILE_TYPE VARCHAR2(1) NOT NULL
,FILE_FORMAT VARCHAR2(1) NOT NULL
ORA-01031: insufficient privileges (DBD ERROR: OCILobTrim/OCILobWrite/LOB refetch)
The statement involved is
insert into <owner>.BP_FILES ( file_id, file_type, file_format, file_name, file_private, comments, file_data, date_created, created_by, date_updated, updated_by, content_type, content_disposition ) VALUES ( ?, ?, ?, ?, ?, ?, ?, SYSDATE, ?, SYSDATE,?, ?, ? )
The question marks are place-holders for bind variables in Perl.
Ian MacGregor
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: ian_at_SLAC.Stanford.EDU Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Nov 20 2001 - 07:31:24 CST
![]() |
![]() |