AnsweredAssumed Answered

How to pass inputs as parameters in Oracle queries using Database operators in ITPAM

Question asked by Vidit_goel on Oct 10, 2016
Latest reply on Apr 24, 2018 by raja-3

Hi All,

 

I want to know how I can pass values as parameters  in Oracle queries using database operators in ITPAM. I have tried '?' to pass the value in inline text and defining the input in parameter set but it doesn't work I guess for oracle.

I tried to use the expression set to pass the value but it is also failing (error: invalid SQL statement).

For e.g. create user test identified by testpaswrd

 

Now, I want to pass the username 'test' and password for that user 'testpaswrd' dynamically as parameters.

If someone has done it, please share your thoughts.

 

Thanks,

Vidit Goel  

Outcomes