Hello,
I am not a SQL-Developer but have to create some SQL Queries as part of my job. I want to create a Procedure but something is going wrong. Can you please help me identify the error. Thank you very much.
CREATE OR REPLACE PROCEDURE CONTRACT_PARTNERS
(
USER_INPUT IN VARCHAR2
, RELATION IN VARCHAR2
, OUTPUT OUT VARCHAR2
) AS
v_filter nvarchar2(30);
v_Value NUMBER(10);
BEGIN
v_Value :=
CASE WHEN p_relation= 'eingehend' THEN 'D'
WHEN p_relation = 'ausgehend' THEN 'K'
END
SELECT into OUTPUT
no, name, street,' ' as ADDITION, zipcode,city,' ' as State,country_code, 'Vertragspartner' as CONTLIST
FROM sol_vendor WHERE (company_code like p_userinput OR lower(no) like lower(p_userinput) OR lower(name) like lower(p_userinput)) AND no LIKE 'p_userinput%';
END CONTRACT_PARTNERS;