Re: Execute Immediate : Can't run ...Please help

From: <pobox002_at_bebub.com>
Date: 22 Apr 2005 13:30:40 -0700
Message-ID: <1114201840.413670.308340@f14g2000cwb.googlegroups.com>

You should not concatenate variable literal values in dynamic SQL like that. It does not use bind variables and your application will fragment the shared pool and not scale. This should simply be static SQL and two queries in the if then else block.

-- 
MJB

Received on Fri Apr 22 2005 - 15:30:40 CDT

This message: [ Message body ]
Next message: jmpXor: "UPDATE using multiple tables"
Previous message: DA Morgan: "Re: Committing an Inner Transaction question without affecting an Outer Transaction."
In reply to: Pial: "Execute Immediate : Can't run ...Please help"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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