SQL Hard Parsing : How to Analyze

[nj_buck]

I have been very careful to use a strong typing methodology for my cursors and procedures, however I am still getting stored procedure calls come up in the test:

select substr(sql_text,1,20), count(*) from v$sql
group by substr(sql_text,1,20) having count(*) > 100

What I get looks like this:

begin PKG_CLOANOBJECTS.FIND_ACCOUNT(PACCOUNTNBR=>'9791411', ACCOUNT_CURSOR=>:R000C000); end;

The RefCursor is always the same address, however in "PACCOUNTNBR=>'9791411'" the number changes.

Any ideas?

Scott