Connecting Tech Pros Worldwide Forums | Help | Site Map

OWS-05101: Execution failed due to Oracle error -6564

Newbie
 
Join Date: Mar 2008
Posts: 3
#1: Mar 20 '08
Hi All,

Iam getting below error when I click on of the button from front end.
Front end pages are developed in PLSQL code.

Procedure which is performing button action event is executing without
any errors in TOAD but its not executing when called from from front end
through browser.

Can anyone gimme solution

Request Failed
--------------------------------------------------------------------------------

We were unable to process your request at this time.


Error occured while accessing
"/ndtt/plsql/url_pkg.goto_page"
at Wed Mar 19 23:45:19 2008

OWS-05101: Execution failed due to Oracle error -6564
ORA-01036: illegal variable name/number

PL/SQL Cartridge SERVICE: ndtt/ndtt
PROCEDURE: url_pkg.goto_page


PARAMETERS:
===========
SESSION_ID:
819397
WEB_PG:
RESULT_PAGE
DEF_PARAM:
pAction=proclogmod&pState=AZ&pSession=819397

Please try again later

amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#2: Mar 20 '08

re: OWS-05101: Execution failed due to Oracle error -6564


Quote:

Originally Posted by umeshchitta

Hi All,

Iam getting below error when I click on of the button from front end.
Front end pages are developed in PLSQL code.

Procedure which is performing button action event is executing without
any errors in TOAD but its not executing when called from from front end
through browser.

Can anyone gimme solution

Request Failed
--------------------------------------------------------------------------------

We were unable to process your request at this time.


Error occured while accessing
"/ndtt/plsql/url_pkg.goto_page"
at Wed Mar 19 23:45:19 2008

OWS-05101: Execution failed due to Oracle error -6564
ORA-01036: illegal variable name/number

PL/SQL Cartridge SERVICE: ndtt/ndtt
PROCEDURE: url_pkg.goto_page


PARAMETERS:
===========
SESSION_ID:
819397
WEB_PG:
RESULT_PAGE
DEF_PARAM:
pAction=proclogmod&pState=AZ&pSession=819397

Please try again later

Are you using any bind variable in your procedure goto_page?
Reply