Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Error - 6550

399799Aug 1 2003 — edited Aug 2 2003
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2003
Added on Aug 1 2003
1 comment
505 views