Today, when I wrote a class to operate the Oracle stored procedure, I suddenly found this error.
"/" Application Program Server error.
ORA-06550: 1st rows, 35th columns:
PLS-00103: The symbol "parkid" appears when you need the following:
: =. (@ %;
Symbol ": =" replaced with "parkid.
Note:An error occurred while executing the current Web request. Check the stack trace information to learn about this error andCodeDetailed information about the cause of the error.
Exception details:System. Data. oracleclient. oracleexception: ORA-06550: 1st rows, 35th columns:
PLS-00103: The symbol "parkid" appears when you need the following:
: =. (@ %;
Symbol ": =" replaced with "parkid.
Source error:
Line 472: Results = database. executereader (dbcommand); row 473:} row 474: Catch (exception EX/* Ex */) Row 475: {row 476: // PSB 2006-05-26: shocould we use entlib exceptionpolicy. handleexception?
|
Source file:E: \ newsite \ srctmp \ d3map. Data \ utility. CSRow:474
Stack trace:
[Oracleexception (0x80131938): ORA-06550: 1st rows, 35th columns: PLS-00103: The symbol "parkid" appears when you need the following: =. (@ %; symbol ": =" replaced with "parkid" and then continue.] System. data. oracleclient. oracleconnection. checkerror (ocierrorhandle errorhandle, int32 RC) + 205 system. data. oracleclient. oraclecommand. execute (ocistatementhandle statementhandle, commandbehavior behavior, Boolean needrowid, ocirowiddescriptor & rowiddescriptor, arraylist & resultparameterordinals) + 1024 system. data. oracleclient. oraclecommand. execute (ocistatementhandle statementhandle, commandbehavior behavior, arraylist & resultparameterordinals) + 25 system. data. oracleclient. oraclecommand. executereader (commandbehavior behavior) + 138 system. data. oracleclient. oraclecommand. executedbdatareader (commandbehavior behavior) + 4 system. data. common. dbcommand. executereader (commandbehavior behavior) + 7 Microsoft. practices. enterpriselibrary. data. database. doexecutereader (dbcommand command, commandbehavior describehavior) + 198 Microsoft. practices. enterpriselibrary. data. database. executereader (dbcommand command) + 111 Microsoft. practices. enterpriselibrary. data. oracle. oracledatabase. executereader (dbcommand command) + 74 d3map. data. utility. executereader (database, dbcommand) in E: \ newsite \ srctmp \ d3map. data \ utility. CS: 474 d3map. data. sqlclient. sqlmapparkproviderbase. getbyparkid (transactionmanager, int32 parkid, int32 start, int32 pagelength, int32 & COUNT) in E: \ newsite \ srctmp \ d3map. data. sqlclient \ sqlmapparkproviderbase. generated. CS: 586 d3map. data. bases. mapparkproviderbasecore. getbyparkid (int32 parkid) in E: \ newsite \ srctmp \ d3map. data \ bases \ mapparkproviderbase. generatedcore. CS: 86 test. testmappark () in E: \ newsite \ srctmp \ d3map. website \ test. aspx. CS: 126 test. page_load (Object sender, eventargs E) in E: \ newsite \ srctmp \ d3map. website \ test. aspx. CS: 19 system. web. util. callihelper. eventargfunctioncaller (intptr FP, object o, object T, eventargs e) + 15 system. web. util. callieventhandlerdelegateproxy. callback (Object sender, eventargs e) + 34 system. web. UI. control. onload (eventargs e) + 99 system. web. UI. control. loadrecursive () + 47 system. web. UI. page. processrequestmain (Boolean includestagesbeforeasyncpoint, Boolean includestagesafterasyncpoint) + 1061
|
Version: Microsoft. NET Framework Version: 2.0.50727.42; ASP. NET version: 2.0.50727.42
I have been searching the Internet for a long time, but I have not been able to find the cause,
After a thorough check, I found that I added a space between the stored procedure name "getbyparkid" and wrote it as "getby parkid ".
Here is a review. In the future, write the code carefully. To avoid this situation again.