Home » SQL & PL/SQL » SQL & PL/SQL » Procedure undefined-ORA-06550 error (ORACLE)
Procedure undefined-ORA-06550 error [message #289091] Wed, 19 December 2007 10:57 Go to next message
Messages: 1
Registered: December 2007
Junior Member
We have stored procedure that was written for us by a consultant and assured that all we needed to do was pull it into Crystal Reports (XI). Our DBA said that the user we log in as has the proper rights although I'm not sure what those privileges are. However, we continue to get the following error and not really sure what else we should look for. I'm hoping someone might have an idea. TIA!
Database Connector Error:'YU000:[Oracle][ODBC][Ora]ORA-06550:line 1, column 7:
PLS-00221:'X_PAT_LOC" is not a procedure or undefined
ORA-06550:line 1, column 7;
PL/SQL:Statement ignored
[Database Vendor code: 6550]'

I tried to search on Business Objects' website but didn't have any luck.

Re: Procedure undefined-ORA-06550 error [message #289093 is a reply to message #289091] Wed, 19 December 2007 11:09 Go to previous messageGo to next message
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member

So either the procedure is invalid, or you don't have the rights to execute the procedure.
Re: Procedure undefined-ORA-06550 error [message #289099 is a reply to message #289091] Wed, 19 December 2007 12:56 Go to previous message
Messages: 4621
Registered: February 2005
Location: East Coast USA
Senior Member
FOO SCOTT>!oerr ora 6550
06550, 00000, "line %s, column %s:\n%s"
// *Cause:  Usually a PL/SQL compilation error.
// *Action:
Previous Topic: Implementation of PIPELINE table function using array within array
Next Topic: Where is a problem? :)
Goto Forum:

Current Time: Sun Oct 23 07:00:48 CDT 2016

Total time taken to generate the page: 0.10330 seconds