Re: call sql oracle 8.i with unix script fails

"Ana C. Dent" <anacedent_at_hotmail.com> schreef in bericht news:Xns98B75773EF9AEanacedenthotmailcom_at_69.28.173.184...
> "Ed Yin" <vraagme_at_hotmail.nl> wrote in
> news:497fd$45a8d9e9$50398baa$23489_at_news.chello.nl:
>
>>
>> "Ana C. Dent" <anacedent_at_hotmail.com> schreef in bericht
>> news:Xns98B6C3B00D8B6anacedenthotmailcom_at_69.28.173.184...
>>> "Ed Yin" <vraagme_at_hotmail.nl> wrote in
>>> news:4abdb$45a7d753$50398baa$18065_at_news.chello.nl:
>>>
>>>> hello,
>>>>
>>>> maybe someone can help me out on this script it will only execute 1
>>>> sql statement depending on what file_name what is wrong with what i
>>>> am trying to do?
>>>>
>>>>
>>>> i try to call a sql like this depending on interface type
>>>>
>>>> this shell is called rim started like this ./rim POR AL
>>>> where POR
>>>> is type en AL = $2 file name in this test
>>>>
>>>>
>>>> $1=INTTYPE
>>>> file_name='test.por'
>>>> typeO=ORD
>>>> typeP=POR
>>>>
>>>> if $1=$typeO
>>>> then
>>>> sqlplus -s / @ord_controle.sql $2 $file_name <<F /
>>>> echo processing $typeO $1 $sql1 $file_name
>>>> else $1=$typeP
>>>> sqlplus -s / @por_controle.sql $2 $file_name <<F /
>>>> echo processing $typeP $1 $sql2 $file_name
>>>> show errors;
>>>> F
>>>> fi
>>>> exit 0
>>>>
>>>> thanks Ed
>>>>
>>>>
>>>>
>>>>
>>>
>>> First make ity work, then make it fancy.
>>> I've done *nix for 20+ years & Oracle for 10+
>>> & for the life of me I have no idea what you are doing.
>>> It kind of appears you are trying some form of here script,
>>> which make absolutely no sense inside a shell's "if" statement.
>>
>> what I am trying to do is this:
>>
>> inside a unix shell there is 1 sql command and it uses processtype
>> parameter $1 , company $2 and parameter $file_name as collected
>> filename wich conatins the data witch we need to process and what i
>> want to try is this
>>
>> if parameter $1 is equal to process type ORD
>> then do
>>
>> "sqlplus -s / @ord_controle.sql $2 $file_name <<F
>> /
>> show errors;
>> F "
>> this sql statement is checking the transmission data form the file in
>> a transmission table and what i want to do is adding next statement or
>> sql inside this shell script.
>>
>>
>> if paramater $1 is equal to POR
>> then next sql is needed to perform checks in database transmission
>> table
>>
>> "sqlplus -s / @por_controle.sql $2 $file_name <<E
>> /
>> show errors;
>> E"
>>
>> extra note is besides the procestype also the extension of the file is
>> differend and i parsed it into parameter $ext but i did not used it.
>>
>> hope even when it is not clear to you it gives an idea what i try to
>> do.
>>
>> thanks Ed
>>
>>
>>
>>
>
> A little knowledge is a dangerous commodity.
> IMO, I would not use in combination @myname.sql AND <<E (here script)
> I use one or the other but NEVER tried using in combination.
> Try "encapsilation" create small working & bulletproof scripts which
> do 1 thing well & one thing only. Call/invoke it when appropriate.
>
> Unless I am still sleep walking, you have NEVER actually stated what is
> wrong. You imply a problem, but I have no idea what you are seeing &
> what you are posting about.
>
> Typically many scripts run in background. I see NO benefit of including
> SHOW ERROR;
> 'cuz your code can't take action based upon its output.

that i have little knowlegde is obvious but only the fool learns from his own mistakes the intelligent one learns from others, so i try to be the second :)

The problem i have with the script i first mentioned was that it only executed the first sql with processtype ORD and not the second when processtype POR was used and parsed to the unix shell.

the show error is used to put down into logging to read and has no other function. The actual control(file data) is done by sql but having said that the unix script has to activate the right sql at first.

The real problem i have is that i am not sure why the processtype "POR" not calls the second sql.

thanks,

Ed Received on Sat Jan 13 2007 - 13:24:12 CST