Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

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.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page