Native Dynamic SQL, PL/SQL
IniyavanFeb 19 2010 — edited Feb 19 2010Hi all,
When I try the follwing block to perform a PL/SQL block, it gives the error ORA-06536: IN bind variable bound to an OUT position.
DECLARE
V_SQL VARCHAR2(4000);
V_E_NAME VARCHAR2(100);
BEGIN
V_SQL := 'BEGIN
SELECT EMP_NAME
INTO :1
FROM EMP
WHERE EMP_CODE = :2;
END;';
EXECUTE IMMEDIATE V_SQL USING V_E_NAME, 101;
DBMS_OUTPUT.PUT_LINE('EMP NAME - '||V_E_NAME);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('ERR - '||SQLERRM);
END;
Please help me to overcome this.
Thanks in advance.