OS calls with java stored procedures
Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OS calls with java stored procedures
I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the same buffer that DBMS_OUTPUT uses. You call this procedure, then your Java method, and then you can SET SERVEROUTPUT ON to see the output in SQL*Plus or you can read it with DBMS_OUTPUT.GET and DBMS_OUTPUT.GET_LINE. -Original Message- Sent: Tuesday, December 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OS calls with java stored procedures
ummm ... something like
system('`my_code`'); --- check there are backticks ...
Not sure if it will run, but hey ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Tuesday, December 09, 2003 8:35 AM
To: Multiple recipients of list ORACLE-L
Im playing with the example in tom kytes book. we have alot of korn shell scripts that
we use as functions.
We 'echo' out values to standard out. is there anyway to catch this echo with a java
stored procedure? I thought about redirecting it to a file and reading it in with
utl_file, but that makes it more complex.
any other way to do this?
**
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
**4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OS calls with java stored procedures
Yes, it's exec dbms_java.set_output(2000); Richard Ji -Original Message- Sent: Tuesday, December 09, 2003 8:50 AM To: Multiple recipients of list ORACLE-L I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the same buffer that DBMS_OUTPUT uses. You call this procedure, then your Java method, and then you can SET SERVEROUTPUT ON to see the output in SQL*Plus or you can read it with DBMS_OUTPUT.GET and DBMS_OUTPUT.GET_LINE. -Original Message- Sent: Tuesday, December 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tools to Execute Stored Procedures in Debug Mode !
Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tools to Execute Stored Procedures in Debug Mode !
pl/sql developer is not bad. however, its the same debugging stuff as toad. most debugging interfaces are generic. step into, step over, break points, etc... From: Rama, Shreekantha (K.) [EMAIL PROTECTED] Date: 2003/10/13 Mon PM 01:19:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Tools to Execute Stored Procedures in Debug Mode ! Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tools to Execute Stored Procedures in Debug Mode !
dbms_output.put_line ?? joe Rama, Shreekantha (K.) wrote: Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tools to Execute Stored Procedures in Debug Mode !
PL/SQL Developer from allround automations is the best, hands down. Go to http://www.allroundautomations.com for a trial. It's only $150 and it's a whole, integrated PL/SQL development environment. Fantastic program. HTH, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tools to Execute Stored Procedures in Debug Mode !
I really like PL/SQL Developer http://www.allroundautomations.com/plsqldev.html It is only $150 and bundled licenses are even cheaper. HTHs Rich -Original Message- Rama, Shreekantha (K.) Sent: Monday, October 13, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Gesler INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tools to Execute Stored Procedures in Debug Mode !
What she said. Very good tool. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tools to Execute Stored Procedures in Debug Mode ! Try PL/SQL Developer from Allround Automations. The cost is modest and the tool was developed just for Oracle. Vicki Pierce Database Administration x2401 Rama, Shreekantha (K.) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/13/2003 01:19 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Tools to Execute Stored Procedures in Debug Mode ! Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tools to Execute Stored Procedures in Debug Mode !
Try PL/SQL Developer from Allround Automations. The cost is modest and the tool was developed just for Oracle. Vicki Pierce Database Administration x2401 Rama, Shreekantha (K.) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/13/2003 01:19 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Tools to Execute Stored Procedures in Debug Mode ! Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tools to Execute Stored Procedures in Debug Mode !
I have used SQL-Programmer for several years. It was developed by Sylvain-Faust, but they were bought out by BMC. It used to be reasonably priced, but now BMC wants a ton of gold for it. Good tool, but now overpriced. We have also evaluated the SQL Navigator, Quest Software's PL/SQL development tool, but I much preferred SQL-Programmer. HTH, Mike -Original Message- Sent: Monday, October 13, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: c based external procedures vs. Java Stored Procedures
My feeling is that, given the clumsy way external procedures are implemented, the argument of C speed doesn't hold too well. If you must write a function which will be called through IPCs each time you return a row, from instance, C will look javaish in speed. Add to this that static variables cannot be relied upon because the function can be reloaded anytime, that you have to be very careful about the really fun C stuff for fear of interference with Oracle (signals, etc.) - My feeling is that external C functions have no real practical use. If speed is a concern (and it often is) it should be C which calls Oracle, not the reverse. My EUR 0.02 Stephane Faroult - --- Original Message --- - From: Jared Still [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 04 Sep 2003 15:49:26 Or Perl... On Thu, 2003-09-04 at 14:54, Richard Ji wrote: so my question is, are there things you can do with external procedures that you cant do with java? Yes there are, for instance, Java doesn't support raw socket, so if you ever need that you will have to do it in C with external procedure. But what's the chance of anyone is going to use such a thing, very little. In general though, you can do most of the stuff in Java Stored Procedures. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
c based external procedures vs. Java Stored Procedures
Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: c based external procedures vs. Java Stored Procedures
One thing you can do is bypass all of your security if you aren't careful. EXTPROC needs to run as some user other than Oracle (nobody for instance), otherwise you've just created a huge security breach. There are other security implications as well. Even running as 'nobody', you need to ensure that the code is written in a secure manner. As for why you would use them, there are probably more reasons than we can think of here. One that comes to mind is you have data that needs massaged by an algorithm in a purchased library. Rather than writing a whole app to deal with it, you write a wrapper for the purchased functionality and plug it into EXTPROC. You can even do this with Perl. Works very well. :) Jared On Thu, 2003-09-04 at 07:49, [EMAIL PROTECTED] wrote: Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Depends on your developers. We have few JAVA developers, but quite a few C programmers. Plus I've got this great book of math routines in C. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, September 04, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Ryan I'm no expert either. What I heard is that the advantage of external procedures were good where you have something that needs the performance of the underlying system. The C code runs directly on the server, whereas Java is on top of Oracle, which is system-independent. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
We have tested a product this winter that was using an external C proc to call cobol programs. Stephane -Original Message- Jared Still Sent: Thursday, September 04, 2003 11:34 AM To: Multiple recipients of list ORACLE-L One thing you can do is bypass all of your security if you aren't careful. EXTPROC needs to run as some user other than Oracle (nobody for instance), otherwise you've just created a huge security breach. There are other security implications as well. Even running as 'nobody', you need to ensure that the code is written in a secure manner. As for why you would use them, there are probably more reasons than we can think of here. One that comes to mind is you have data that needs massaged by an algorithm in a purchased library. Rather than writing a whole app to deal with it, you write a wrapper for the purchased functionality and plug it into EXTPROC. You can even do this with Perl. Works very well. :) Jared On Thu, 2003-09-04 at 07:49, [EMAIL PROTECTED] wrote: Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Anything stored is always easier to configure then anything external. It shouldn't be easier to use, though. And you should judge where dies it make sense. For reading a simple file 10 times a day (document scanning application at my previous company), a properly written C program (using fork, readv and writev, without fscanf and fprintf bells and whistles) will outperform almost anything else. For taking to other applications, network communication and alike, Java is not significantly slower and is much easier to program. If you want a simple database script, PL/SQL is by far the best solution. And if your goal is to make me like you, use perl. -- Mladen Gogala Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
so my question is, are there things you can do with external procedures that you cant do with java? Yes there are, for instance, Java doesn't support raw socket, so if you ever need that you will have to do it in C with external procedure. But what's the chance of anyone is going to use such a thing, very little. In general though, you can do most of the stuff in Java Stored Procedures. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: c based external procedures vs. Java Stored Procedures
Or Perl... On Thu, 2003-09-04 at 14:54, Richard Ji wrote: so my question is, are there things you can do with external procedures that you cant do with java? Yes there are, for instance, Java doesn't support raw socket, so if you ever need that you will have to do it in C with external procedure. But what's the chance of anyone is going to use such a thing, very little. In general though, you can do most of the stuff in Java Stored Procedures. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to invoke stored procedures from another instance?
That sounds a lot like materialized views. On Thu, 2003-08-28 at 08:14, Igor Neyman wrote: It could be a combination of trigger/pooling. Trigger writes changes locally into some kind queue table. The second instance is pooling this queue table (using db link) at it's own rate without affecting transactions against original table. Also, in this case when network is down, original instance is not affected, and when network restored the second instance picks up where it stopped before network was down. I have this mechanism implemented here, and it works pretty smoothly. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Stephane Faroult Sent: Thursday, August 28, 2003 6:00 AM To: Multiple recipients of list ORACLE-L Hi listers, =20 Assume that there are two instances in Oracle. Both instances are on = different machines and different Oracle versions. There is a table on = first instance. Any update on this table should invoke stored procedures = on the second instance. This should be real time based. Options we = looked at are =20 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism =20 Triggers we would like to avoid. Options we are left with are dbms_alert = and polling mechanism.=20 =20 Is it possible to use dbms_alert in this case? If yes how? =20 Can you think of some kind of polling mechanism which will satisfy the = need of real time communication? Updates on the table is done at a very = fast rate, hence processing should also be at a fast rate. =20 Any help in this regard is very much appreciated. =20 Thanks and Regards, =20 Ranganath =20 I agree with your reluctance to use triggers; the problem is that whenever the second instance is down, then you couldn't do anything on the first. Basically, what you want to implement are near real-time although not quite synchronous snapshots. I have never used DBMS_ALERT in this way, but I think that it would be possible to have a database link on the second instance referencing the first one and invoking DBMS_ALERT through it. Beware with DBMS_ALERT though, my memories are not very fresh but there are some problems with COMMITs (which you can workaround with autonomous transactions, but then the alertee can be woken up by a rolled back transaction, a case which has to be handled by your code); DBMS_PIPE is another solution, which also has its flaws. Avanced queuing seems to me to be a fine mess, but perhaps it's worth a look too. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to invoke stored procedures from another instance?
Hi listers, Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options we looked at are 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism Triggers we would like to avoid. Options we are left with are dbms_alert and polling mechanism. Is it possible to use dbms_alert in this case? If yes how? Can you think of some kind of polling mechanism which will satisfy the need of real time communication? Updates on the table is done at a very fast rate, hence processing should also be at a fast rate. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath MailFiler [RK-FM8B9B3]
RE: How to invoke stored procedures from another instance?
Hi listers, =20 Assume that there are two instances in Oracle. Both instances are on = different machines and different Oracle versions. There is a table on = first instance. Any update on this table should invoke stored procedures = on the second instance. This should be real time based. Options we = looked at are =20 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism =20 Triggers we would like to avoid. Options we are left with are dbms_alert = and polling mechanism.=20 =20 Is it possible to use dbms_alert in this case? If yes how? =20 Can you think of some kind of polling mechanism which will satisfy the = need of real time communication? Updates on the table is done at a very = fast rate, hence processing should also be at a fast rate. =20 Any help in this regard is very much appreciated. =20 Thanks and Regards, =20 Ranganath =20 I agree with your reluctance to use triggers; the problem is that whenever the second instance is down, then you couldn't do anything on the first. Basically, what you want to implement are near real-time although not quite synchronous snapshots. I have never used DBMS_ALERT in this way, but I think that it would be possible to have a database link on the second instance referencing the first one and invoking DBMS_ALERT through it. Beware with DBMS_ALERT though, my memories are not very fresh but there are some problems with COMMITs (which you can workaround with autonomous transactions, but then the alertee can be woken up by a rolled back transaction, a case which has to be handled by your code); DBMS_PIPE is another solution, which also has its flaws. Avanced queuing seems to me to be a fine mess, but perhaps it's worth a look too. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to invoke stored procedures from another instance?
Re: How to invoke stored procedures from another instance?
For this AQ or possibly streams in 9i would be the best, but there is a bit of work to get either set up and functioning the way you want. The big benefit is done right you cant lose a message from one system to the other. This is fundamentally EAI integration without the messaging server. You could effectively though have an EAI adaptor for your application with a bit of additional thought Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Ranganath K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28/08/2003 08:15 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to invoke stored procedures from another instance? Hi listers, Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options we looked at are 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism Triggers we would like to avoid. Options we are left with are dbms_alert and polling mechanism. Is it possible to use dbms_alert in this case? If yes how? Can you think of some kind of polling mechanism which will satisfy the need of real time communication? Updates on the table is done at a very fast rate, hence processing should also be at a fast rate. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath MailFiler [RK-FM8B9B3] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to invoke stored procedures from another instance?
It could be a combination of trigger/pooling. Trigger writes changes locally into some kind queue table. The second instance is pooling this queue table (using db link) at it's own rate without affecting transactions against original table. Also, in this case when network is down, original instance is not affected, and when network restored the second instance picks up where it stopped before network was down. I have this mechanism implemented here, and it works pretty smoothly. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Stephane Faroult Sent: Thursday, August 28, 2003 6:00 AM To: Multiple recipients of list ORACLE-L Hi listers, =20 Assume that there are two instances in Oracle. Both instances are on = different machines and different Oracle versions. There is a table on = first instance. Any update on this table should invoke stored procedures = on the second instance. This should be real time based. Options we = looked at are =20 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism =20 Triggers we would like to avoid. Options we are left with are dbms_alert = and polling mechanism.=20 =20 Is it possible to use dbms_alert in this case? If yes how? =20 Can you think of some kind of polling mechanism which will satisfy the = need of real time communication? Updates on the table is done at a very = fast rate, hence processing should also be at a fast rate. =20 Any help in this regard is very much appreciated. =20 Thanks and Regards, =20 Ranganath =20 I agree with your reluctance to use triggers; the problem is that whenever the second instance is down, then you couldn't do anything on the first. Basically, what you want to implement are near real-time although not quite synchronous snapshots. I have never used DBMS_ALERT in this way, but I think that it would be possible to have a database link on the second instance referencing the first one and invoking DBMS_ALERT through it. Beware with DBMS_ALERT though, my memories are not very fresh but there are some problems with COMMITs (which you can workaround with autonomous transactions, but then the alertee can be woken up by a rolled back transaction, a case which has to be handled by your code); DBMS_PIPE is another solution, which also has its flaws. Avanced queuing seems to me to be a fine mess, but perhaps it's worth a look too. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Guiding principles for using stored procedures in application
Hi List, We want to use lot of stored procedures in the J2EE application that is being developed for any database intensive routines. While it provides high performance, its not easy to maintain and cannot be ported easily to other databases. They are used for queries and items that will require high performance like * Complex routines involving multiple data access and requiring very high performance * Functions which perform large scale operations on many rows In this context I would like to know the guiding principles for using stored procedures in an application. Does anybody know any URLs or documents which explains all that what I need? If so, please let me know. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Guiding principles for using stored procedures in applica
Ranganath, I've done a pile of converting C language routines of the past into stored packages and procedures here and basically I do not see any reason not to go that route. They are easier to maintain than code spread out over many applications and they provide a high degree of insulation of the application from database changes. They also provide a higher degree of security of your data. I'd recommend: Building Intelligent Databases with Oracle PL/SQL (Bk/CD) (2nd Edition) by Kevin T. Owens (Preface) $8.50 (used) from Amazon. Dick Goulet Reply Separator Author: Krishnaswamy; Ranganath [EMAIL PROTECTED] Date: 1/21/2003 2:09 AM Hi List, We want to use lot of stored procedures in the J2EE application that is being developed for any database intensive routines. While it provides high performance, its not easy to maintain and cannot be ported easily to other databases. They are used for queries and items that will require high performance like * Complex routines involving multiple data access and requiring very high performance * Functions which perform large scale operations on many rows In this context I would like to know the guiding principles for using stored procedures in an application. Does anybody know any URLs or documents which explains all that what I need? If so, please let me know. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB Triggers vs Stored Procedures
In a nutshell, it is better to put your code in a stored procedure outside of the trigger. Why? Modular code is easier to reuse. You can't reuse code blocks that are in a trigger. There are other reasons, but this is the biggy IMO. As Ferenc recommended, get the Feurstein book. Jared On Sunday 12 January 2003 22:03, [EMAIL PROTECTED] wrote: Hi All I would like to know the difference between using the Stored procedures in DB Triggers and writing the code directly in the DB Trigger. Which would be better to use and what r the advantages. Rgds Sathya -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DB Triggers vs Stored Procedures
Hi All I would like to know the difference between using the Stored procedures in DB Triggers and writing the code directly in the DB Trigger. Which would be better to use and what r the advantages. Rgds Sathya -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Triggers vs Stored Procedures
Read THIS fabulous manual: http://www.bookpool.com/.x/pbsr99hds8/sm/0596003811 Ferenc Mantfeld -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject:DB Triggers vs Stored Procedures Hi All I would like to know the difference between using the Stored procedures in DB Triggers and writing the code directly in the DB Trigger. Which would be better to use and what r the advantages. Rgds Sathya -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
calling Oracle stored procedures from ASP/ADO
Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling Oracle stored procedures from ASP/ADO
I found this, I hope it helps, I will need this also some time soon: http://groups.google.com/groups?q=stored%2Bprocedure%2Boracle%2Bado%2Bparame tersstart=20hl=enlr=ie=UTF-8oe=UTF-8selm=%23Q%23RLKqACHA.2228%40tkmsft ngp02rnum=21 -Original Message- Sent: Wednesday, November 27, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling Oracle stored procedures from ASP/ADO
Why are you / he / sh using ODBC ? OO4O is far superior and can make native DB calls using OCI, etc, at least that is what the VB guru contrator I have hired tells me, and I trust him. He says that ODBC compared to OO4O is a POS. The code he has written for me works like a charm, calls Oracle functions and SP with no problems, using in, out and in/out arguments Ferenc Mantfeld -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 28, 2002 6:15 AM To: Multiple recipients of list ORACLE-L Subject:calling Oracle stored procedures from ASP/ADO Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling Oracle stored procedures from ASP/ADO
I was told the OO4O is very rich and very slow. Do not know if it's true. Waleed -Original Message- Sent: Wednesday, November 27, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Why are you / he / sh using ODBC ? OO4O is far superior and can make native DB calls using OCI, etc, at least that is what the VB guru contrator I have hired tells me, and I trust him. He says that ODBC compared to OO4O is a POS. The code he has written for me works like a charm, calls Oracle functions and SP with no problems, using in, out and in/out arguments Ferenc Mantfeld -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 28, 2002 6:15 AM To: Multiple recipients of list ORACLE-L Subject:calling Oracle stored procedures from ASP/ADO Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling Oracle stored procedures from ASP/ADO
Thanks Waleed, I've passed it on. Jared Khedr, Waleed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/27/2002 11:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: calling Oracle stored procedures from ASP/ADO I found this, I hope it helps, I will need this also some time soon: http://groups.google.com/groups?q=stored%2Bprocedure%2Boracle%2Bado%2Bparame tersstart=20hl=enlr=ie=UTF-8oe=UTF-8selm=%23Q%23RLKqACHA.2228%40tkmsft ngp02rnum=21 -Original Message- Sent: Wednesday, November 27, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: calling Oracle stored procedures from ASP/ADO
Hi Jared, The following will work assuming you're using the Oracle OLE DB Provider. Note that this is _not_ the same thing as OO40 - Oracle Objects for OLE or as I like to call it Oracle Oily Objects =8-) I had a little trouble getting it going until I hard-coded the enumerated values for datatype and command type. I'm not an ASP whiz but it seems I'm probably just missing an include for some ADO manifests Cheers Connected to: Oracle8i Personal Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production SQL create table test_table (field1 varchar2(2000)); Table created. SQL create or replace procedure test_proc (param in varchar2) as 2 begin 3insert into test_Table values (param); 4 end; 5 / ASP Code - begins html body form action=default.asp method=get Your name: input type=text name=fname size=20 input type=submit value=Submit /form % set objConn = server.createObject(adodb.Connection) ObjConn.ConnectionString=Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=username;Password=password;Data Source=ORCL objConn.open dim fname fname=Request.QueryString(fname) If fname Then set rs = Server.CreateObject(ADODB.command) set para = Server.CreateObject(ADODB.Parameter) para.Type=200 para.Size=20 para.Direction=1 para.Value=fname rs.CommandText = Test_Proc rs.CommandType = 4 rs.ActiveConnection = objConn rs.Parameters.Append para rs.execute set rs = nothing set para = nothing objConn.close set objConn = nothing Response.Write(Hello fname !br /) Response.Write(How are you today?) End If % /body /html HTH Jeff Herrick ps...good site is http://www.w3schools.com/ado/default.asp On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote: Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling Oracle stored procedures from ASP/ADO
I'm already in up to my neck supporting this developer. He knows next to nothing about Oracle, and it's been rather frustrating. Partly my own fault, I thought he did OK in the interview and would pick up the Oracle differences. Problem is, he doesn't seem to interested in doing so. sigh... I don't want to throw 'new' technology into the mix. Jared mantfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/27/2002 12:16 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: calling Oracle stored procedures from ASP/ADO Why are you / he / sh using ODBC ? OO4O is far superior and can make native DB calls using OCI, etc, at least that is what the VB guru contrator I have hired tells me, and I trust him. He says that ODBC compared to OO4O is a POS. The code he has written for me works like a charm, calls Oracle functions and SP with no problems, using in, out and in/out arguments Ferenc Mantfeld -Original Message- Sent:Thursday, November 28, 2002 6:15 AM To: Multiple recipients of list ORACLE-L Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: calling Oracle stored procedures from ASP/ADO
Not to all another reference point but if there is any place to use Oracle Objects For OLE (oo4o). A good reference is http://groups.yahoo.com/group/oo4ole/ This group has sample code and answers to most of the common questions. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 4:44 PM I'm already in up to my neck supporting this developer. He knows next to nothing about Oracle, and it's been rather frustrating. Partly my own fault, I thought he did OK in the interview and would pick up the Oracle differences. Problem is, he doesn't seem to interested in doing so. sigh... I don't want to throw 'new' technology into the mix. Jared mantfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/27/2002 12:16 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: calling Oracle stored procedures from ASP/ADO Why are you / he / sh using ODBC ? OO4O is far superior and can make native DB calls using OCI, etc, at least that is what the VB guru contrator I have hired tells me, and I trust him. He says that ODBC compared to OO4O is a POS. The code he has written for me works like a charm, calls Oracle functions and SP with no problems, using in, out and in/out arguments Ferenc Mantfeld -Original Message- Sent:Thursday, November 28, 2002 6:15 AM To: Multiple recipients of list ORACLE-L Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
java stored procedures
This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Rachel, Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). I don't have any gotchas but some tidbits AFAIK. You'll need the SQLJ, JDBC drivers, and JDK running machine used for development and your 8i running the JServer option as well Net8 or above. You'll be stuck with JDK 1.2.X as it is the common JDK supported by 8.17 and 9i versions of SQLJ. Cheers, Thom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farrell, Thomas M.Mr. NGB-ARNG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Actually, Java is not so bad idea. Aurora does pretty much the same thing as PL/SQL and it is very hard to get to OS or network because security doesn't let you. On the plus side, bad programs in Java are more portable then the ones in PL/SQL. IDE software for Java is better suited for duhvelopers then the one for PL/SQL. You will have to increase Java pool and you will have to increase system tablespace because your developers will start abusing loadjava almost instantly and start loading .jar files (like for XML, for instance). Also, your CPU and RAM usage will go up fairly quickly so you might consider convincing your boss to finally do that HW upgrade. Expect attempts to use thin JDBC driver. The nice features of the thin driver are a) It's written entirely in Java, which makes it much slower then an optimized C code like OCI driver and, therefore, preferred by duhvelopers in the name of generality and universality. Stupidity is another very universal thing. b) The thin driver can only use dedicated server connection which does miracles for load balancing. There is connection pooling, which also requires dedicated server to work. Because it cannot use MTS and TNS in general, thin driver must have a hard-wired connection string written in the code or parameter file, which apparently doesn't diminish generality and universality. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Subject: java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
You'll be stuck with JDK 1.2.X as it is the common JDK supported by 8.17 and 9i versions of SQLJ. However, the 9iR2 OUI will ask for JDK Home for JDK/SDK Ver 1.3.1. Check Note# 201110.1 on Metalink. - Kirti -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:33 AM To: Multiple recipients of list ORACLE-L Rachel, Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). I don't have any gotchas but some tidbits AFAIK. You'll need the SQLJ, JDBC drivers, and JDK running machine used for development and your 8i running the JServer option as well Net8 or above. You'll be stuck with JDK 1.2.X as it is the common JDK supported by 8.17 and 9i versions of SQLJ. Cheers, Thom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Mladen, Thanks -- one thing I can be sure of is that they won't start loading files, at least in staging and production, because I haven't given them (nor will the data center do so) permission. Everything has to do through either me or change control procedures. Or both. I knew about the java pool. This is a brand new system so asking for a hardware upgrade is not likely. They want to call this function every time someone does a search on the site. This goes back to the discussion I had a week or so ago about the diacritical marks, the developer thinks people will be entering them... cut and paste? Not likely. Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: Actually, Java is not so bad idea. Aurora does pretty much the same thing as PL/SQL and it is very hard to get to OS or network because security doesn't let you. On the plus side, bad programs in Java are more portable then the ones in PL/SQL. IDE software for Java is better suited for duhvelopers then the one for PL/SQL. You will have to increase Java pool and you will have to increase system tablespace because your developers will start abusing loadjava almost instantly and start loading .jar files (like for XML, for instance). Also, your CPU and RAM usage will go up fairly quickly so you might consider convincing your boss to finally do that HW upgrade. Expect attempts to use thin JDBC driver. The nice features of the thin driver are a) It's written entirely in Java, which makes it much slower then an optimized C code like OCI driver and, therefore, preferred by duhvelopers in the name of generality and universality. Stupidity is another very universal thing. b) The thin driver can only use dedicated server connection which does miracles for load balancing. There is connection pooling, which also requires dedicated server to work. Because it cannot use MTS and TNS in general, thin driver must have a hard-wired connection string written in the code or parameter file, which apparently doesn't diminish generality and universality. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Subject: java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official
Re: java stored procedures
We have several developers using java stored procedures. No real 'gotchas' other than making sure all of the java versions are correct. Java is essentially dumbed down C++. Why folks want to go to the extra steps coding baffles me since PL/SQL is much more powerful inside the database. But, there is a lot to be said for portability. Especially, when the final envirnoment is yet to be determined. --- Rachel Carmichael [EMAIL PROTECTED] wrote: This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
b) The thin driver can only use dedicated server connection which does miracles for load balancing. Where did you get that? Thin driver works with MTS. There are configuration issues working with MTS that only thin driver encounters. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Rachel I agree with Mladen. Java as a programming language is good. It has a good long-range forecast compared with alternatives. We are getting ready to dump 20 years our company has invested in COBOL on one system. Making sure you write your code in a language that will be around 20 years from now is more important than most of us know. As to writing database stored procedures in Java, the situation is a little more iffy. Compared with PL/SQL, most reports I hear is that usually PL/SQL is faster. No surprise since PL/SQL is doing exactly what it was developed to do. If speed is critical, I would say go with PL/SQL. If speed isn't so critical, then a Java servlet on an application server may be fast enough. Which means the value of Java stored procedures may not be as great as you might assume. This is what I have figured out so far, look forward to opinions of others. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Actually, Java is not so bad idea. Aurora does pretty much the same thing as PL/SQL and it is very hard to get to OS or network because security doesn't let you. On the plus side, bad programs in Java are more portable then the ones in PL/SQL. IDE software for Java is better suited for duhvelopers then the one for PL/SQL. You will have to increase Java pool and you will have to increase system tablespace because your developers will start abusing loadjava almost instantly and start loading .jar files (like for XML, for instance). Also, your CPU and RAM usage will go up fairly quickly so you might consider convincing your boss to finally do that HW upgrade. Expect attempts to use thin JDBC driver. The nice features of the thin driver are a) It's written entirely in Java, which makes it much slower then an optimized C code like OCI driver and, therefore, preferred by duhvelopers in the name of generality and universality. Stupidity is another very universal thing. b) The thin driver can only use dedicated server connection which does miracles for load balancing. There is connection pooling, which also requires dedicated server to work. Because it cannot use MTS and TNS in general, thin driver must have a hard-wired connection string written in the code or parameter file, which apparently doesn't diminish generality and universality. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Subject: java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
Re: java stored procedures
oh we are definitely Oracle/Sun, it's just that the servers are just now being installed --- Peter Barnett [EMAIL PROTECTED] wrote: We have several developers using java stored procedures. No real 'gotchas' other than making sure all of the java versions are correct. Java is essentially dumbed down C++. Why folks want to go to the extra steps coding baffles me since PL/SQL is much more powerful inside the database. But, there is a lot to be said for portability. Especially, when the final envirnoment is yet to be determined. --- Rachel Carmichael [EMAIL PROTECTED] wrote: This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Last time I checked, it was using the old SQL*Net 1.1 syntax, namely hostname:sid:port and the server was always a dedicated one, especially if the connection pooling was turned on. -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: java stored procedures b) The thin driver can only use dedicated server connection which does miracles for load balancing. Where did you get that? Thin driver works with MTS. There are configuration issues working with MTS that only thin driver encounters. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
Why not use intermedia? Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2002 06:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
No, besides the hostname:sid:port syntax, you can also use the long connect string jdbc:oracle:thin:@(description=(address=(host= ... syntax. And it works with both MTS and dedicated server. Richard Ji -Original Message- Sent: Thursday, September 05, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Last time I checked, it was using the old SQL*Net 1.1 syntax, namely hostname:sid:port and the server was always a dedicated one, especially if the connection pooling was turned on. -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: java stored procedures b) The thin driver can only use dedicated server connection which does miracles for load balancing. Where did you get that? Thin driver works with MTS. There are configuration issues working with MTS that only thin driver encounters. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
a) because it's not installed or licensed b) because it won't do the conversions to the data that he wants c) because unless Oracle Text has significantly improved in speed since the last time I tried it, it's not fast enough I got him to agree to run the java code that processes the data OUTSIDE the database and then sqlload the resultant file into the search table --- [EMAIL PROTECTED] wrote: Why not use intermedia? Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2002 06:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
From aesthetic point of view, writing the whole TNS descriptor into the code is completely and utterly disgusting, something like mandatory cavity searches as a part of improved airport security. -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 4:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: java stored procedures No, besides the hostname:sid:port syntax, you can also use the long connect string jdbc:oracle:thin:@(description=(address=(host= ... syntax. And it works with both MTS and dedicated server. Richard Ji -Original Message- Sent: Thursday, September 05, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Last time I checked, it was using the old SQL*Net 1.1 syntax, namely hostname:sid:port and the server was always a dedicated one, especially if the connection pooling was turned on. -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: java stored procedures b) The thin driver can only use dedicated server connection which does miracles for load balancing. Where did you get that? Thin driver works with MTS. There are configuration issues working with MTS that only thin driver encounters. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures
Not saying it's a good thing to do. You mentioned thin driver doesn't work with MTS which is not true. Just want to point it out. Best Regards -Original Message- Sent: Thursday, September 05, 2002 5:39 PM To: Multiple recipients of list ORACLE-L From aesthetic point of view, writing the whole TNS descriptor into the code is completely and utterly disgusting, something like mandatory cavity searches as a part of improved airport security. -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 4:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: java stored procedures No, besides the hostname:sid:port syntax, you can also use the long connect string jdbc:oracle:thin:@(description=(address=(host= ... syntax. And it works with both MTS and dedicated server. Richard Ji -Original Message- Sent: Thursday, September 05, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Last time I checked, it was using the old SQL*Net 1.1 syntax, namely hostname:sid:port and the server was always a dedicated one, especially if the connection pooling was turned on. -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: java stored procedures b) The thin driver can only use dedicated server connection which does miracles for load balancing. Where did you get that? Thin driver works with MTS. There are configuration issues working with MTS that only thin driver encounters. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
Rachel, From 8i+, I don't think that Intermedia is a separately licensed product. e.g. You already paid for it. Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2002 01:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: java stored procedures a) because it's not installed or licensed b) because it won't do the conversions to the data that he wants c) because unless Oracle Text has significantly improved in speed since the last time I tried it, it's not fast enough I got him to agree to run the java code that processes the data OUTSIDE the database and then sqlload the resultant file into the search table --- [EMAIL PROTECTED] wrote: Why not use intermedia? Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2002 06:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: java stored procedures
Jated, Okay, because I don't know anything about it and we are supposed to go into staging/load testing by the end of this month? He is a brand new project manager and very smart but very inexperienced in the concepts of project planning and functional specs Rachel --- [EMAIL PROTECTED] wrote: Rachel, From 8i+, I don't think that Intermedia is a separately licensed product. e.g. You already paid for it. Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2002 01:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: java stored procedures a) because it's not installed or licensed b) because it won't do the conversions to the data that he wants c) because unless Oracle Text has significantly improved in speed since the last time I tried it, it's not fast enough I got him to agree to run the java code that processes the data OUTSIDE the database and then sqlload the resultant file into the search table --- [EMAIL PROTECTED] wrote: Why not use intermedia? Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2002 06:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:java stored procedures This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site. Besides the fact that this is the first I've heard of the request, and that I think he is reinventing the wheel in what he wants to do in this procedure (normalize text data that we already GET normalized elsewhere), and that we are supposed to go into QA testing by the end of the month and he STILL hasn't locked down the schema etc Personal prejudices aside, I've heard vague rumblings that Java in the database is not optimal. We'll be in 9iR2, although he's developing against an 8.1.7 database (don't ask, I'm not responsible for that database other than to provide him with schema ddl, there IS no real development server here). Before I categorically say no or yes, are there any gotchas I need to look out for? Thanks Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
using stored procedures from pro*c
Title: using stored procedures from pro*c When calling a stored procedure (to do a select) from a pro*c program, does the sqlca.sqlerrd[2] row counter get set? Or does that happen only if you are putting the selects into the Pro*C program? It seems to act differently for different versions. It is working for Oracle 7.2, but does not appear to function that way on the 8.1.7. Anbody have any insight. Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing.
Re: using stored procedures from pro*c
Title: using stored procedures from pro*c It is meaningless. PL/SQL blocks handle their own cursors within a single cursor employed by PRO*C, so the contents of "sqlca.sqlerrd[2]" are likely leftover from a previous call? You may have gotten the value you wanted in one version, but I wouldn't count on that functionality surviving from version to version... From the "PRO*C Reference" for v9.2 (page c-12): For the purposes of cursor management, an embedded PL/SQL block is treated just like a SQL statement. When an embedded PL/SQL block is executed, a parent cursor is associated with the entire block and a link is created between the cache entry and the private SQL area in the PGA for the embedded PL/SQL block. Be aware that each SQL statement inside the embedded block also requires a private SQL area in the PGA. These SQL statements use child cursors that PL/SQL manages itself. The disposition of the child cursors is determined through its associated parent cursor. That is, the private SQL areas used by the child cursors are freed after the private SQL area for its parent cursor is freed. - Original Message - From: Adams, Matthew (GEA, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 31, 2002 2:28 PM Subject: using stored procedures from pro*c When calling a stored procedure (to do a select) from a pro*c program, does the sqlca.sqlerrd[2] row counter get set? Or does that happen only if you are putting the selects into the Pro*C program? It seems to act differently for different versions. It is working for Oracle 7.2, but does not appear to function that way on the 8.1.7. Anbody have any insight. Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing.
Stored Procedures/Functions
Dear Gurus How would one monitor when and who may be executing a stored procedure/package etc at any one point in time. Similar to table locks although thats more straightforward to monitor. Pls advise Thanks in Advance IMPORTANT: This e-mail (including all attachments) is confidential and may be privileged. It may be read, copied and used only by the intended recipients, and must not be re-transmitted in any form without our consent. If you have received it in error, please contact us immediately by return e-mail. Please then delete it and do not disclose its contents to any other person. Security and reliability of email is not guaranteed. Communications should be verified from a mailed or faxed copy. All emails to anyone @vitol.com are communications to the firm and are not private or confidential to any named individual. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Easaw T Mathew INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Message logging in stored procedures
Robert Monical wrote: Hello, Finally moving from Oracle 7 to 8 or 9 (probably 9). We currently use DBMS_PIPE and a scheduled job to empty the pipe and store the messages. Works fine in our application but I need to eventually make some improvements. Are there any new features in the newer Oracles to support this requirement? TIA Autonomous transactions. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Message logging in stored procedures
Hello, Finally moving from Oracle 7 to 8 or 9 (probably 9). We currently use DBMS_PIPE and a scheduled job to empty the pipe and store the messages. Works fine in our application but I need to eventually make some improvements. Are there any new features in the newer Oracles to support this requirement? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Stored Procedures
Well, I finally got permissions to use stored procedures in one of our projects. Problem is, I'm not all that butch when it comes to SP's, so, the question is. Do any of you have any links to good tutorials that shows how to best utilize them? Would like to see some examples on what you can do with them. In our case they will be very simple. Would be gratefull for any pointers :) Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jakobsson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Encrypting Oracle Stored procedures
Dear All, Can anyone please tell me how to encrypt oracle stored procedures Thanks Regards, Brijesh __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Encrypting Oracle Stored procedures
Use the wrap executable in ORACLE_HOME/bin. Dick Goulet Reply Separator Author: Brijesh Lal [EMAIL PROTECTED] Date: 1/21/2002 5:25 AM Dear All, Can anyone please tell me how to encrypt oracle stored procedures Thanks Regards, Brijesh __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Encrypting Oracle Stored procedures
Hi, Oracle supplied us with the utility WRAP(80) to do this. It scrammbles everything between begin and end. Jack Brijesh Lal [EMAIL PROTECTED]@fatcity.com on 21-01-2002 14:25:20 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Dear All, Can anyone please tell me how to encrypt oracle stored procedures Thanks Regards, Brijesh __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Encrypting Oracle Stored procedures
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a77069/c_wrap.htm#1859 Szecsy Tamas -Original Message- Sent: Monday, January 21, 2002 14:25 To: Multiple recipients of list ORACLE-L Dear All, Can anyone please tell me how to encrypt oracle stored procedures Thanks Regards, Brijesh __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
call vs execute - stored procedures
I am working up a script to run the dbms_stats.gather_database_stats() procedure and have run into something for which I haven't yet found an explanation. Maybe someone here can tell me why I can run dbms_stats.gather_database_stats from Python like this (Perl would be similar, I believe, since I found the fix in a Perl list archive) cursor.execute(BEGIN dbms_stats.gather_database_stats(); END; ) but not like this: cursor.execute(call dbms_stats.gather_database_stats()) Call works for other stored procedures, dbms_utility.analyze_schema() for instance, but not for dbms_stats. So, what's the difference? Thanks, Glenn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: call vs execute - stored procedures
Glenn, I believe that CALL needs to be terminated with a semicolon. Jared Glenn Stauffer stauffer@swart To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hmore.educc: Sent by: Subject: call vs execute - stored procedures [EMAIL PROTECTED] m 01/16/02 08:55 AM Please respond to ORACLE-L I am working up a script to run the dbms_stats.gather_database_stats() procedure and have run into something for which I haven't yet found an explanation. Maybe someone here can tell me why I can run dbms_stats.gather_database_stats from Python like this (Perl would be similar, I believe, since I found the fix in a Perl list archive) cursor.execute(BEGIN dbms_stats.gather_database_stats(); END; ) but not like this: cursor.execute(call dbms_stats.gather_database_stats()) Call works for other stored procedures, dbms_utility.analyze_schema() for instance, but not for dbms_stats. So, what's the difference? Thanks, Glenn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
java stored procedures and running rsh command
I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures and running rsh command
You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients of list ORACLE-L I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures and running rsh command
Kimberly, What is the format for the .rhosts file? I'm actually trying to work on something right as we speak. If I remember correctly the file gets stored on the server that you want to connect to and the contents are just: ip username where username is the name that you are logged in as on the server your COMING from if that makes any sense. Is this correct? Cheers, Kev. 'In Windows none can hear you scream' -Original Message- Sent: 09 January 2002 15:12 To: Multiple recipients of list ORACLE-L You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients of list ORACLE-L I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java stored procedures and running rsh command
Its either hostname username or vice versa. You really only need the user name if its not the same. For example, almost all my systems use oracle as the Unix account but some turkey decided to make one oracleq. So I need to specify that one. You should be able to do a man on .rhosts or rsh and find out. I don't have outside access to my systems anymore. Also, I believe on most OS's your administrator actually has to enable the ability for rsh. Not 100% on that though. -Original Message- Kevin Sent: Wednesday, January 09, 2002 8:56 AM To: Multiple recipients of list ORACLE-L Kimberly, What is the format for the .rhosts file? I'm actually trying to work on something right as we speak. If I remember correctly the file gets stored on the server that you want to connect to and the contents are just: ip username where username is the name that you are logged in as on the server your COMING from if that makes any sense. Is this correct? Cheers, Kev. 'In Windows none can hear you scream' -Original Message- Sent: 09 January 2002 15:12 To: Multiple recipients of list ORACLE-L You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients of list ORACLE-L I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Stored Procedures Question
I received the DDL SQL script (approx. 11,000 lines of code) to generate a database from our other office in Malaysia. Along with this script I got another file with approx. 720 files called stored procedures with the suffix .PRC, .PKB, .PKS, .FNC. AND .TRG. When I go to generate the DB using the DDL SQL script how will these stored procedure files be used? Will the SQL script call them, or will they be called and used after the DB is built? Where should these stored procedure files be stored in the directory structure? The box is W2000 and Oracle is 8.1.7. Thanks much, Kenneth C. Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Stored Procedures Question
Ken, To see exactly how the stored procedure files will be used, you'll need to examine the DDL script to find out how they're called. That might tell you which directory in which to put them. If you have to run them manually, do it after the DDL script finishes. Execute (from SQL*Plus) all the *.PKS (Package Spec) files first, then the *.FNC (Function) and *.PRC (Procedure) files, followed by *.PKB (Package Body), then *.TRG (Triggers). If there are any functions that call procedures you may have to run the *.FNC files again, after the *.PRC. Since nothing can call a trigger, the *.TRG files are last, right after the *.PKB, since the code in the package bodies could call procedures or functions. If any views reference publice packaged variables, you may have to recreate those views. Check the Status column in User_Objects to see if anything ends up INVALID. You'll have to recompile... Alter Function x Compile ; Alter Package x Compile ; Alter Package x Compile Body ; ... Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, October 31, 2001 10:15 AM To: Multiple recipients of list ORACLE-L I received the DDL SQL script (approx. 11,000 lines of code) to generate a database from our other office in Malaysia. Along with this script I got another file with approx. 720 files called stored procedures with the suffix .PRC, .PKB, .PKS, .FNC. AND .TRG. When I go to generate the DB using the DDL SQL script how will these stored procedure files be used? Will the SQL script call them, or will they be called and used after the DB is built? Where should these stored procedure files be stored in the directory structure? The box is W2000 and Oracle is 8.1.7. Thanks much, Kenneth C. Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stored Procedures Question
Stored procedures will most typically be used by an application that uses the database. If the application does not use them explicitly, then there is most likely implicit use via triggers (ie triggers call procedure etc) hth connor --- Ken Janusz [EMAIL PROTECTED] wrote: I received the DDL SQL script (approx. 11,000 lines of code) to generate a database from our other office in Malaysia. Along with this script I got another file with approx. 720 files called stored procedures with the suffix .PRC, .PKB, .PKS, .FNC. AND .TRG. When I go to generate the DB using the DDL SQL script how will these stored procedure files be used? Will the SQL script call them, or will they be called and used after the DB is built? Where should these stored procedure files be stored in the directory structure? The box is W2000 and Oracle is 8.1.7. Thanks much, Kenneth C. Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Stored Procedures Question
I am not familiar with these suffixes (PKS, FNC etc). Are these store procedure files created by some software like Oracle Designer? Long -Original Message- Sent: Thursday, 1 November 2001 3:56 AM To: Multiple recipients of list ORACLE-L Ken, To see exactly how the stored procedure files will be used, you'll need to examine the DDL script to find out how they're called. That might tell you which directory in which to put them. If you have to run them manually, do it after the DDL script finishes. Execute (from SQL*Plus) all the *.PKS (Package Spec) files first, then the *.FNC (Function) and *.PRC (Procedure) files, followed by *.PKB (Package Body), then *.TRG (Triggers). If there are any functions that call procedures you may have to run the *.FNC files again, after the *.PRC. Since nothing can call a trigger, the *.TRG files are last, right after the *.PKB, since the code in the package bodies could call procedures or functions. If any views reference publice packaged variables, you may have to recreate those views. Check the Status column in User_Objects to see if anything ends up INVALID. You'll have to recompile... Alter Function x Compile ; Alter Package x Compile ; Alter Package x Compile Body ; ... Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, October 31, 2001 10:15 AM To: Multiple recipients of list ORACLE-L I received the DDL SQL script (approx. 11,000 lines of code) to generate a database from our other office in Malaysia. Along with this script I got another file with approx. 720 files called stored procedures with the suffix .PRC, .PKB, .PKS, .FNC. AND .TRG. When I go to generate the DB using the DDL SQL script how will these stored procedure files be used? Will the SQL script call them, or will they be called and used after the DB is built? Where should these stored procedure files be stored in the directory structure? The box is W2000 and Oracle is 8.1.7. Thanks much, Kenneth C. Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Stored procedures that return multiple rows
We're considering a mandate that all database access be via stored procedures (probably in packages). These would becalled eithervia OCCI (the C++ call interface) or JDBC. Myquestion is whether anyone's had experience in returninga result set from a PL/SQL procedure under thesecircumstances, and how it was implemented:did you return a ref cursor, an index-by table, a set of arrays? Any advice will be appreciated. Thanks! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED]
RE: Stored procedures that return multiple rows
Paul, Our applicationsdo database access solely though packaged pl/sql calls which return a ref cursor. Some use OCI, others JDBC. Experience has been very positive. Administrative advantages in having such an "abstraction layer" between apps and the database are manifold As a DBA, you have a lot of leeway to change things around on the back end w/o breaking the app. One drawback to the approach is that it requires more up-front planning on the app developers to identify the database calls. James Turner DBA Unplugged Games -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul BaumgartelSent: Thursday, August 23, 2001 4:11 PMTo: Multiple recipients of list ORACLE-LSubject: Stored procedures that return multiple rows We're considering a mandate that all database access be via stored procedures (probably in packages). These would becalled eithervia OCCI (the C++ call interface) or JDBC. Myquestion is whether anyone's had experience in returninga result set from a PL/SQL procedure under thesecircumstances, and how it was implemented:did you return a ref cursor, an index-by table, a set of arrays? Any advice will be appreciated. Thanks! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED]
RE: Stored procedures that return multiple rows
On my previous gig all DB access was via stored procedures returning ref cursors through JDBC. The Java dweebs could do just about anything with the ref cursor. It worked really well. I could actually tune SQL queries on the running production application without any recompilation. Nice seperation of code. The DBA can tune real SQL code and the developers won't even know. No embedded SQL. Yeah!! OCI can also accommodate ref cursors. Steve Orr -Original Message-From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 23, 2001 2:11 PMTo: Multiple recipients of list ORACLE-LSubject: Stored procedures that return multiple rows We're considering a mandate that all database access be via stored procedures (probably in packages). These would becalled eithervia OCCI (the C++ call interface) or JDBC. Myquestion is whether anyone's had experience in returninga result set from a PL/SQL procedure under thesecircumstances, and how it was implemented:did you return a ref cursor, an index-by table, a set of arrays? Any advice will be appreciated. Thanks! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED]
RE: Stored procedures that return multiple rows
Paul, For acouple of projects that I've worked on, several Java programmers have liked having Ref Cursors returned from PL/SQL stored procedures. They could work with those much more easily than PL/SQL tables. Can't remember if we even tried VArrays. I don't think I'd like them for returning table data - too much work to populate them. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul BaumgartelSent: Thursday, August 23, 2001 3:11 PMTo: Multiple recipients of list ORACLE-LSubject: Stored procedures that return multiple rows We're considering a mandate that all database access be via stored procedures (probably in packages). These would becalled eithervia OCCI (the C++ call interface) or JDBC. Myquestion is whether anyone's had experience in returninga result set from a PL/SQL procedure under thesecircumstances, and how it was implemented:did you return a ref cursor, an index-by table, a set of arrays? Any advice will be appreciated. Thanks! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED]
RE: Stored procedures that return multiple rows
I was about to write a similar testimonial when I saw Steve Orr's message. Don't use OCI based class111.zip. It has Oracle properity classes. The pure java class111.zip works great and is portable. Passing ref cursors from stored procedures makes the solution simple and elegent to implement. The seperation between the client rendering (HTML/Javascript/XML crowd) and middle tier Java servlets and Middle tier and RDBMS developer (using ref cursors over thin JDBC) is perhaps the best way to go. Avoid embeded SQL in Java if possible. Access to RDBMS via ref_cursor hides the DB schema from the Java developers making DB schema changes less painful and also allowing future switch of the databases if required, lot less painful. No meddling from Java folks too. I don't know how anybody decides on application partitioning issues as this division between business/domain objects and their persistence in the database raises all sorts of interesting design issues Regds --- Orr, Steve [EMAIL PROTECTED] wrote: On my previous gig all DB access was via stored procedures returning ref cursors through JDBC. The Java dweebs could do just about anything with the ref cursor. It worked really well. I could actually tune SQL queries on the running production application without any recompilation. Nice seperation of code. The DBA can tune real SQL code and the developers won't even know. No embedded SQL. Yeah!! OCI can also accommodate ref cursors. Steve Orr -Original Message- Sent: Thursday, August 23, 2001 2:11 PM To: Multiple recipients of list ORACLE-L We're considering a mandate that all database access be via stored procedures (probably in packages). These would be called either via OCCI (the C++ call interface) or JDBC. My question is whether anyone's had experience in returning a result set from a PL/SQL procedure under these circumstances, and how it was implemented: did you return a ref cursor, an index-by table, a set of arrays? Any advice will be appreciated. Thanks! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Implementing Stored Procedures
Title: Implementing Stored Procedures Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications. Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original source code for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa
RE: Implementing Stored Procedures
Lisa, This is what we did in my last project: 1. Developers had access to the application schema where they created and modified procedures/functions/triggers as needed 2. After their unit testing is done, the QA team would test it using the front-end application. 3. Once QA team approves the new/enhanced functionality, the developers would check in the code using PVCS and notify the DBA vith the PVCS version number and the object name. 4. The DBA tracks the object version numbers along with the application releases and implements the necessary changes in the production box. Developers did not have any rights on the production box. HTH! Prakash -Original Message- Sent: Thursday, May 31, 2001 1:02 PM To: Multiple recipients of list ORACLE-L Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications.Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original source code for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Implementing Stored Procedures
We put the code in a file on Unix (our server platform) and in the change request form, provide the file name and location. The DBA will log in as the schema owner and simply run the file. Any errors are reported back to developer who requested the change. All the SQL code is archived using SCCS. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 Title: Implementing Stored Procedures We put the code in a file on Unix (our server platform) and in the change request form, provide the file name and location. The DBA will log in as the schema owner and simply run the file. Any errors are reported back to developer who requested the change. All the SQL code is archived usingSCCS. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art !
RE: Implementing Stored Procedures
There's an excellent tool by the company Kintana that automates the deployment of software (which can include stored packages and procedures, as well as shell scripts, SQL*Loader, whatever). The developer creates a release with the file names and version numbers in PVCS or ClearCase, and the tool extracts and runs the approprate files on other servers as determined by workflows -- so you can use this tool to go from dev to QA to production, etc. Very nice tool, I'd highly recommend it. And no, I am not affiliated, just a happy user. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Bala, Prakash prakash.bala@cinTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] gular.com cc: Sent by: Fax to: [EMAIL PROTECTED] Subject: RE: Implementing Stored Procedures 05/31/2001 02:46 PM Please respond to ORACLE-L Lisa, This is what we did in my last project: 1. Developers had access to the application schema where they created and modified procedures/functions/triggers as needed 2. After their unit testing is done, the QA team would test it using the front-end application. 3. Once QA team approves the new/enhanced functionality, the developers would check in the code using PVCS and notify the DBA vith the PVCS version number and the object name. 4. The DBA tracks the object version numbers along with the application releases and implements the necessary changes in the production box. Developers did not have any rights on the production box. HTH! Prakash -Original Message- Sent: Thursday, May 31, 2001 1:02 PM To: Multiple recipients of list ORACLE-L Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications.Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original source code for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http
RE: Implementing Stored Procedures
Title: Implementing Stored Procedures One option (and I'm not suggesting that this is the BEST option by any means, but it IS an option =) might be to grant the developer(s) the 'CREATE ANY PROCEDURE' role, and then have them create their procedures/functions/packages etc as schema_name.object_name, with schema_name being the name of the application schema that the object will need to be in. -::YEX::- ))) -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, 31 May, 2001 13:02 PMTo: Multiple recipients of list ORACLE-LSubject: Implementing Stored Procedures Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications. Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original "source code" for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa
RE: Implementing Stored Procedures
Title: Implementing Stored Procedures hi lisa, we do have staging area (dba -directory)inproductionwhere all the scripts ...(sql,forms,reports) are kept and with change request forms they are implemented... if any problems with the scripts they willl go to owner of change requester. And We use version control (PVCS, MS visual source safe) to track changes done to the prodecures and scripts. naren -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, June 01, 2001 5:02 AMTo: Multiple recipients of list ORACLE-LSubject: Implementing Stored Procedures Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications. Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original "source code" for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa
RE: Stored procedures, functions and packages
You can use describe in SQL*Plus to look at the arguments (parameters) only. HTH - Bhat -Original Message- From: Carlos Porras [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 7:01 AM To: Multiple recipients of list ORACLE-L Subject:Stored procedures, functions and packages Hi all, Gurus. Is there a view or synonym that stores the declaration part of procedures, functions and/or packages?. That is, something like SYS.argument$, user_arguments or all_arguments (useful for example to access the arguments of stored procedures and functions in an easy, structured way), but in this case of course only related to variables, types, constants, etc. (that is, the declaration part within the stored procedures, functions and packages)? Thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carlos Porras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Stored procedures, functions and packages
Hi all, Gurus. Is there a view or synonym that stores the declaration part of procedures, functions and/or packages?. That is, something like SYS.argument$, user_arguments or all_arguments (useful for example to access the arguments of stored procedures and functions in an easy, structured way), but in this case of course only related to variables, types, constants, etc. (that is, the declaration part within the stored procedures, functions and packages)? Thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carlos Porras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
