|
|
|
|
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 |
|
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
|
|
|
|
|
|
|
|
|
|
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 |
|
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
|
|
|
|
|
|