Search Results

Hello Siva,

I did the same as you suggested and now I am getting the below output -


[ctp-1-zone564:tecnomen] /export/home/tecnomen/> ./callgSPFromScript.sh
1)
last command status : 0...

Hi Siva,

Please find the content of the file below -

[ctp-1-zone564:tecnomen] /export/home/tecnomen/> cat file_return_value
(return status = 1)
ReturnValue
-----------
1
(1...

Hi Siva,

This proc gives below error when I try to create -

Could not execute statement.
Incorrect syntax near 'returning'
Sybase error code=102, SQLState="42000"

I tried this...

yup, same as u suggested.

---------- Post updated at 08:28 AM ---------- Previous update was at 08:25 AM ----------

#!/bin/bash

OUTPUT=$(isql -Usa -Ppassword -DNP_DB << EOF
...

Back to square Siva :) I am getting the same problem (original one) that the RETURN_OUTPUT1 is coming blank. So if I echo RETURN_OUTPUT1 it is blank.

It seems that $? will let us know whether the last shell command executed successfully or not. However my requirement is to catch the return value from the Stored Procedure ran from shell script.
...

I created one dummy procedure just to test the output of stored procedure as given below -

create proc testing1
as
return 1

If I execute this proc on isql prompt it gives
1> exec testing...

Hello Siva,

I modified the code as RETURN_OUTPUT1=$?
Now I am getting RETURN_OUTPUT1=0 always even though the return value from Stored Procedure is 1.

Am I not getting the return value of...

Hard luck, it is same as pervious. Still I am getting blank in the output variable :(

SL_migratePortedNumbers is a Stored Procedure with one argument. However I tried the same code with another Stored Procedure without arguement however for that also I am getting blank in the output...

I added the line to check the Area Code value and it is getting passed successfully.
[ctp-1-zone564:tecnomen] /export/home/tecnomen/> ksh -x migrationBNumFrom10To11Digits.sh -m
+ migrate=false
+...

Kindly find the output after running the script as suggested

[ctp-1-zone564:tecnomen] /export/home/tecnomen/> ksh -x migrationBNumFrom10To11Digits.sh -m
+ migrate=false
+ remove=false
+ echo...

Thank for quick response methyl however I tried putting EOF as suggested by you but of no use. The Stored Procedure is still not running and the output variable is blank :(

Hello all,

I am trying to run stored procrdure from shell script which takes one argument. And also I want to verify in the script whether the script executed successfully. However the Stored...