Re: problem with a query

Ryan Gaffuri wrote:
>
> 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

No error on 8.1.7.2.0, Solaris 6 (SPARC). Patch level and OS at your site?

Regards,

Knut Received on Thu Jun 20 2002 - 08:54:40 CDT