Thread: database function
View Single Post
  #4 (permalink)  
Old 03-18-10, 14:30
anacedent anacedent is offline
Registered User
  
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,150
When using EXECUTE IMMEDIATE it is a Best Practice to construct into a single string variable the complete & valid SQL statement prior to passing it to EXECUTE IMMEDIATE.

use DBMS_OUTPUT.PUT_LINE to display the SQL so it can be manually validated in sqlplus or other client.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote