Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Store a File in BLOB field throught stored procedure - ORA-01460 error

977822Dec 4 2012 — edited Dec 4 2012
The gool is to memorize files in database in BLOB fields . For that we use the folowing stored procedure and Delphi software (ODAC components)

CREATE OR REPLACE
PROCEDURE ADD_DOC (pID_DOC IN INTEGER, pDOC IN BLOB DEFAULT NULL)
IS
BEGIN
BEGIN
INSERT INTO TABLE_DOC ID_DOC, DOC) VALUES ( pID_DOC, pDOC );
EXCEPTION
when OTHERS then
raise_application_error(-20294, '{8}-Erreur lors de l''ajout d''une PJ de la documentation commerciale n° ['||pID_DOC||'] ' ||SQLERRM);
END;
END;

Begin
IF OpenDialog1.Execute = true
then
begin
OraStoredProc1.Params.Clear;
OraStoredProc1.StoredProcName := 'ADD_DOC';
OraStoredProc1.Params.CreateParam(ftInteger,'pID_DOC',ptinput);
OraStoredProc1.Params.CreateParam(ftBlob,'pDOC',ptinput);
OraStoredProc1.ParamByName('pID_DOC').AsInteger := pID_DOC;
OraStoredProc1.ParamByName('pDOC').LoadFromFile(OpenDialog1.FileName, ftBlob);
try
OraStoredProc1.ExecProc;
except
ON E : Exception do
ShowMessage(e.Message);
end;
end;

For files < 32k, no problem, for files > 32k the following message appear :

ORA-01460: unimplemented or unreasonable conversion requested

Thanks for any answer

Edited by: user8273449 on 4 déc. 2012 01:51

Comments

Satish Kandi
Is there a blank space in the path where the installable is located?

If yes, move it to some folder (say c:\temp) without blank space in the path and run from there.

HTH...
704788
Thanks for your reply.

I moved it to a folder and re-ran the setup, but I still get the same error message :(
Satish Kandi
Is there any log generated under c:\program files\oracle\inventory\logs? Can you post last 20 lines from the same?

Also, is there an entry in Windows Event Viewer for this failure? Does the description in that provide any clues?

Check if following link proves useful here.

http://www.eggheadcafe.com/aspnet_answers/windowsmsi/Jul2006/post27539478.asp
704788
- I don't have such a directory

- A number of info events are generated. One of them contains

Windows Installer installed the product. Product Name: Oracle Database 10g Express Edition. Product Version: 10.2.1015. Product Language: 1033. Installation success or error status: 1639.

- Regarding the URL you supplied: I verified that the paths were setup correctly (had to change a couple of them), but it still doesn't work.
Satish Kandi
Answer
Please go through following link (not applicable directly in your case though).

http://support.microsoft.com/kb/326027

HTH...
Marked as Answer by 704788 · Sep 27 2020
704788
"Cleaning" the data in "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion" did the trick!

Thank you! :)
860620
What is the key in this path you deleted to get through this error message HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion, i have the similar problem. Please help at the earliest.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 1 2013
Added on Dec 4 2012
1 comment
311 views