Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » error while uploading file item from back end using wwsbr_api  () 1 Vote
error while uploading file item from back end using wwsbr_api [message #129967] Wed, 27 July 2005 08:22 Go to next message
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...
Re: error while uploading file item from back end using wwsbr_api [message #130364 is a reply to message #129967] Fri, 29 July 2005 09:53 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Does the solution offered at this link relate to your problem?
Re: error while uploading file item from back end using wwsbr_api [message #130365 is a reply to message #129967] Fri, 29 July 2005 09:56 Go to previous message
pavani12
Messages: 2
Registered: July 2005
Junior Member
no it did not offer any reply.........
so, kindly give the solution urgently..

[Updated on: Fri, 29 July 2005 09:56]

Report message to a moderator

Previous Topic: mobile portal
Next Topic: Problem Installation Portal 9i AS
Goto Forum:
  


Current Time: Thu Mar 28 20:33:01 CDT 2024