Hi All,
My Concept is , I just want to selecting name for the parameter I just pass it on run time using external procedure.
1)I have created a sh file. It runs perfectly.
2)Created the Procedure also which calls the .sh file.
3)When I run the procedure I get error.
I showed below.
CaN any one help me out.
.sh file:
----------
vsql -c "select name from test where id=`read id; echo $id`";
output:
-------
[dbadmin@cch1utbia7 malar]$ sh q.sh 1
name
------
a
(1 row)
Create Procedure:
------------------
create procedure a17(arg1 int) as 'q.sh' language 'external' user 'dbadmin';
CREATE PROCEDURE
Executing Procedure:
--------------------
dbadmin=> select a17(1);
INFO 4427: Procedure reported:
Could not execute procedure, errno=8
ERROR 4424: Procedure execution error: exit status=1
Regards,
Malar
Error in Passing perameter to Procedure
Moderator: NorbertKrupa
-
- Newbie
- Posts: 23
- Joined: Mon Feb 04, 2013 10:54 am
-
- Newbie
- Posts: 15
- Joined: Tue May 14, 2013 1:25 pm
Re: Error in Passing perameter to Procedure
I have same issue while executing external procedure.
Please someone suggest with solution
Thanks
Ajit
Please someone suggest with solution
Thanks
Ajit