Hi All,
For my requirement , I have to create a stored procedure in database which executes a sql query.
And I have to execute that store procedure in appian process model and have to save that output in process variable to proceed further.
While creating the stored procedure in Database ,I am facing some difficulties.
If I just run the sql query in DB by passing value for input(task_id = 261),then it gives me output of 16 rows with 22 columns , I want that to be saved as output in my process variable as a result.
For this query I written below code to create store proc,
create or replace procedure test(i_task_id in NUMBER)ASBEGINselect column1,column2,column3,.... from xyz where task_id = i_task_id;END;
But this shows me the error like PLS-00428: an INTO clause is expected in this SELECT statement.
Can anyone kindly help me to solve this.Thanks in Advance.
Discussion posts and replies are publicly visible
Is there a specific reason to create a stored procedure here a simple queryEntity would do it?
A stored procedure requires defined inputs and outputs. You need to fetch your data into a output variable. For more support, I visit to check a more database focused forum than this here.
Thanks for your response Stefan.Query entity will work for a table or view right,but I have sql query which takes more time to give output for 1 input alone,that is the reason I not created a view.
OK
The error message says "an INTO clause is expected in this SELECT statement" and I wrote "You need to fetch your data into a output variable".
Did you try that?