Informix creates, executes, and deletes a stored procedure instance with Parameters

Informix creates, executes, and deletes a stored procedure instance with Parameters

 

-- Create a second_string stored procedure with Parameters
Create procedure second_string (input char (256 ))
Returning char (256 );
Define var1 char (256 );
Define var2 int;
Let var1 = input;
Let var2 = 1;
While var2 = 1
If substr (var1, 0, 1) = ''then
Return substr (var1, 2 );
End if;
Let var1 = substr (var1, 2 );
End while;
End procedure;
-- Run the second_string stored procedure with parameters.
Execute procedure second_string ('gaaaaaaaaaaaaaa 100 ');
-- Delete the second_string stored procedure with Parameters
Drop procedure second_string (char );