 unable to preform query (merged by CM) [message #455580] |
Wed, 12 May 2010 04:06  |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
hi everyone
Actually as I'm new to Oracle and now these days I'm trying to create my first project,well I have a book table,and i want to put a picture"book title" for each book...
I had read the all pages here which is disscused before about the BLOB,but i didn't get any meaningful things,,,
first of all,,
i change my actual book table,to put the BLOB by:
alter table book
add photo BLOB;
>>>> the table was altered successfully
then i create a data block"form" form the book
after that i nsert a text_box--->>i named "BOX" this text_box to write the path of the picture,,
after that i create a button ,which contains a trigger:when_button_pressed: I write in it this code:
begin
EXECUTE_QUERY(NO_VALIDATE);
:System.Message_Level := '25';
READ_IMAGE_FILE(:book.box,'ANY','book.photo');
WRITE_IMAGE_FILE(:book.box,'ANY','book.photo');
IF NOT FORM_SUCCESS THEN
MESSAGE('This book does not have a photo on file.');
END IF;
:SYSTEM.MESSAGE_LEVEL := '0';
COMMIT_FORM;
end;
when i run the form,,,
and I try to execute the query,it doesn't execute at all,,
I don't konw why the fields it's sems to be empty with no data!!
but when i put the path of the picture in the text_box and then i pressed the button in which i put the trigger in it:
an error occure is:
1- frm-40505 oracle error:unable to preform query.
but the picture is displayed successfully... but the other fields of book table:isbn,author..... etc it's empty!!! but I already insert such of values in it by sql*plus.....
so the main problem here,to how can I retrive my data!and run the query successfully..!!
I hope u help as soon as possible,,thank you very much..!!!
and here a snapshoot of my form,,,
|
|
|
|
|
|
|
|
|
|
| Re: unable to preform query (merged by CM) [message #455601 is a reply to message #455594] |
Wed, 12 May 2010 04:36  |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
cuz when I put that error in the help bar:
Processing error encountered. The table associated with the current block of the form might not exist, or your username might not have authority to perform the specified action on the table.
but the table "book: it's exits in my DB,,,also am working with admin authority,,!!! so what's maybe the problem with this,,,,plz help me...!!
|
|
|
|
|
|
| Re: unable to preform query (merged by CM) [message #455621 is a reply to message #455612] |
Wed, 12 May 2010 05:11 |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
after i run the form,
a press o execute--->to execute the form,but the information for each field it doesn't display...but after that i wrote the path in the tex_box and press the upload button --->what is shows "snap shoot"..
an error occur... frm-40505 oracle error:unable to preform query.
i want to know why the info of table "book" it doesn't display??!!!!!!!!!!!!!!!!!!
|
|
|
|
| Re: unable to preform query (merged by CM) [message #455624 is a reply to message #455621] |
Wed, 12 May 2010 05:16 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
purelove wrote on Wed, 12 May 2010 11:11after i run the form,
a press o execute--->to execute the form,but the information for each field it doesn't display...but after that i wrote the path in the tex_box and press the upload button --->what is shows "snap shoot"..
an error occur... frm-40505 oracle error:unable to preform query.
And once you get that error select display error from the help menu. Then post a screenshot of the window that gets displayed here.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: unable to preform query (merged by CM) [message #455639 is a reply to message #455634] |
Wed, 12 May 2010 05:59 |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
yaaaaaaaa the query it displayed
but when i upload the pic : an error occur which is : frm-47105 no image name specefied
after that when i go back and change the BOX to an db item,and do these step again,the pic is displayed but the query not!!!so what is the problem now!!!!!
|
|
|
|
| Re: unable to preform query (merged by CM) [message #455640 is a reply to message #455639] |
Wed, 12 May 2010 06:03 |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
and also it display the msg which i wrote it in if statement 'This book does not have a photo on file.'
IF NOT FORM_SUCCESS THEN
MESSAGE('This book does not have a photo on file.');
END IF;
so this mean the form doesn't SUCCESS,,!!!!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: unable to preform query (merged by CM) [message #455676 is a reply to message #455655] |
Wed, 12 May 2010 08:36 |
gregor
Messages: 86
Registered: March 2010
Location: Germany
|
Member |
|
|
hi,
- here an example
to use on the upload-button. Call the function (attached/load_pictures). The Returnvalue can be use to make a Query on a block base the Picturetable.
-- Restrictions: you can only load pictures from "Directroy(ies)", you had definied per "Create DIRECTORY..". The Inputvalue of the function is only the filename.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
