Oracle Error - 6550
399799Aug 1 2003 — edited Aug 2 2003I am having trouble with two procedures. I added a parameter to one that is called by the other, and now I get this error when I try to access the procedure with the new param(both compile fine):
--------------------------------------------------------------------------------
Request Failed
--------------------------------------------------------------------------------
We were unable to process your request at this time.
Error occured while accessing
"/dummy/plsql/dl_submit"
at Fri Aug 01 08:07:43 2003
OWS-05101: Execution failed due to Oracle error -6550
PL/SQL Cartridge SERVICE: PLSQL/PLSQL
PROCEDURE: DL_Submit
PARAMETERS:
===========
SQLSTRING:
Dummy
JOBTYPETXT:
FE_PIPED
CID:
19
Please try again later
here is the code before and after the change.
proc1 - htp.anchor('DL_Submit?SQLString=Dummy' || CHR(38)||'JobtypeTxt=FE_PIPED','Download Records');
Which creates a hyperlink that works fine.
proc2 - CREATE OR REPLACE PROCEDURE DL_Submit
(SQLString IN VARCHAR2, JobTypeTxt IN VARCHAR2) IS
These work fine together.
But when I change them to what is below, I get the error 6550.
New code is underlined.
proc1 - htp.anchor('DL_Submit?SQLString=Dummy' || CHR(38)||'JobtypeTxt=FE_PIPED' || CHR(38) || 'CID=' || seq,'Download Records');
proc2 - CREATE OR REPLACE PROCEDURE DL_Submit
(SQLString IN VARCHAR2, JobTypeTxt IN VARCHAR2, CID IN NUMBER DEFAULT 1) IS
I read somewhere that Oracle may cache the params of procedures and that restarting the server will get rid of the error. Is there another way.