PL/SQL Question? Cursors

I am using OCI8.0 to communicate with oracle. I generate SQL statments on a fly.

Example of a statment:
  "SELECT name, date, key1 FROM employee where KEY1 > :1"

I then bind name, date, key1 to the buffer and also :1 to the buffer. Then I execute the statment and perform fetches.

Now the question. how can I reexecute the statment again without perofrming binds again?

Please help me.

P.S.
Please reply to my e-mail address.

daniilf_at_cs.brandeis.edu Received on Thu Jan 21 1999 - 00:00:00 CET