problem with a query

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 20 Jun 2002 04:56:37 -0700
Message-ID: <1efdad5b.0206200356.77447532@posting.google.com>

problem with a query

I made the following query.. in 8.1.7 from SQLPlus. We have the appropriate version of SQLPlus the error is below. I looked the error up on OTN and I was told to define a variable with the OCI? This lost me. Im not using any variables? Please explain.

--Use with a grain of salt CJG

SELECT
to_number(value) shared_pool_size,

total_object_size, 
total_sql_size, 
total_user_size, 

(total_object_size + total_sql_size +total_user_size)* 1.3
min_req_shared_pool,
(total_object_size + total_sql_size + total_user_size) * 1.3 -
(to_number(value)) "Add This"

FROM
(select sum(sharable_mem) total_object_size from v$db_object_cache) ,
(select sum(sharable_mem) total_sql_size from v$sqlarea) ,
(select sum(250 * users_opening) total_user_size from v$sqlarea) ,
v$parameter
WHERE
name = 'shared_pool_size';

ERROR at line 1:
ORA-24374: define not done before fetch or execute and fetch Received on Thu Jun 20 2002 - 06:56:37 CDT