| Problem in Inserting record. [message #118021] |
Mon, 02 May 2005 12:28  |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
I am using BLOB Datatype to store pictures. Here is the desc of table
SQL> DESC P
Name Null? Type
----------------------------------------- -------- ------------
PIC BLOB
SNO NUMBER(4)
ON THE FORM AGAINST COMMAND BUTTON I WRITE THIS CODE.
DECLARE
FILENAME VARCHAR2(100);
BEGIN
FILENAME:= GET_FILE_NAME('C:\Pict\','*.jpg');
READ_IMAGE_FILE(FILENAME,'JPG','PIC');
END;
BUT WHEN I AM GOING TO SAVE THE RECORD IN DATABASE THEN THE FOLLOWING ERROR ARAISE.
FRM: 40508
ORACLE error UNABLE TO INSERT RECORD.
PLEASE HELP ME REGARDING THAT.
THANKS
|
|
|
|
|
|
| Re: Problem in Inserting record. [message #118317 is a reply to message #118021] |
Wed, 04 May 2005 06:35  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
| sohailnawaz wrote on Mon, 02 May 2005 19:28 |
FRM: 40508
ORACLE error UNABLE TO INSERT RECORD.
|
Hit Shft-F1 when encountering this error, this will show you the statement Forms has launched against the db + the SQL error.
Post this ORA message too.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
