Re: Query Question

From: mike <hillmw_at_charter.net>
Date: 11 Mar 2005 11:57:53 -0800
Message-ID: <1110571073.428045.116880@o13g2000cwo.googlegroups.com>

I am trying to run this from the sql prompt. I am using TOAD.

So, I run the create function list in like I said. It appears to be successful.

Here are my code statistics:

Code Statistics Summary

Count Statistic
----- --------------

• Module Analysis 2 Declarations 6 Statements 1 Stand-alone functions 16 Code lines
• Oracle Version Dependencies 1 v8.1.5
• Declaration Analysis 2 Variables wih default value
• Cursor Analysis 1 Cursor FOR loops using immediate SELECT
• Procedure/Function Analysis 1 Maximum number of RETURN statements in a function
• Built-Ins Utilized 3 FIRST 1 NULL

The I run the sql query:

select fld1, list(fld1) fld2
from crosstab
group by fld1

I get the following message from Oracle: "Package or Function LIST is in an invalid state".

Mike Received on Fri Mar 11 2005 - 13:57:53 CST