Skip to 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
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

Chapter 26. Using Java with PL/SQL

One of Oracle8i’s major new features is the ability to store and execute Java programs inside the database, giving Oracle developers another server-side development language (the first language, of course, is PL/SQL). These Java stored procedures (JSPs) open up a whole new realm of potential applications. For example, developers can use the Java networking classes to allow their database applications to communicate directly with network applications, such as a web server, on other computers.

Fortunately for us, Oracle has made PL/SQL and Java interoperable, allowing PL/SQL developers to call JSPs and Java developers to call PL/SQL stored procedures. This chapter tests your ability to define PL/SQL wrappers that allow you to call JSPs within PL/SQL.

Beginner

26-1.

Oracle8i’s Java Virtual Machine is called:

  1. SunSpot

  2. Nova

  3. Aurora

  4. Prometheus

  5. Zeus

26-2.

True or false?

  1. Java performance stinks because you have to download an applet across the network.

  2. You must know Java to take advantage of it in Oracle8i.

  3. You can call Java-stored procedures from a variety of clients, including SQL, PL/SQL, Java applets, Pro*C, Visual Basic, and Oracle Forms.

  4. Except for its ugly syntax, Java is just like PL/SQL.

  5. Java has hundreds of built-in classes to use in your PL/SQL programs.

  6. Java is a replacement for PL/SQL.

  7. Java, like PL/SQL, is a proprietary language controlled by Oracle.

  8. You can run your Java programs on a variety of platforms with very little effort.

  9. Java programs, such as C or C++ ...

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

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’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.
Head of Cybersecurity
QuotationMarkI 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.
Field Engineer
QuotationMarkI’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.
Data Platform Tech Lead
QuotationMarkI'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.
Mark W.
Embedded Software Engineer

You might also like

Oracle Database 12c PL/SQL Advanced Programming Techniques

Oracle Database 12c PL/SQL Advanced Programming Techniques

Michael McLaughlin, John Harper

Publisher Resources

ISBN: 9781449324070Errata Page