By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,648 Members | 2,098 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,648 IT Pros & Developers. It's quick & easy.

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

P: 3
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
Mar 20 '08 #1
Share this Question
Share on Google+
1 Reply


amitpatel66
Expert 100+
P: 2,367
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?
Mar 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.