PL/SQL Developer.
http://www.allroundautomations.nl/plsqldev.html
very very good.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL
, is it?)
-Original Message-
Sent: Wednesday, August 28, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
Well, since someone else cares to mention it, I do use Procedure Builder,
Oracle's PL/SQL development tool from Developer and I like it a lot. The
latest
version even does syntax
can you please post URL's for these? thanks
-Original Message-
Sent: Wednesday, August 28, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L
I'll second that -- I haven't used Benthic's PL/SQL editor very much, but
I use Golden almost religiously as a replacement for SQL*Plus
Well, I will throw our hat in. Compuware has a tool called DevPartner DB
Tuner Debugger that can be used to create, optimize, tune and debug both
SQL PL/SQL. Great tool (yes I do use it quite a bit) for PL/SQL profiling
and debugging of code.
www.compuware.com
Thank You
Stephen P
Emace with PL/SQL+SQLplus mode.
It is KISS. :=)
mvh
HEnrik
--- [EMAIL PROTECTED] wrote:
Hi All,
which is the best PL/SQL editor available
as a trial version .
the editor should support Oracle
sql,PL/SQL
and may or may not
support debugging.
The tool should
Check www.benthicsoftware.com
I've used Golden for a couple years now and love it for the same reasons as
Philip... I also use PLEdit (their PL/SQL editor)... Similar to Golden in
that it is simple and fast... Not as powerful as some of the others tools
but not too bad either...
Tim
: Tuesday, August 27, 2002 1:03 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle 81745 upgrade and PL/SQL version
Hi,
Yesterday I upgraded a database from 81725 to 81745 on W2K SP3 (the DB
doesn't have JVM in it).
Before the upgrade, product_component_version showed the PL/SQL
.
At this stage I queried product_component_version and the PL/SQL version was shown as
8.1.7.3.
It seems no-one else has seen this.
I'll repeat the upgrade on 2 other databases (with and without JVM installed) and see
if I can learn more.
Thanks,
Bruce
-Original Message-
Sent: Tuesday, 27 August
BDY.RTF
Description: RTF file
Try free Toad at http://www.toadsoft.com/downld.html
regards
Ofer Harel
DBA team
Barak ITC
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
Hi All,
which is the best PL/SQL
Hi,
Yesterday I upgraded a database from 81725 to 81745 on W2K SP3 (the DB doesn't have
JVM in it).
Before the upgrade, product_component_version showed the PL/SQL version as version
8.1.7.2.0.
After the upgrade, the PL/SQL version is shown as 8.1.7.3.
The product_component_version table
Before the upgrade, product_component_version showed the PL/SQL
version as version 8.1.7.2.0.
After the upgrade, the PL/SQL version is shown as 8.1.7.3.
Hmmm, weird.
Mine is W2K, no SP, JVM installed.
8.1.7.0.0,upgraded to 8.1.7.4.1.
PL/SQL shows as 8.1.7.4.0
I don't know at this stage
, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.
PL/SQL snippets
...snip...
marketingcode
Tom - Thanks to you and everyone else for the great suggestions. He and I
are sitting down tomorrow to straighten this out. I was concerned that there
might be some PL/SQL oddity that I wasn't aware of (he is a pretty good
PL/SQL programmer). I appreciate your ruling that out.
Dennis Williams
I have a question for from one of my developers related to PL/SQL and how
data is loaded.
I have a field (marketcode) that is defined as VARCHAR2(3).
I have a problem when I try to load the value of '20' into this field.
All values with three characters work fine. The problem is when
that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
I have a question for from one of my developers related to PL/SQL and how
data is loaded.
I have a field
Is the field in question in table C defined as CHAR or VARCHAR2? If CHAR
that is why it is blank padded. Check datatype of variables
in pl/sql
Rick
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that TRIM is new, but I thought it needed additional parameters to
tell it what to trim.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.
PL/SQL snippets
...snip...
marketingcodeVARCHAR2(3);
...snip...
FILELOCATION
Check the definition of table C. It sounds like it is defined as CHAR(3) instead of
VARCHAR2(3). I would also check the PL/SQL for using CHAR instead of VARCHAR2 for
storing the value -- the trim should have eliminated this problem if it was put in the
right place.
Kevin Kennedy
First Point
:www.compuware.com
-Original Message-
Sent: Wednesday, August 21, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQl question
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that TRIM is new, but I thought it needed
um...just a thought but how about setting
marketingcode to char(3) in the PL/SQL code snippet.
I ran into this similar problem a couple days ago.
Had a var as varchar2 in PL/SQL but in the table it
was char. Changed my PL/SQL var to char, cursor in my
code worked with ltrim and rtrim functions
setting
marketingcode to char(3) in the PL/SQL code snippet.
I ran into this similar problem a couple days ago.
Had a var as varchar2 in PL/SQL but in the table it
was char. Changed my PL/SQL var to char, cursor in
my
code worked with ltrim and rtrim functions whereas
before it wasn't.
hth
-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.
PL/SQL
-Original Message-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice
Any idea how to schedule the execution of a PL/SQL package? and if a certain
condition is acomplished to execute again (later in the night) the same
package until the same condition is not anymore fulfilled?
In PL/SQL not using a script for the operating system for example.
Ciprian MAFTEI
how to schedule the execution of a PL/SQL package? and if a certain
condition is acomplished to execute again (later in the night) the same
package until the same condition is not anymore fulfilled?
In PL/SQL not using a script for the operating system for example.
Ciprian MAFTEI
Telequote
I know how.
Ciprian MAFTEI
Telequote Network
Computer Systems Analyst
Any idea how to schedule the execution of a PL/SQL package? and if a
certain condition is acomplished to execute again (later in the
night) the same package until the same condition is not anymore fulfilled?
In PL
Title: RE: how to schedule an execution in PL/SQL
hi!
i guess you should just have a look at the DBMS_JOB package!
i would start with reading the documentation of this standard
oracle package.
cheers
-dieter
-Original Message-
From: mac [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
Check out the DBMS_JOB supplied plsql package
hth
connor
--- mac [EMAIL PROTECTED] wrote: Any idea how to
schedule the execution of a PL/SQL
package? and if a certain
condition is acomplished to execute again (later in
the night) the same
package until the same condition is not anymore
Does that actually convert PL/SQL to java, or just put some sort of java
wrapper around the PL/SQL?
John
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: 16 August 2002 07:23
To: Multiple recipients of list ORACLE-L
Subject: Re: Convert PL/SQL
What about SQLJ? You can wrap the entire PL/SQL code inside a SQLJ file and
use it as such without converting it into Java
HTH
Naveen
-Original Message-
Sent: Monday, August 19, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L
Does that actually convert PL/SQL to java, or just
Title: RE: pl/sql exception and whenever sqlerror
(see answer below - What a difference, a raise makes!)
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
I have a command procedure running a sql*plus script that
then runs a stored
procedure. (This is VMS
Good morning,
Does anybody know of a utility that can convert PL/SQL code to Java code??
Thanks in advance for any replies.
Barry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Hello,
I need a nice PL/SQL editor any advice ?
Thx for any advice
Regards
W.B
__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Place
-Original Message-
Sent: Thursday, August 15, 2002 11:09 AM
I need a nice PL/SQL editor any advice ?
I prefer vi myself but your probably looking for something like
http://www.indus-soft.com/winsql/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farrell
Free OraEdit
http://www.dkgadvancedsolutions.com/oraedit.htm
JP
On Thursday 15 August 2002 17:09, you wrote:
Hello,
I need a nice PL/SQL editor any advice ?
Thx for any advice
Regards
W.B
__
Do You Yahoo!?
HotJobs - Search Thousands
vi or vim.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Place for oracle [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: PL/SQL Editor.
Hello,
I need a nice PL/SQL editor any
I like RapidSQL from Embarcadero - but it's a bit pricy
for a pretty good and less expensive alternative try PL/SQL Developer from
allroundautomations
-bill
-Original Message-
Sent: Thursday, August 15, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Hello,
I need a nice PL
Title: RE: PL/SQL Editor.
Hi,
I use Emacs with PL/SQL module and Sqlplus.el
Really nice and easy to use.
Best Regards
Henrik
-Original Message-
From: Place for oracle
To: Multiple recipients of list ORACLE-L
Sent: 8/15/2002 5:09 PM
Subject: PL/SQL Editor.
Hello,
I need
:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: PL/SQL Editor.
Hello,
I need a nice PL/SQL editor any advice ?
Thx for any advice
Regards
W.B
__
Do You Yahoo
: Thursday, August 15, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject:PL/SQL Editor.
Hello,
I need a nice PL/SQL editor any advice ?
Thx for any advice
Regards
W.B
__
Do You Yahoo!?
HotJobs - Search
recipients of list
ORACLE-L
Subject: Re:RE: PL/SQL Editor.
Scott,
vi, your dinosaur side is showing!! *-)
Dick Goulet
Reply Separator
Subject:RE: PL/SQL Editor.
Author: [EMAIL PROTECTED]
Date: 8/15/2002 8:38 AM
vi or vim
Scott,
Dinosaur? When you have a good product it stays around for lng
time.
The complaints that I have with TOAD is that the pl/sql packages when
converted to text have a lot of white space due to the formatting.
Designer is not as bad but still has white space. I like to have the
developers
-Original Message-
Scott,
vi, your dinosaur side is showing!! *-)
Oh come on. He included vim. ;
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)
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 11:43 AM
To: [EMAIL PROTECTED]; Multiple recipients of list
ORACLE-L
Subject: Re:RE: PL/SQL Editor.
Scott,
vi, your dinosaur side is showing!! *-)
Dick Goulet
DevPartner DB Tuner, Debugger Profiler for PL/SQL from Compuware.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Thursday, August 15
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: PL/SQL Editor.
Scott,
Dinosaur? When you have a good product it stays around for lng
time.
The complaints that I have with TOAD is that the pl/sql packages when
converted to text have a lot of white space due to the formatting
I didn't see a reply to this but apparently Jdeveloper 9i can do this
From the 91 Help file
Generating Java Source Code for Oracle Objects and PL/SQL Packages
To generate Java classes for an object type or package, right-click an
object type or package in JDeveloper's Navigator pane. You can
over to well...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 11:43 AM
To: [EMAIL PROTECTED]; Multiple recipients of list
ORACLE-L
Subject: Re:RE: PL/SQL Editor.
Scott
Message --
Date: Tue, 13 Aug 2002 14:34:13 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Danny Hughes [EMAIL PROTECTED]
Subject: nextval increments by 2 in pl/sql procedure
hello all,
I have a pl/sql procedure that selects the nextval from
for the
value from the sequence by any other session.
Naveen
-Original Message-
Sent: Wednesday, August 14, 2002 4:04 AM
To: Multiple recipients of list ORACLE-L
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence
the sequence by any other session.
Naveen
-Original Message-
Sent: Wednesday, August 14, 2002 4:04 AM
To: Multiple recipients of list ORACLE-L
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence by 2 in a pl
ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Danny Hughes [EMAIL PROTECTED]
Subject: nextval increments by 2 in pl/sql procedure
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence by 2 in a pl
OK, I admit up front I'm not a pl/sql programmer. And I really did try to
look this up. Honest.
Took me a VERY long time to figure this out, but here it is...
I have a command procedure running a sql*plus script that then runs a stored
procedure. (This is VMS, but I think it would work
;
exception when others then raise_application_error( -20001,'An error');
end;
Regards,
Waleed
-Original Message-
Sent: Wednesday, August 14, 2002 6:08 PM
To: Multiple recipients of list ORACLE-L
OK, I admit up front I'm not a pl/sql programmer. And I really did try to
look this up. Honest
Barb,
Hee hee! Oldest PL/SQL mistake in the book -- to handle an exception
improperly without passing it on...
It sounds like the duhveloper coded the exception block as follows:
exception
when others then
dbms_output.put_line('A serious error has occurred');
end
To: Multiple recipients of list ORACLE-L
Hi All,
I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).
I tried to run the initplsj.sql and got the following error.
Can you guys tell me what should I do to correct this?
SQL @initplsj.sql
call dbms_java.set_output(1
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The problem is
that it incrrements the sequence by 2 in a pl/sql procedure. If I select the nextval
from a sqlplus session, it works fine.
here is partial code that I am using.
PROCEDURE NEWTRANSACTION
Hi All,
I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).
I tried to run the initplsj.sql and got the following error.
Can you guys tell me what should I do to correct this?
SQL @initplsj.sql
call dbms_java.set_output(1)
*
ERROR at line 1:
ORA
before, but can't find my notes, so please forgive this same old question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part of a post startup
trigger. Help?
TIA,
John P Weatherman
Database Administrator
OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part of a post
You have to write an external stored procedure (C, C++, Java) and call it
from your PL/SQL block.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:56 PM
OK, I checked Google and my
old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old
question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part of a post
startup
trigger. Help?
TIA,
John P
/SQL blocks
OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old
question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part
Yes, But why then we can issue DLL in PL/SQL using
DBMS_SQL package.
-Original Message-
From: Alroy Mascranghe [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Why DDL is not allowed in PL/SQL
Maybe
] Subject: PL/Sql Error Handling Package
Thanks!
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 5:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:PL/Sql Error Handling Package
Hanah,
This is one procedure out of an entire
You can also use execute immediate in PL/SQL, depending on the version of
Oracle you are running.
RF
Robert G. Freeman - Oracle8i OCP
Oracle Database Architect
CSX Midtier Database Administration
Author:
Oracle9i RMAN Backup and Recovery (NEW! Oracle Press - Due Oct 2002!!)
Oracle9i New
We have package for logging diferent errors like
1. user error -- for user defined exception
2. system error -- for system exception
3. other error -- for other error
4. debug -- for debug logging
every time an exception is caught , based on type a satus is returned to
calling program at the
I would guess because it's not part of PL/SQL.
The DBMS_SQL package and 'EXECUTE IMMEDIATE' both send
your SQL to the database engine.
You may recall the the engine running PL/SQL is separate from the
DBMS engine, at least through 8i.
Jared
sam d [EMAIL PROTECTED]
Sent by: [EMAIL
Amy one have any decent stanard error handling packages or link to advice on creating
such a package?
Thanks,
Hannah
--
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
Sam,
If u r in 8i and above
You could use
execute immediate 'create table .';
Regards
Suhen
Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.
Curious
Sam
__
Do
,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.
Curious
Sam
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official
I am in the process of writing a pl/sql block to run on instance A. At one
point, I need to run a procedure that resides in instance B against instance
B's dataset. Is there an easy way to do this?
The basic problem is:
### Set up Instance Source for replication
Weatherman wrote:
I am in the process of writing a pl/sql block to run on instance A. At one
point, I need to run a procedure that resides in instance B against instance
B's dataset. Is there an easy way to do this?
The basic problem is:
### Set up Instance Source for replication
Weatherman wrote:
I am in the process of writing a pl/sql block to run on instance A. At
one
point, I need to run a procedure that resides in instance B against
instance
B's dataset. Is there an easy way to do this?
The basic problem is:
### Set up Instance Source for replication
you will have to use dynamic sql to do what you want to do.
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
Title: PL/SQL proc calls to a remote DB via DB link
Listers:
You have 2 DBs, L local, R remote. From within a PL/SQL package or procedure on the *local* DB, is it legal to:
declare a local variable using a *remote* type:
MyVar_L userR.pkgR.typeR@dblinkR;
or call a *remote* procedure
Title: PL/SQL proc calls to a remote DB via DB link
Try
it, you might like it. You might also get your answer quicker than asking
the list.
I
can't find a place where I defined a variable using a remote package but I seem
to remember doing the same type of thing using remote tables
Hallo,
Anyone who has any good hint on how to write pl/sql if i wantto chang ethe name
of the fields everytime the procedur runs?
The field names should be 1-JULI-2002 the first time the procedur runs, the next time
the procedur runs the name of procedur should be 1-AUG-2002 etc.
Please help
of Java code
I run javac to compile it, then loadjava the class file into the DB. I can
then create a PL/SQL procedure as a wrapper:
CREATE OR REPLACE PROCEDURE qlp_proc (file_and_parms IN VARCHAR2)
AS LANGUAGE JAVA
NAME 'qlp.main (java.lang.String[])';
/
And it works, but I need to test for success
a PL/SQL procedure as a wrapper:
CREATE OR REPLACE PROCEDURE qlp_proc (file_and_parms IN VARCHAR2) AS
LANGUAGE JAVA
NAME 'qlp.main (java.lang.String[])';
/
And it works, but I need to test for success/fail. But if I try a
FUNCTION
wrapper:
CREATE OR REPLACE FUNCTION qlp_func (file_and_parms
Hi,
Like this any sqlplus or pl/sql message board where I
can clear doubts.
Thanks,
Ravi
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Type problems with PL/SQL function as a Java wrapper.
Main is a reserved function in Java you cannot use that in your
programs.
I just did this by changing the name to test
oracle developer tools users group. www.odtug.com
maintains a list at fat city.
--- Nalla Ravi [EMAIL PROTECTED] wrote:
Hi,
Like this any sqlplus or pl/sql message board where
I
can clear doubts.
Thanks,
Ravi
__
Do You Yahoo
Hi Peter,
Thanks
--- Peter Barnett [EMAIL PROTECTED] wrote: oracle
developer tools users group. www.odtug.com
maintains a list at fat city.
--- Nalla Ravi [EMAIL PROTECTED] wrote:
Hi,
Like this any sqlplus or pl/sql message board
where
I
can clear doubts.
Thanks
BDY.RTF
Description: RTF file
If you're on 8i+ you can use java to get the value.
hth
connor
--- [EMAIL PROTECTED] wrote: Hi ,
I want to use a unix shell variable value in
PL/SQL.
Is it possible,if yes then how..give example.
for e.g at unix prompt : export inp_val=2000
Thanks
Manoj.
=
Connor
You can call them by building a wrapper in the Java in DB and have it call
the external procedure. You can expose that internal Java to the PL/SQL
RTFM and get back with any further queries. The Oracle Java documents have
quite a bit of useful info on this
Cheers
Somebody knows how to translate PL/SQL to C or C++ (ROBOT, Software...)
regards
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
main()
{
EXEC SQL CONNECT scott/tiger@prod;
EXEC SQL EXECUTE IMMEDIATE pl-sql-block-text;
EXEC SQL COMMIT WORK RELEASE;
}
Or something like that...
What are the reasons for converting PL/SQL to C/C++? There are some things
(i.e. operating-system integration, string manipulation
Somebody knows how to translate PL/SQL to C or C++
(ROBOT, Software...)
regards
Think that 9i has something of the kind ('native compiler') to boost the performance
of stored procedures. However, I don't think that you have access to the C code
proper, as you can with Pro*C for instance. My
On Metalink look at the Note 151224.1 (PL/SQL Native Compilation in
Oracle9i).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 9:13 AM
Somebody knows how to translate PL/SQL to C
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=151224.1
-Original Message-
Sent: Wednesday, May 15, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Somebody knows how to translate PL/SQL to C or C++
(ROBOT, Software...)
regards
This is kind of a Kludge response. Hopefully, someone
has a better idea, but try wrapping it in Pro C, run
it through the compiler and use the generated C code.
--- Bernard, Gilbert
[EMAIL PROTECTED] wrote:
Somebody knows how to translate PL/SQL to C or C++
(ROBOT, Software...)
regards
: Stephane Faroult[EMAIL PROTECTED]
Subject: RE: How to translate PL/SQL to C
Somebody knows how to translate PL/SQL to C or C++
(ROBOT, Software...)
regards
Think that 9i has something of the kind ('native compiler') to boost the
performance of stored procedures. However, I don't think that you
We have a developer who has asked this question. How
do you call an external java class from a pl/sql
stored procedure?
You can stick my knowledge of java in a thimble. Can
this be done, if so can you point me to a url with an
example or two.
Thanks,
Pete
=
Pete Barnett
Lead
As is often the case, rtfm. Should have dug deeper
first!
--- Peter Barnett [EMAIL PROTECTED] wrote:
We have a developer who has asked this question.
How
do you call an external java class from a pl/sql
stored procedure?
You can stick my knowledge of java in a thimble.
Can
Hi, Pete,
PL/SQL has an interface to built-in Oracle JServer. You can load external
class here and call it, but at this point class is not external anymore,
right?
If you need access to the class on a different JVM - true external class,
Java provides you RMI, EJB, Corba interfaces. Oracle
501 - 600 of 1314 matches
Mail list logo
