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 Parameter from Unix to SQL Script

SachinAhujaJan 20 2010 — edited Jan 20 2010
Hi All,

Not sure if this is the right place to put my issue, but thought as it's somewhere related too.

I am calling SQL Script from Unix Shell Script.

From Unix Shell we are also passing parameters to SQL Script, but when there is space in some parameter then it's not preserving the space, it's splitting one parameter to two parameters.

Like if i pass "Account Payables" from Unix then it's making "Account" as one parameter & "Payables" as another parameter. How can I preserve it as one parameter.

Thanks
Sachin Ahuja
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2010
Added on Jan 20 2010
8 comments
10,534 views