Re: obtain the associated table/column for LOB locator

Frank wrote:
> and another question is: In OCI, if given a statement handler, any way
> to obtain the text form of the SQL statment?
>
> Falan

Look at the UTL_REF built-in package. I have a demo in Morgan's Library at www.psoug.org for UTL_REF.DELETE but have not yet written them for LOCK_OBJECT, SELECT, and UPDATE.

I'm thinking SELECT or LOCK_OBJECT might work for you.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)