Hi,
We use GIT bash, so it let us write shell scripts on our windows machine and execute them as in Linux.
We got a requirement where we need to read the file from GIT directory on our local machine and insert its contents into oracle table.
We wrote a shell script which reads the contents of the file and assign them to a shell variable and then opens Sqlplus session and pass the shell variable as an argument like:
sqlplus $Connect_string @sql_file.sql $shell_variable
It works great as long as the length of the content is < 2500 chars. But the file would have > 2500 chars. Is there anyway to achieve it?
Thanks,
DD.