Search Results

Thanks!

Amber Taylor

Thanks for your advice. I was attempting to reuse code :-) that existed in a package. This package normally returns a status and I was trying to pick up that status from the package using a...

Hi,

I am working on a shell script that fires a plsql package. I would like the package to return a value to the shell script and then the shell script to return it to the javascript. Is it...

And the winner is:

if test $all_recs = "NEW";
then
#Flush the table
echo "The Echo"
sqlplus -s $connect_string > /dev/null <<EOF
begin
iws_clean_staging_pkg.iws_clean_staging_prc;
...

I have tried it that way as well with no luck. It's so strange, it's got to be some minor little thing, but for the life of me I can't figure out what it is. I am going to start fresh in the...

patvdv--No problem about that, it gave me something new to try on this mess.

Optimus_P--I tried your suggestion, it still gives the 'then' unmatched error (Error Line number had moved up to that...

What do you mean by "here doc"?

Thanks,

Amber Taylor

Thank you all for taking the time to help me with this.

I am using ksh.

Everthing inside the if statement worked before I tried to enclose it in the if statement.

I did assign the...

Thanks, but I am still getting the same error. I have tried the semicolon's just about every which way I can.

Amber Taylor

Also, $all_recs is a command line argument. I don't know if that makes a difference. Thank you for your earlier reply, I would have never known that spaces were needed inside the brackets!
...

:confused: :confused: :confused: :confused:

Now I am getting the 'then' unmatched again.

Here is exactly what the statement looks like:

if [ "$all_recs" = "NEW" ]
then

# Flush the...

Thank you for your response.


I made the changes you suggested and now I have the syntax error at line 999 : 'if' unmatched. Now the statement looks like:

if ["$all_recs" = "NEW"] then
...

I am having a problem with the following statement in a korn shell script:

if "$all_recs" = "ALL"; then

commands

fi;

I keep getting the error syntax error at line 999 : 'then' unmatched. ...

Thank you, especially for the reference.

Thanks,

Amber Taylor

Thank you for your help. Do you know where to find any kind of online reference for working on ksh files?

Thanks,

Amber Taylor

Hi,

I am trying to do the following in a ksh script:

Loop until (eof)

in_line = current input line from file

Statements.

end loop.



But have been having trouble finding syntax...

Thanks.

I am trying to load a group of files and their last dates modified into a text file that will in turn be used with SQL*Loader to load these files into Oracle. I am using a *.ksh script. I am...