Hello,
I need a clarification on the thread which i marked it as Answered.
I was asked to use single quotes for PROVIDER='6' instead of PROVIDER=6 as mentioned in the thread below for better performance.
But how do i pass the varchar input parameters values to a procedure with single quotes from an application or its not required as Oracle might prefix it by default?
I am thinking of inputting it from application itself but not sure if there is any better approach.
https://forums.oracle.com/message/11131804#11131804
Thanks,