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
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
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:
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
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
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
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
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
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
34 matches
Mail list logo