Hi,
I am trying to use the %p(n) functionality in SQL objects from within a PeopleCode program.
Can you give some examples of how this is used please and how I might be able to use it to dynamically construct the SQL statement conditionally?
I specifically wanted to see if I could use this to pass different clauses to a SQL object, e.g.
SELECT * FROM PS_RECA A
WHERE A.STATUS = 'A'
AND %SQL(%P(1))
Where %P1 can be replaced with something like A.EMPLID IN (SELECT B.EMPLID FROM PS_RECB B).
Any help appreciated.