Re: Package or Function LIST is In INvalid State

"mike" <hillmw_at_charter.net> a écrit dans le message de news:1110575121.765271.284060_at_o13g2000cwo.googlegroups.com...
| I am trying to understand how Oracle Functions work.
|
| I created a function using TOAD like:
|
| create or replace function list ( field1 number )
| blah, blah, blah ......
| return res;
| end list;
|
| I got this In my cfquery result;
|
| ORA-06575: Package or function LIST is in an invalid state
|
| What is up with that?
|
| Mike
|

As i previously said:
- you have some compilation errors
- you have to query user_errors view to see what are the errors

So post the result of:
select * from user_source where name='LIST' order by line; select * from user_errors where name='LIST' order by sequence, line;

Michel Cadot Received on Fri Mar 11 2005 - 15:13:50 CST