Fri, 27 Nov 2015 06:27:37 GMT ORA-01403: no data found ORA-06512: at "MAIL.SUBSCRIBE", line 36 ORA-06512: at line 22 DAD name: cms PROCEDURE : mail.subscribe URL : http://www.privatelabel.co.za:7777/pls/cms/mail.subscribe PARAMETERS : =========== ENVIRONMENT: ============ PLSQL_GATEWAY=WebDb GATEWAY_IVERSION=3 SERVER_SOFTWARE=Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server GATEWAY_INTERFACE=CGI/1.1 SERVER_PORT=7777 SERVER_NAME=www.privatelabel.co.za REQUEST_METHOD=GET QUERY_STRING= PATH_INFO=/mail.subscribe SCRIPT_NAME=/pls/cms REMOTE_HOST= REMOTE_ADDR=127.0.0.1 SERVER_PROTOCOL=HTTP/1.1 REQUEST_PROTOCOL=HTTP REMOTE_USER=webuser ORACLE_SSO_USER= OSSO_IDLE_TIMEOUT_EXCEEDED= OSSO_USER_GUID= HTTP_CONTENT_LENGTH= HTTP_CONTENT_TYPE= HTTP_USER_AGENT=ia_archiver HTTP_HOST=localhost:7777 HTTP_ACCEPT= HTTP_ACCEPT_ENCODING= HTTP_ACCEPT_LANGUAGE= HTTP_ACCEPT_CHARSET= HTTP_COOKIE= HTTP_IF_MODIFIED_SINCE= HTTP_REFERER= HTTP_SOAPACTION= HTTP_ORACLE_ECID=1448605657:10.0.0.20:12054:0:817,0 HTTP_ORACLE_CACHE_VERSION= HTTP_AUTHORIZATION= WEB_AUTHENT_PREFIX= DAD_NAME=cms DOC_ACCESS_PATH=docs DOCUMENT_TABLE=wpg_document PATH_ALIAS= REQUEST_CHARSET=WE8ISO8859P1 REQUEST_IANA_CHARSET=ISO-8859-1 SCRIPT_PREFIX=/pls HTTP_IF_MATCH= HTTP_CACHE_CONTROL= SOAP_BODY= HTTP_X_ORACLE_DEVICE_CLASS= HTTP_X_ORACLE_DEVICE_ORIENTATION= HTTP_X_ORACLE_DEVICE_MAXDOCSIZE= HTTP_X_ORACLE_DEVICE= HTTP_X_ORACLE_ORIG_ACCEPT= HTTP_X_ORACLE_ORIG_USER_AGENT= HTTP_X_ORACLE_USER_LOCALE= HTTP_X_ORACLE_USER_NAME= HTTP_X_ORACLE_USER_DISPLAYNAME= HTTP_X_ORACLE_USER_USERKIND= HTTP_X_ORACLE_USER_AUTHKIND= HTTP_X_ORACLE_USER_DEVICEID= HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE1= HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE2= HTTP_X_ORACLE_USER_LOCATION_ADDRESSLASTLINE= HTTP_X_ORACLE_USER_LOCATION_BLOCK= HTTP_X_ORACLE_USER_LOCATION_CITY= HTTP_X_ORACLE_USER_LOCATION_COMPANYNAME= HTTP_X_ORACLE_USER_LOCATION_COUNTY= HTTP_X_ORACLE_USER_LOCATION_STATE= HTTP_X_ORACLE_USER_LOCATION_POSTALCODE= HTTP_X_ORACLE_USER_LOCATION_POSTALCODEEXT= HTTP_X_ORACLE_USER_LOCATION_COUNTRY= HTTP_X_ORACLE_USER_LOCATION_TYPE= HTTP_X_ORACLE_USER_LOCATION_X= HTTP_X_ORACLE_USER_LOCATION_Y= HTTP_X_ORACLE_SERVICE_HOME_URL= HTTP_X_ORACLE_SERVICE_PARENT_URL= HTTP_X_ORACLE_HOME_URL= HTTP_X_ORACLE_MODULE_CALLBACK_URL= HTTP_X_ORACLE_MODULE_CALLBACK_LABEL= HTTP_X_ORACLE_CACHE_USER= HTTP_X_ORACLE_CACHE_SUBID= HTTP_X_ORACLE_CACHE_AUTH= HTTP_X_ORACLE_CACHE_DEVICE= HTTP_X_ORACLE_CACHE_LANG= HTTP_X_ORACLE_CACHE_ENCRYPT= HTTP_X_ORACLE_ASSERT_USER=