Pl/SQL and stored Java
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Pl/SQL and stored Java

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    Hi!
    When should Java stored procedures be used instead of PL/SQL stored procedure? Is there any performance gains using java Stored procedures?
    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Requirements dicatate sometime that you use stored proceedures in java

    take a look at thsi examples................

    1) suppose you wnat to get a time to the nearest micro second
    then pl/sql cant help you .you need to use java.....

    2)suppose you need to execute a host command within your code even in this case you need to use java coz currently you cant execute a host command from pl/sql

    there could be many more such examples....probably someone else would post them here

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Smile

    How About Performance?
    There Nothing You cannot Do, The problem is HOW.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    hi sudip

    At my site we dont use java so i am not sure about performance (though i think that java programs are slow )but if you write a java stored proceedure and is stored in the database then i think performance shouldnt be a problem but it requires lots of ram........

  5. #5
    Join Date
    Aug 2000
    Posts
    462
    Oracle generally recommends using PL/SQL where possible and java where necessary. In part this is due to the ability of Oracle to optimize SQL, and their ability to extend the language to fit identified business needs.

    However, java can execute host commands, has better complex-object support and is object oriented.

    Here's a link for java stored procedure beginners:

    http://www.oracle.com/oramag/oracle/...l?o20java.html

  6. #6
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Thanks a lot guys
    There Nothing You cannot Do, The problem is HOW.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width