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

Home -> Community -> Usenet -> c.d.o.server -> Powerbuilder and DisableBind=1

Powerbuilder and DisableBind=1

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Thu, 14 Jan 1999 16:39:41 -0600
Message-ID: <77lrt9$ern$1@news.gte.com>

Why would anybody want to do this in a large OLTP application built in powerbuilder?

Setting this global parameter at connect time disables the use of bind variables, which causes all the usual problems associated with heavy use of literal SQL.

Any Powerbuilder folks out there that might have some insight into why a developer would want to use this, globally?

I can understand the need in certain DSS systems and possibly other queries where we want to inform the optimizer as best we can ( specific value and value ranges instead of "blind" variables ), but system wide, I think not.

-Kevin

--

remove the x for an email reply Received on Thu Jan 14 1999 - 16:39:41 CST

Original text of this message

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