3 Replies Latest reply: Mar 15, 2013 1:42 AM by 994648 RSS

    Illegal PLSQL identifer in input

    994648
      Hi there.
      I am trying to run a project on oracle 11g middleware fusion web tier.
      i have 11g database and web tier.

      I have an error. Can any1 help me about this.



      Wed, 06 Mar 2013 07:29:28 GMT

      Illegal PLSQL identifer in input
      DAD name: mre
      PROCEDURE  : plogin.login
      URL        : http://127.0.0.1:7777/pls/mre/plogin.login?wb_srv=M1&plang=0
      PARAMETERS :
      +===========+
      wb_srv:
      M1
      plang:
      +0+

      ENVIRONMENT:
      +============+
      PLSQL_GATEWAY=WebDb
      GATEWAY_IVERSION=2
      SERVER_SOFTWARE=Oracle-Application-Server-11g
      GATEWAY_INTERFACE=CGI/1.1
      SERVER_PORT=7777
      SERVER_NAME=127.0.0.1
      REQUEST_METHOD=GET
      QUERY_STRING=wb_srv=M1&plang=0
      PATH_INFO=/plogin.login
      SCRIPT_NAME=/pls/mre
      REMOTE_HOST=
      REMOTE_ADDR=127.0.0.1
      SERVER_PROTOCOL=HTTP/1.1
      REQUEST_PROTOCOL=HTTP
      REMOTE_USER=pnt01
      ORACLE_SSO_USER=
      OSSO_IDLE_TIMEOUT_EXCEEDED=
      OSSO_USER_GUID=
      HTTP_CONTENT_LENGTH=
      HTTP_CONTENT_TYPE=
      HTTP_USER_AGENT=Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.97 Safari/537.22
      HTTP_HOST=127.0.0.1:7777
      HTTP_ACCEPT=text/html,application/xhtmlxml,application/xml;q=0.9,*/*;q=0.8+
      HTTP_ACCEPT_ENCODING=gzip,deflate,sdch
      HTTP_ACCEPT_LANGUAGE=tr-TR,tr;q=0.8,en-US;q=0.6,en;q=0.4
      HTTP_ACCEPT_CHARSET=ISO-8859-9,utf-8;q=0.7,*;q=0.3
      HTTP_COOKIE=oracle.uix=0^^GMT2:00^p+
      HTTP_IF_MODIFIED_SINCE=
      HTTP_REFERER=
      HTTP_SOAPACTION=
      HTTP_ORACLE_ECID=
      HTTP_ORACLE_CACHE_VERSION=
      HTTP_AUTHORIZATION=
      WEB_AUTHENT_PREFIX=
      DAD_NAME=mre
      DOC_ACCESS_PATH=docs
      DOCUMENT_TABLE=document
      PATH_ALIAS=
      REQUEST_CHARSET=WE8ISO8859P9
      REQUEST_IANA_CHARSET=ISO-8859-9
      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=
        • 1. Re: Illegal PLSQL identifer in input
          994648
          is it about wwv_flow_epg_include_mod_local or apex users?
          i see theese accounts in db console

          APEX_030200 expired
          APEX_PUBLIC_USER expired
          ANONYMOUS expired

          but im using pnt01 account i created. pnt01 has been created like system
          what is the solution for this problem.


          my wwv_flow_epg_include_mod_local is shown below and my user pnt01 have previlige which executes this function.
          i set it "return true;" for all entries. (for now)
          what do i wrong?
          what should i do ?

          thx for ur replies.


          create or replace function apex_030200.wwv_flow_epg_include_mod_local(
          procedure_name in varchar2)
          return boolean
          is
          begin
          return true; -- remove this statement when you modify this function
          --
          -- Administrator note: the procedure_name input parameter may be in the format:
          --
          -- procedure
          -- schema.procedure
          -- package.procedure
          -- schema.package.procedure
          --
          -- If the expected input parameter is a procedure name only, the IN list code shown below
          -- can be modified to itemize the expected procedure names. Otherwise you must parse the
          -- procedure_name parameter and replace the simple code below with code that will evaluate
          -- all of the cases listed above.
          --


          /*ben kapadim*/
          /* if upper(procedure_name) in (
          '') then
          return TRUE;
          else
          return FALSE;
          end if;*/


          end wwv_flow_epg_include_mod_local;
          • 2. Re: Illegal PLSQL identifer in input
            994648
            nobody experienced this problem ? :) plz help.

            Ibrahim. // update
            • 3. Re: Illegal PLSQL identifer in input
              994648
              update