Oracle set.vpd(%Current User%) in Data Connection

[Stephen Easter]

Hi,

I'm trying to use a data connection instead of an information link because I have a complex query that requires a subquery. I have the SQL written, and the data connection setup however it returns no data because the database requires a set.vpd(%Current User%).

Our information links have a data function that sets the vpd prior to the information link running.

Is there something I can set for the data connection to set the vpd prior to the query running

Thanks!