hi all,
when i am executing following procedure it gives me erro :ORA-06512, Please anyone can guide how am i getting this error:
CREATE OR REPLACE PROCEDURE PR_EXEC
AUTHID CURRENT_USER
IS
SQLST VARCHAR2(250);
BEGIN
SQLST:='EXEC schema.nothing(''emp'');';
DBMS_OUTPUT.PUT_LINE(SQLST);
EXECUTE IMMEDIATE SQLST;
COMMIT;
END;
/
SET SERVEROUTPUT ON;
EXEC PR_EXEC;
ERROR at line 1:
ORA-00900: invalid SQL statement
ORA-06512: at "AIQBAL.PR_EXEC", line 13
ORA-06512: at line 1