0
votes
1answer
44 views

What is the format of the data that must be fed to the freetds tool bsqldb?

I need help figuring out how to input my data to bsqldb. I have been looking for a manual or some examples or tutorial but I cant find anything online beside its command line help. I am planning to ...
3
votes
2answers
915 views

Insert to oracle table in a loop

Requirement: In one server in a directory multiple files are present. I need to read the file names and populate into a oracle table. I have written the script like this, but its not working: ...
1
vote
1answer
455 views

Error out shell script if plsql program fails

In the shell script, I am calling a PLSQL stored procedure sqlplus -s <<EOF $v_fcp_login set head off feed off serverout on size 1000000 exec ...
3
votes
2answers
4k views

Replace all occurrences of a character in a variable using korn script

Part of the Korn script I am writing requires that I replace all occurrences of the ' character with two occurrences (''). I am trying to log some SQL that I am generating in this script to a column ...