| error while uploading file item from back end using wwsbr_api [message #129967] |
Wed, 27 July 2005 08:22  |
pavani12
Messages: 2
Registered: July 2005
|
Junior Member |
|
|
hi,
i have wrriten the following program
declare
folder_id NUMBER;
caid NUMBER;
v_doc_name VARCHAR2(2000);
v_item_type_id number := 1;
v_item_type_siteid number := 0;
v_item_masterthing_id number;
v_test varchar2(2000);
begin
dbms_output.new_line;
dbms_output.put_line('begin');
dbms_output.put_line('after set context');
select c.id, f.id
into caid, folder_id
from portal.wwsbr_all_content_areas c,
portal.wwsbr_all_folders f
where c.id = f.caid and c.name = 'S_T_PAGE'
and f.name = 'S_PAGE';
portal.wwctx_api_private.set_context('PORTAL');
dbms_output.put_line('after select');
dbms_output.put_line('caid :'||to_char(caid));
dbms_output.put_line('folder_id :'||to_char(folder_id));
v_item_masterthing_id := portal.wwsbr_api.add_item_post_upload(
p_caid => caid,
p_folder_id => folder_id,
p_display_name => 'MY_DISPLAY_NAME',
p_type_id => v_item_type_id,
p_type_caid => v_item_type_siteid,
p_region_id=> 4571,
p_file_name => '21794.LOG'); -- Replace with file name you get in step 3.
dbms_output.put_line('item added : '||to_char(v_item_masterthing_id));
commit;
exception
when portal.wwsbr_api.MISSING_ITEM_TYPE then
dbms_output.put_line('MISSING_ITEM_TYPE');
rollback;
when portal.wwsbr_api.QUOTA_EXCEEDED then
dbms_output.put_line('QUOTA_EXCEEDED');
rollback;
when portal.wwsbr_api.INVALID_PUBLISH_DATE_FORMAT then
dbms_output.put_line('INVALID_PUBLISH_DATE_FORMAT');
rollback;
when portal.wwsbr_api.INVALID_PUBLISH_DATE_VALUE then
dbms_output.put_line('INVALID_PUBLISH_DATE_VALUE');
rollback;
when portal.wwsbr_api.NULL_EXPIRE_NUMBER then
dbms_output.put_line('NULL_EXPIRE_NUMBER');
rollback;
when portal.wwsbr_api.INVALID_EXPIRE_NUMBER then
dbms_output.put_line('INVALID_EXPIRE_NUMBER');
rollback;
when portal.wwsbr_api.NULL_EXPIRE_DATE then
dbms_output.put_line('NULL_EXPIRE_DATE');
rollback;
when portal.wwsbr_api.INVALID_EXPIRE_DATE then
dbms_output.put_line('INVALID_EXPIRE_DATE');
rollback;
when portal.wwsbr_api.INVALID_EXPIRE_DATE_FORMAT then
dbms_output.put_line('INVALID_EXPIRE_DATE_FORMAT');
rollback;
when portal.wwsbr_api.REQD_ATTR_MISSING then
dbms_output.put_line('REQD_ATTR_MISSING');
rollback;
when portal.wwsbr_api.ITEM_CREATION_ERROR then
dbms_output.put_line('ITEM_CREATION_ERROR');
rollback;
when others then
dbms_output.put_line('error : '||rtrim(SQLERRM,50));
rollback;
end;
/
and this program is throwing the exception as
error : ORA-06502: PL/SQL: numeric or value error: character to number conversion error
can u give me the correct code and give me the correct solution
urgently...
|
|
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
