Home › Forums › Technical › Oracle Related

ORA-06550 Errors

Wed, 2008-07-23 16:40 — mrogers

We are seeing errors like this in our app server logs from Banner Self-Service (for student registration):

[Wed Jul 23 11:03:48 2008] [error] [client blah, blah] mod_plsql: /prod/bwckschd.p_get_crse_unsec HTTP-404 ORA-06550: line 31, column 3:\nPLS-00306: wrong number or types of arguments in call to 'P_GET_CRSE_UNSEC'\nORA-06550: line 31, column 3:\nPLS-00306: wrong number or types of arguments in call to 'P_GET_CRSE_UNSEC'\nORA-06550: line 31, column 3:\nPLS-00306: wrong number or types of arguments in call to 'P_GET_CRSE_UNSEC'\nORA-06550: line 31, column 3:\nPLS-00306: wrong number or types of arguments in call to 'P_GET_CRSE_UNSEC'\nORA-06550: line 31, column 3:\nPLS-00306: wrong number or types of arguments in call to 'P_GET_CRSE_UNSEC'\nORA-06550: line 31, column 3:\nPL/SQL: Statement ignored\n

There is a known Oracle DB bug related to this, and a "fix" is to flush the shared memory pool on Oracle.

Our database is 10g (10.2.0.1). More or less fully updated Banner 7 environment.

Can anyone shed any further light on this for me?

Thanks.

Mark Rogers
U of Manitoba

10g Rel2 OAS - SSO - Banner SSB/INB access ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Sun, 2008-09-28 12:49 — eblack

ORA-06550/PLS-00306 Errors

Hello,

It would seem that this problem (identified as Oracle Bug 4752541)
is fixed in Oracle 10.2.0.3.

See bug fix list link: http://database.in2p3.fr/10203_buglist.htm

This problem was also experienced at the University of Illinois
and identified as bug # 4752541.

There is an excellent Banner/10g Oracle tuning paper available on
the web that mentions this series of errors and the associated bug.

It is "Taming Banner 7 On Oracle 10g" is was presented at SETA
Midwest in 2006 by Scott Harden, University of Illinois.

Thanks,

Earl Black (OCP DBA)