Are Queries Passed to SQL Databases Parameterized in P6? (Doc ID 2089050.1)

Last updated on DECEMBER 22, 2015

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.4.8.0 and later
Information in this document applies to any platform.

Goal

In P6, are queries passed to SQL databases parameterized?

EXAMPLE

Instead of this:
bookName = "The Name Of My Book";
sqlStatement = "SELECT * FROM books where book_name='" + book_name + "'";

Use this:
sqlStatement = "SELECT * FROM books where book_name=:book;
setParameter(":book", "The Art of Detection");

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms