Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> referencing variables in SQL queries over network

referencing variables in SQL queries over network

From: Pawe?? Krawczyk IPSec.PL <kravietz_at_echelon.pl>
Date: 15 Apr 2005 07:24:52 -0700
Message-ID: <7fd4fc5c.0504150624.768775c9@posting.google.com>


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? Received on Fri Apr 15 2005 - 09:24:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US