Home » Developer & Programmer » Forms » file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", (oracle database -VERSION 10.2.0.4 (64bit), Application Server Version 10.1.2.0.2)
file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #577645] Tue, 19 February 2013 06:08 Go to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
hello
when i running my form i got this error while i upload pdf using oracle forms

i got this error

file upload failed : ORA-06509:PL/SQL:ICD vector missing for this package ORA-06512:
at "test.utl_RAW".line 224 ORA-0612:at "TEST.WEBUTL_DB",

please help me in this error

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #577649 is a reply to message #577645] Tue, 19 February 2013 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix the error that is at line 224 ORA-0612:at "TEST.WEBUTL_DB".

Regards
Michel

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #577728 is a reply to message #577649] Tue, 19 February 2013 23:16 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
michel can you suggest me how can solve this.give me some hits

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #577741 is a reply to message #577728] Wed, 20 February 2013 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hint: post the code and the call from SQL*Plus.

Regards
Michel

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578260 is a reply to message #577741] Tue, 26 February 2013 03:47 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
hello michel the code is i mention below and error also when i excute my form

declare
	vfilename varchar2(3000);
	vboolean boolean;
	a varchar2(2000);
	b varchar2(2000);
begin
	--SELECT NVL(MAX(ID),0)+1 INTO :AA.ID FROM AA;
	COMMIT_FORM;

	FORMS_DDL('COMMIT'); 
	   
	vfilename := client_get_file_name('c:\',file_filter => 'PDF files (*.pdf)|*.pdf|');
	:LW_PRWISE_TD.FILE_PATH := vfilename;
	
	select  
       rtrim (regexp_substr (:LW_PRWISE_TD.FILE_PATH, '.*\\'), '\') path, 
       replace (:LW_PRWISE_TD.FILE_PATH, regexp_substr (:LW_PRWISE_TD.FILE_PATH, '.*\\')) into a,b FROM DUAL;
--	message(:LW_PRWISE_TD.PWREMDTLSNO_C);
	:LW_PRWISE_TD.FILE_NAME := B;
  :LW_PRWISE_TD.FILE_PATH := vfilename;
  MESSAGE(:LW_PRWISE_TD.FILE_NAME);
		COMMIT_FORM;
--	message(vfilename);
	vboolean := webutil_file_transfer.Client_To_DB_With_Progress
                     (   vfilename, 
                         'LW_PRWISE_TD', 
                         'pdf_BLOB',
                         'PWREMDTLSNO_C = '||:LW_PRWISE_TD.PWREMDTLSNO_C,
                         'Progress',
                         'Uploading File '||vfilename,
                         true,
                         'CHECK_LOB_PROGRESS');
                         FORMS_DDL('COMMIT'); 
                       --	message('after');

	
	COMMIT_FORM;
--	message('rishi');
end;


i got this error

when -custom-item-event triger raised unhandled exception ORA-06509

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578263 is a reply to message #578260] Tue, 26 February 2013 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which line?

Regards
Michel

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578264 is a reply to message #578263] Tue, 26 February 2013 04:02 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
michel forgot this above. its new cording i did in this form and i got this error

when -custom-item-event triger raised unhandled exception ORA-06509

[Updated on: Tue, 26 February 2013 04:08]

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578268 is a reply to message #578264] Tue, 26 February 2013 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without the line I can't help.
Maybe it is more a Forms than a SQL error, so I move the topic to Forms forum.

Regards
Michel

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578269 is a reply to message #578268] Tue, 26 February 2013 04:30 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
ok sure michel actuly this error got to my developer friend. michel its a database level error or its a form level error michel

when -custom-item-event triger raised unhandled exception ORA-06509

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578272 is a reply to message #578269] Tue, 26 February 2013 06:09 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
any help in this error friends

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578429 is a reply to message #578272] Thu, 28 February 2013 00:22 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
hello senior still not receive any help please help me in this error

when -custom-item-event triger raised unhandled exception ora-06509

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578433 is a reply to message #578429] Thu, 28 February 2013 01:06 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure what you expect from us, especially when refusing to specify which line caused the error.
Oracle

ORA-06509: PL/SQL: ICD vector missing for this package

Cause: This indicates a version clash between some package distributed with an Oracle product and the product executable.

Action: Contact Oracle Support Services

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578437 is a reply to message #578433] Thu, 28 February 2013 01:41 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
thanks for givig me reply yeah but acutly sir my code is below

declare
	vfilename varchar2(3000);
	vboolean boolean;
	a varchar2(2000);
	b varchar2(2000);
begin
	--SELECT NVL(MAX(ID),0)+1 INTO :AA.ID FROM AA;
	COMMIT_FORM;

	FORMS_DDL('COMMIT'); 
	   
	vfilename := client_get_file_name('c:\',file_filter => 'PDF files (*.pdf)|*.pdf|');
	:LW_PRWISE_TD.FILE_PATH := vfilename;
	
	select  
       rtrim (regexp_substr (:LW_PRWISE_TD.FILE_PATH, '.*\\'), '\') path, 
       replace (:LW_PRWISE_TD.FILE_PATH, regexp_substr (:LW_PRWISE_TD.FILE_PATH, '.*\\')) into a,b FROM DUAL;
--	message(:LW_PRWISE_TD.PWREMDTLSNO_C);
	:LW_PRWISE_TD.FILE_NAME := B;
  :LW_PRWISE_TD.FILE_PATH := vfilename;
  MESSAGE(:LW_PRWISE_TD.FILE_NAME);
		COMMIT_FORM;
--	message(vfilename);
	vboolean := webutil_file_transfer.Client_To_DB_With_Progress
                     (   vfilename, 
                         'LW_PRWISE_TD', 
                         'pdf_BLOB',
                         'PWREMDTLSNO_C = '||:LW_PRWISE_TD.PWREMDTLSNO_C,
                         'Progress',
                         'Uploading File '||vfilename,
                         true,
                         'CHECK_LOB_PROGRESS');
                         FORMS_DDL('COMMIT'); 
                       --	message('after');

	
	COMMIT_FORM;
--	message('rishi');
end;


and while i upload my pdf file from form level i got this error

Quote:
when -custom-item-event triger raised unhandled exception ORA-06509


i not receive this error you mention here
Quote:

ORA-06509: PL/SQL: ICD vector missing for this package

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578439 is a reply to message #578437] Thu, 28 February 2013 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you are receiving it, see the message you got:

Quote:
when -custom-item-event triger raised unhandled exception ORA-06509


By the way, I doubt Oracle writes "trigger" as "triger".

Regards
Michel

[Updated on: Thu, 28 February 2013 02:00]

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578440 is a reply to message #578439] Thu, 28 February 2013 02:09 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member

michel its just my type mistake

yeah the error is

Quote:
WHEN - CUSTOM - ITEM - EVENT trigger raised unhandled exception ORA-06509

Report message to a moderator

Re: file upload faild ora-06509:PL/SQL:ICD vector missing for this package ora-06512 at "test.ult_raw", [message #578442 is a reply to message #578440] Thu, 28 February 2013 02:39 Go to previous message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And so the solution is:

Quote:
Contact Oracle Support Services


Regards
Michel

Report message to a moderator

Previous Topic: Error Messages
Next Topic: Check box selection for 2 blocks
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 01:52:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.