|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
ORA-01846 when upload
Hello
I can't insert document from a web client. This is my files : The file wdbsvr.app (for the DAD) "wdbsvr_TTST.app" 27 lines, 541 characters ; ; $Header: wdbsvr.app 115.2.1155.2 2001/08/31 10:46:21 pkm ship $ ; [WVGATEWAY] defaultDAD = TTST administrators = system adminPath = /admin_/ custom_auth = CUSTOM ; [DAD_TTST_admin] connect_string = TTST ; [DAD_TTST] connect_string = TTST password = ANNO username = ANNO default_page = HTML.page_test document_table = ANNO.documents document_path = docs document_proc = ANNO.cntsample.download upload_as_long_raw = upload_as_blob = * reuse = Yes connmax = 10 ;pathalias = fndgfm ;pathaliasproc = fnd_gfm.dispatch enablesso = No ~ ~ ---------------------------------------------------------------------- I use this script find on Metalink PROCEDURE upload_form IS BEGIN htp.header(3,'Upload a file'); -- This procedure creates a simple HTML form that lets the end user upload his file(s). htp.formOpen(curl => 'CNTSAMPLE.upload', cmethod => 'POST', cenctype => 'multipart/form-data'); htp.p('<INPUT TYPE="FILE" NAME="name">'); htp.formSubmit; htp.formClose; htp.para; htp.header(3,'Upload multiple files'); htp.formOpen(curl => 'cntsample.upload', cmethod => 'POST', cenctype => 'multipart/form-data'); htp.p('<INPUT TYPE="FILE" NAME="name">'); htp.br; htp.p('<INPUT TYPE="FILE" NAME="name">'); htp.br; htp.p('<INPUT TYPE="FILE" NAME="name">'); htp.br; htp.p('<INPUT TYPE="FILE" NAME="name">'); htp.br; htp.p('<INPUT TYPE="FILE" NAME="name">'); htp.br; htp.formSubmit; htp.formClose; EXCEPTION WHEN OTHERS THEN htp.p(sqlerrm); RETURN; END; PROCEDURE upload(name IN owa.vc_arr) IS /* This procedure can upload both one single file as well as multiple files. The actual upload is done by the listener. You simply initialize the process by providing the file to be uploaded. */ i BINARY_INTEGER := 0; BEGIN LOOP i := i + 1; IF name(i) IS NOT NULL THEN htp.p(name(i)||' uploaded'); htp.br; ELSE NULL; END IF; END LOOP; EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN htp.p(sqlerrm); RETURN; END; ---------------------------------------------------------------------- When I click on Submit, I have this error : Wed, 19 May 2004 06:44:47 GMT ORA-01846: not a valid day of the week DAD name: TTST PROCEDURE : cntsample.upload URL : URL PARAMETERS : =========== Why? thank you for help me |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > ORA-01846 when upload |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|