Re: Query Question

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 11 Mar 2005 21:59:26 +0100
Message-ID: <423208b3$1$17308$636a15ce@news.free.fr>

"mike" <hillmw_at_charter.net> a écrit dans le message de news:1110571073.428045.116880_at_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
|

Once again, query user_errors.

Michel Cadot Received on Fri Mar 11 2005 - 14:59:26 CST