This discussion is archived
3 Replies Latest reply: Mar 14, 2013 11:42 PM by 994648 RSS

Illegal PLSQL identifer in input

994648 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    nobody experienced this problem ? :) plz help.

    Ibrahim. // update
  • 3. Re: Illegal PLSQL identifer in input
    994648 Newbie
    Currently Being Moderated
    update

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points