Last updated on DECEMBER 22, 2015
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
In P6, are queries passed to SQL databases parameterized?
Instead of this:
bookName = "The Name Of My Book";
sqlStatement = "SELECT * FROM books where book_name='" + book_name + "'";
sqlStatement = "SELECT * FROM books where book_name=:book;
setParameter(":book", "The Art of Detection");
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms