Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing Varchar Input Parameters To a Procedure

ArieanAug 2 2013 — edited Aug 4 2013

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,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2013
Added on Aug 2 2013
11 comments
13,036 views