create or replace procedure proc_check
select * from tablename;
I 'm trying to compile this procedure in oracle 9i, but oracle is giving me the error as into clause expected.
If i write query using into clause procedure gets compiled successfully.
Also if is use the cursor then also procedure gets compiled successfully.
Is it possible to return a result set through procedure in oracle ???
since into clause will store only one value and cursor will have only one record......
please suggest me solution so that i can return a resultset (i.e table as a output) in Oracle 9i
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.