[NTLUG:Discuss] OT: sql embedded in shell script (sh) passing parameters

[Sean Cook]

* fredjame at concentric.net [2003.09.05 07:39]:
 
> <Code Snippet>
> sqlplus username/password at sid << EOF
> (omitted for brevity)
> AND ih.inv_type = $InvType

Have you tried escaping your quotation...

AND ih.inv_type = \'$InvType\'

> /
> exit
> EOF
> <\Code Snippet>
> 
-- 
I'm sorry, but my karma just ran over your dogma.