Error in Passing perameter to Procedure

Moderator: NorbertKrupa

Post Reply
malargopal
Newbie
Newbie
Posts: 23
Joined: Mon Feb 04, 2013 10:54 am

Error in Passing perameter to Procedure

Post by malargopal » Wed Jul 31, 2013 10:52 am

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

ajit_nayak
Newbie
Newbie
Posts: 15
Joined: Tue May 14, 2013 1:25 pm

Re: Error in Passing perameter to Procedure

Post by ajit_nayak » Tue Aug 12, 2014 10:45 am

I have same issue while executing external procedure.

Please someone suggest with solution

Thanks
Ajit

Post Reply

Return to “Vertica External Procedures”