Hi all, I have seen in the documentation ocirowcount method works only with update statements. which method should be used for select statement to know the number of rows returned by a select statement. or how to use ocirowcount for select statements. thanks for help babu. --------------------------------- How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! Photos