Does a server-side stored procedure called from a trigger in a client (form) perform poorer than a server-side stored procedure called from a trigger in the database ?
my procedure will perform intense calculations...
I got 2 data blocks in a single canvas. There's a trigger before update on the first which inserts a row in the second. How to make this insertion immediately visible ? DML return value does not work.
I recommend you this book: "Oracle Database Administration", published at O'Reilly. Some interesting PDFs can be found at www.oracle.com/support...
Good luck !
I heard it was possible to write java stored procedures (load java...). Does the standard release support that ? Do I need to download things ? What about the perfs ? I intend to perform some heavy calculation. Should I go tle old faithful PL/SQL way or may I use java instead ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.