Can someone explain(or point me to a page that explains) how the best way to pass bind variables from Access and VB to Oracle. When looking thru my sql statements in the sga i am finding SQL that looks like it is using a bind variable but is parsed 200,000 times and executed 200,000 times, so it doesnt seem to be using it correctly. this is the sql from the sga

SELECT "SUBMISSION_KEY" ,"DIARY_ENTRY" FROM "PRODUCTION"."CLM_CLAIM_DIARY" WHERE ("SUBMISSION_KEY" = :1 )


thanks in advance,
SM