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
marilour
Messages: 1
Registered: December 2007
Junior Member
Hi,
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.

Thanks
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
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
http://www.error-code.org.uk/view.asp?e=ORACLE-PLS-00221

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
joy_division
Messages: 4641
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: Wed Dec 07 11:04:21 CST 2016

Total time taken to generate the page: 0.06345 seconds