Created 05-08-2017 07:58 AM
Created 05-08-2017 08:05 AM
Hi
I have installed hplsql and I have created a stored procedure which will drop the table which is in hive but I am getting an eroor when I pass the table name as an argument :-
CREATE OR REPLACE PROCEDURE xmCleanupMatcher(IN name STRING) AS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || name ;
DBMS_OUTPUT.PUT_LINE('Welcome to stored procedure');
END;
/
EXEC xmCleanupMatcher('f_in21');
Here I am passing the table name f_in21 but I am getting an error:-
1:11 cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in table name
This table is already present in hive. If I doesn't pass an argument and specify the table name in the starting then I am not getting an error.
Kindly help me out