Re: referencing variables in SQL queries over network

Pawe?? Krawczyk IPSec.PL wrote:

> Hello! I'm writing an analyzer for Oracle SQL queries over the network
> and I've found queries encoded in such a way:
>
> SELECT * FROM table WHERE x = :1 AND y = :2
>
> These :1 and :2 are variable references. The variable itself seems to
> be encoded in a neighbor packets of the query found on the wire.
>
> Is that encoding documented? Is there any official or unofficial
> description on how to decode this?

Is this annual reinvent the wheel day? What you are doing, likely poorly, has been done very well by Oracle. Read the documentation. And what version?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)