how to execute /run the procedure
Folks , a beginner in pl/sql
I have written a package and package body.
I ran the above package and procedure query and it said
sql >package body created
sql > package created
Now i want to execute / run this procedure how will i do the same.
thanks in regards
SQL> exec package_name.procedure_name;
SQL> SET SERVEROUTPUT ON
SQL> EXEC DBMS_OUTPUT.PUT_LINE('Hello');
PL/SQL procedure successfully completed.
Click Here to Expand Forum to Full Width