tags:

views:

25

answers:

0
Q: 

My Oracle 9i package won't compile, says that a user-defined function is out of scope... but it isn't...

I have an Oracle package which contains user-defined functions and procedures, including two user-defined functions which are called from SELECT and UPDATE statements.

The functions in question are defined before the procedures that call them.

This piece of code compiles and works fine on Oracle 10g but won't compile on 9i. The code should work as-is according to Oracle's own documentation.

Any idea why it would throw this error on 9i?

related questions

What do you use to write and edit stored procedures in Oracle?
How do I determine using TSQL what roles are granted execute permissions on a specific stored procedure?
How do I run Oracle plsql procedure from Lisp?
Output parameters not readable when used with a DataReader
How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio?
How do I call MySQL stored procedures from Perl?
Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS's?
Default Integer type in ASP.Net from a Stored Procedure
Should data security be performed on the database side?
How do I conditionally create a stored procedure in SQL Server?
Why is parameterized SQL generated by NHibernate just as fast as a stored procedure?
PHP + MySql + Stored Procedures, how do I get access an "out" value?
SQL file encoding in Visual Studio
T-SQL stored procedure that accepts multiple Id values
SQL Server Fast Forward Cursors
Formatting Stored Procedures
Asynchronous Stored Procedure Calls
Stored Procedure and Timeout
Which is better: Ad hoc queries, or stored procedures?
Query a union table with fields as columns.
Standalone tools for debugging stored procedures
What are the pros and cons to keeping SQL in Stored Procs versus Code
LINQ-to-SQL vs stored procedures?
Insert Update stored proc on SQL Server
Is there any list datatype in MySQL stored procedures, or a way to emulate them?