session_cahced_cursros behavior for Stored Procedure

 TEST CASE ==========

My environment is a 10.2.0.3 Database. Dedicated.

We have session_cahced_cursros set to 20 and cursor_sharing set to EXACT

Preparation for test invovles creating a brand new table called AON_TEST which contains one column COL1.

We also create a procedure TEST_PROC... which does a simple select from AON_TEST.

Create or replace procedure SCOTT."TEST_PROC"

IS

NumDay number;

BEgin

select col1 into NUMDay from AON_TEST;

End TEST_PROC;

TEST -1

========

SQL> SELECT COL1 FROM AON_TEST ;

SQl> Exec TEST_PROC ;

I verified from the V$SQL. We now see a new entry for the same sql: SELECT COL1 FROM AON_TEST.The old entry from the stand alone query is still in the cache.