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
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
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
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
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,
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
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:
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
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,
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
]
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
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
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
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
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
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
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
.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
: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
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
, 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
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
, 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
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
[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
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
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
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 vers
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
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
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
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
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
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
-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
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
, 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
by: Subject: call vs execute - stored
procedures
[EMAIL PROTECTED]
m
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
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
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
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
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
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
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
: 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
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
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
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
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
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
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
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
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
by: Fax to:
[EMAIL PROTECTED] Subject: 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
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
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
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
90 matches
Mail list logo