May 2000
Intermediate to advanced
594 pages
11h 32m
English
Content preview from Oracle PL/SQL Programming: A Developer's Workbook
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Intermediate
27-20. | What are some of the similarities and differences between native PL/SQL procedures and external procedures? |
27-21. | How does being able to access external procedures overcome some of the shortcomings of the PL/SQL language? |
27-22. | What steps are necessary to create and call an external procedure? |
27-23. | Are there any disadvantages with the current implementation of external procedures? |
27-24. | When attempting to call an external procedure you just wrote, you receive the following error: ORA-28575: unable to open RPC connection to external procedure agent What could be causing this error, and how can you fix it? |
27-25. | What does the BY REFERENCE option do in the PARAMETERS clause? |
27-26. | How does the concept of dynamic linking make the current implementation of external procedures more efficient? |
27-27. | What advantages are there to placing PL/SQL wrapper procedures inside a package instead of creating them as standalone program units? |
27-28. | You are about to drop a library you believe is not being used by any users. How can you ensure that the library is not referenced by any existing database code before you remove the library? |
27-29. | This problem has a larger scope than most others in this book. It’s a case study involving the following situation: You would like to provide a facility to other programmers to log debugging messages to an operating system file. Your colleague (who is a C programmer) has written a Unix shared library (/usr/local/bin/debug.sl), that contains a procedure ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.